Watch Video – How to Freeze / Lock Rows and Column in Google Sheets
You may want to freeze/lock rows in Google Sheets if you’re working with a large dataset that requires you to scroll up and down a lot.
Freezing rows at the top would make those rows visible all the time so that you never lose a track of what column represents what metrics.
Something as shown below:
In the above example, the first row has been frozen so that it is always visible when you go down the data set.
In this tutorial, I will show you two ways to quickly freeze rows in Google Sheets.
This is a super quick way to freeze rows in Google Sheets.
Go to the top left part of the sheet where you’ll see an empty gray box. Note that there are two thick gray lines in that box (on the right and to the left).
All you need to do is hover your mouse on the gray line, and when you see the hand icon, left-click and drag it down.
This will instantly freeze all the rows above the gray line (as shown below):
While the mouse trick (shown above) is super handy, there is another way to freeze rows in Google Sheets.
Here are the steps:
This would freeze all the rows including and above the one selected.
Also, note that Google Sheets provide 2 default options – Freeze the top row or freeze the top two rows.
Again there are two ways to unfreeze the frozen rows in Google Sheets:
Related: How to use Freeze Panes in Excel
You May Also Like the Following Google Sheets Tutorials:
Using FILTER Function in Google Sheets (explained with Examples)
How to Search in Google Sheets and Highlight the Matching Data
How to Use OR Function in Google Sheets (with Examples)
How to Use IMPORTRANGE Function in Google Sheets (with Examples)
How to Use IMPORTDATA function in Google Sheets