How to Freeze Rows in Google Sheets (Quick & Easy Shortcut)

Watch video – How to Freeze Rows and Columns in Google Sheets

When you’re working with large datasets in Google Sheets, you will have to often scroll down or to the right.

And when you’re doing it, you may want to keep the rows and columns visible – so that you can figure out what a data point means and what row/column are you looking at.

To do this, you need to freeze rows and columns in Google Sheets.

And you can easily do this using the Freeze Panes option in Google Sheets.

When you freeze rows in Google Sheets, it will keep these rows visible when you scroll down. Similarly, when you freeze columns, these columns will be visible when you scroll to the right.

Something as shown below:

Freeze the top row ny using the mouse drag and drop

So let’s see how to quickly lock some rows and columns in Google Sheets so that these are always visible.

Freeze Rows in Google Sheets Using the Mouse (Shortcut)

I love how easy it is to freeze rows and columns in Google Spreadsheets. All you have to do is use the mouse, click and drag, and it’s done.

Suppose you have the dataset as shown below and you want to freeze the top row in this dataset (as of now, when you scroll down, the headers disappear completely).

Data where rows are not frozen

Below are the steps to freeze the first row in Google Sheets:

  1. Take your cursor to the top-left corner part of the worksheet area. There would be a blank gray box with two thick gray lines (as shown below).
  2. Hover the cursor over the horizontal gray line. You will notice that the cursor changes to a hand icon.
  3. Hold the left-mouse key and drag this line down. Since you only want to freeze the top of the row, bring this line just below the first row and leave the mouse key.

That’s it!

Freeze the top row ny using the mouse drag and drop

The first row has been frozen and now when you scroll down, you will notice that the header row is always visible (and it only takes a second to do this).

In case you have multiple header rows that you want to freeze, you can simply drag and drop the gray line after these rows.

Similarly, you can also freeze the column. With columns, you will have to take the cursor to the vertical gray line and drag it to the right. Drop the line after the column(s) that you want to freeze

Freeze Rows in Google Sheets Using the Menu Options

Another way to quickly freeze rows and columns in Google Spreadsheets is to use the option in the menu.

Again, suppose you have the dataset as shown below and you want to freeze the top row in this dataset.

Data in which you want to freeze the top row

Below are the steps to freeze rows in Google Sheets using the View menu options:

  1. Click the View option in the menuClick the view tab in the menu
  2. Hover the cursor over the Freeze option
  3. In the options that appear, click on the ‘1 row’Click on 1 row to freeze the first row in the worksheet

The above steps would freeze the top-most row of the worksheet.

Similarly, you can use the above steps to freeze two rows or one/two columns.

But what if you want to freeze more than two rows – let’s say you want to freeze five rows?

Below are the steps to freeze more than two rows in Google Sheets:

  1. Select any cell in the fifth row. This is because we want to freeze until the fifth row.
  2. Click the View option in the menuClick the view tab in the menu
  3. Hover the cursor over the Freeze option
  4. In the options that appear, click on the Up to current row (5)Click on up to current row to freeze more than two rows

The above steps would instantly lock the first five rows so these are always visible when you scroll down.

Similarly, if you want to lock the first three columns so that these are always visible, select any cell in the third column and choose Up to current column (C) in step 4.

You cannot freeze both rows and columns simultaneously; you will first have to freeze the rows and then the columns.

How to Unfreeze Rows in Google Sheets

What can be frozen can easily be unfrozen in Google Sheets.

You need to use the same steps you used to freeze the rows and columns to unfreeze them.

Again, you can use the mouse to simply drag and bring back the gray lines to the original position, or you can use the Freeze option in the View menu to unfreeze the rows and columns.

Below are the steps to unfreeze rows and columns in Google Sheets:

  1. Click the View option in the menu
  2. Hover the cursor over the Freeze option.
  3. Click on No Row.
  4. Again, click on the View option.
  5. Hover the cursor over the Freeze option.
  6. Click on No Column.

Select No row and No column to unfreeze in Google Sheets

That’s it!

Now you know how to freeze panes in Google Sheets and be a lot more efficient when working with large datasets.

You may also like the following Google Sheets tutorials:

Leave a Comment