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

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

Freeze Rows in Google Sheets - Using mouse

#2 Freeze Rows 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.

Also, note that Google Sheets provide 2 default options – Freeze the top row or freeze the top two rows.

Unfreezing the frozen Rows

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.

Related: How to use Freeze Panes in Excel

You May Also Like the Following Google Sheets Tutorials:


10 Google Sheets Tips that will save you hours every week

Bar Sparkline in Google Sheets - rtl
Google Sheets

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

Google Sheets

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google

Google Sheets Keyboard Shortcuts - Spreadsheets
Google Sheets

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.

  • >