Thank you for subscribing!

It's great to feel loved.

How to Freeze a Row in Google Sheets

Dec 12, 2019 2 min read

If you use sheets, you probably know that when you scroll down, your top data or the headers disappear. Likewise, when you scroll to the right the data at the side columns disappear; this could be problematic if you are working with a large dataset.

For instance, in big rows of sheets, while scrolling down, you can forget what column A, B or C corresponds to. Thereby you may want your top row to be frozen. When you freeze row in Google sheets that row will always be visible while scrolling in any direction. In case you want to make everything simpler try Google sheets integration with Whatagraph.

How to Freeze a Row in Google Sheets

Freezing row in Google sheets is not difficult if you are familiar with the Google sheets interface. The following are two ways you can freeze rows in Google sheets spreadsheet.

Freeze Rows in Google Sheets Short Cut

  1. Firstly, the easiest way to freeze rows in Google sheet is to go to the top left part of your spreadsheet. You will see an empty grey box right before A row and top of the 1 column;
  2. Put your mouse over the border of that grey box, hold on it until your cursor changed into a hand icon, left click and drag it down to the first row- if you want to freeze only 1 row;
  3. You can drag it down to two or three rows if you want to freeze two, three or more rows;
  4. Likewise, you can hold the right end of the grey box and drag the border to the right to freeze any number of columns.
freeze 4 rows in Google Sheets   freeze 3 rows in Google Sheets

 

Freeze Rows in Google Sheets Menu Option

To freeze the Google sheets top row:

  1. Go to the top menu, and click the View, a drop-down menu will open up;
  2. Click on the first option that is freeze;
  3. You will see more options, choose the 1row option if you want to freeze only the first row;

Now your top row is freeze, and you can always see it while scrolling up or down.

Freeze Rows in Google Sheets Menu Option    

How to Freeze Multiple Rows in Google Sheets

There are other options if you want to freeze four rows at a time, select the cell from the row you wish to freeze up to, click view>freeze>freeze the current number of rows (4).

If you want to freeze two, three or five rows, select a cell from that row and select the view icon from the top menu, then click freeze and at last select freeze to the current number (your desired row will appear in bracket).

You can freeze the column 1, column 2 or select the cell you wish to freeze the column or rows up to. Select View from the top menu bar, then click freeze and select up to current column (X) option. X represents up to whatever column you have chosen.

How to Unfreeze Rows and Columns in Google Sheets

If you want to unfreeze row or column you can drag the grey border back to its original place- in the top left empty grey box, or you can:

  1. Select the row or column you want to unfreeze;
  2. Navigate to the top menu, click View, and then tap freeze;
  3. At last, click on No rows or No columns from the freeze menu.

Hopefully, now you know how to freeze rows and columns in Google sheets. 

Mike
Written by Mike

Former data analyst and the head of Whatagraph blog team. A loving owner of two huskies, too.

To solve the problems of duplications in your workflow, documentation, and data analysis, Google introduced a Google sheet platform that offers a built-in feature to remove duplicates.
Read more...
Mike
Jun 09, 2020 3 min read
If you’re into digital marketing and CEO, you probably know how much information you have to track and evaluate on a regular basis. Luckily, there’s a free Google sheet analytics add-on that will make it easier for you to access, visualize, understand, share and manipulate data from your Google Analytics in your Google Sheet.
Read more...
Mike
Feb 03, 2020 5 min read
Add-Ons are third party plugins that add more features in your spreadsheets and provide additional functionality to already powerful Google Sheets.
Read more...
Krystyna Krajevskaja
Jan 31, 2020 6 min read