Thank you for subscribing!

It's great to feel loved.

How to Freeze a Row in Google Sheets

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. 

Safe reporting time

Mike Bennet
Written By Mike Bennet
Automated Access to Google Analytics Data in Google Sheets
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.
Top 10 Google Sheets Add-Ons and Tools to Supercharge Your Work
Add-Ons are third party plugins that add more features in your spreadsheets and provide additional functionality to already powerful Google Sheets.
The 7 Most Useful Google Sheets Formulas
Google Spreadsheets is one of the best tools you can use for analysis, especially when you work with numbers. There’s so much more than creating a sheet. With the right Google sheets formulas, you can extract useful insights for your business as well as manipulate information to make the right decisions.
In this PPC audit guide, we’ll walk you through the methods to set up your PPC audit while also providing a handy step-by-step PPC audit checklist. With these audit checklist, you’ll have an insight into the areas that need improvements, expansion, and advanced optimization.
Mike Bennet
May 27, 2020 4 min read
If you can analyze your search term reports regularly or periodically, you’ll be sure that you aren’t wasting your advertising dollars on irrelevant search queries. Apart from that, you’ll also discover new keyword data and opportunities that you can incorporate into your campaigns.
Wendy Gooseberry
May 27, 2020 2 min read
Sending one message to your entire subscribers consistently is an act that has the potentials of diminishing your brand reputation. Apart from that, it depletes an email list of your subscribers as well as halt conversions.
Gintaras Baltusevicius
May 26, 2020 3 min read