How to Quickly Freeze / Lock Rows in Google Sheets

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:

Freeze / Lock Rows in Google Sheets - demo

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 how to quickly freeze rows in Google Sheets.

#1 Freeze / Lock Rows in Google Sheets Using the Mouse

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 lock all the rows above the gray line (as shown below):

Freeze Rows in Google Sheets - Using mouse

#2 How to Lock a Row in Google Sheets Using the View Options

While the mouse trick (shown above) is super handy, there is another way to freeze rows in Google Sheets.

Here are the steps:

  • Select the cell in the column till which you want the rows to be frozen. For example, if you want the top five rows to be frozen, select the cell in row 5.
  • Go to View –> Freeze –> Up to Current Row (5). Note that the number in the parenthesis would change based on what cell you have selected.

This would freeze all the rows including and above the one selected.

Google Sheets provide 2 default options — Freeze the top row or freeze the top two rows.

Note: Using this method is also useful if you want to know how to freeze a column in Google Sheets. 

How to Unfreeze Rows in Google Sheets

Again, there are two ways to unfreeze the frozen rows in Google Sheets:

  • Using Mouse: Hover the mouse over the thick gray line that appears right below the last row that has been frozen. Left click and drag it to bring it to the top. This will unfreeze all the frozen rows.
  • Using View Options: Go to View –> Freeze –> No Rows.



We hope this tutorial was helpful for you, and that you are now an expert on how to freeze rows in Google Sheets, as well as how to freeze columns.

Related reading: 10 Google Sheets Tips that’ll Help You Get Work Done Faster

Spreadsheet Expert at Productivity Spot | Website | + posts

Google Sheets and Microsoft Excel Expert.