How to Freeze a Row on Google Sheets 2 Easy Methods

Watch Video – How to Freeze a Row on Google Sheets (Lock a Row in Google Sheets)

You may want to freeze/lock rows in Google Sheets to keep a row on top 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. this can help you be more efficient Read on to find out how to freeze a row in Sheets.

How to Freeze a Row on Google Sheets

Google Sheets can make the top row always visible:

Freeze / Lock Rows in Google Sheets - demo

In the above example, Google Sheets’ top row is always visible because the first row has been frozen. When you go down the data set, you’re still able to see what you’re working on.

In this tutorial, I will show you two ways how to pin a row in Google Sheets.

#1 How to Freeze Top Row in Google Sheets Using the Mouse

This is a super quick way that a Google spreadsheet can freeze rows. This also works When you want Google Sheets to Freeze Multiple Rows.

  1. 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).
  2. 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 to make a Google Sheets sticky row(s) – as shown below:

Freeze Rows in Google Sheets - Using mouse

How to Freeze Columns in Google Sheets

Both of the above-mentioned methods also work for columns. All you have to do is move the horizontal gray line instead of the vertical one or select the column options from the view options menu, discussed in the next method.

  1. Lock Columns in Google Sheets

#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:

  1. 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.
  2. 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.

How to Freeze Multiple Rows

Both of the above methods work for freezing more than one row. Just make sure the gray line is over all the rows you want to have frozen. The same applies to columns.

How to Freeze Panes in Google Sheets

If you’d like to learn how to freeze rows and columns in Google Sheets, all you have to do is both freeze the rows and freeze the columns with either of the methods we discuss in this article.

How to Freeze and Unfreeze Rows and Columns on Mobile

Android

  1. Touch and hold the row or column you want to freeze
  2. Tap Freeze or unfreeze on the menu that pops ups

iOS

  1. Tap the row number or the column letter
  2. Tap the right arrow that appears
  3. Tap freeze or unfreeze

How to Unfreeze Rows in Google Sheets

Again, there are two ways to unfreeze after you freeze a row 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 on Google Sheets, as well as how to freeze columns.

Related reading:

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

Name Ranges in Google Sheets

Copy Values but Not Formulas In Google Sheets

How to Rename Columns In Google Sheets

Spreadsheet Expert at Productivity Spot | Website | + posts

Google Sheets and Microsoft Excel Expert.