How To Freeze Rows in Google Sheets

When you have an intimidatingly long spreadsheet to go through, it’s easy to forget what your header looked like after multiple rows of scrolling. The solution is to freeze rows on your spreadsheet. Though most users only need one or two rows frozen, Google Sheets allows you to freeze up to as many rows you need.

Freezing rows freezes, or locks, specified rows in place. This will allow you to scroll through your Google spreadsheet without that particular row moving. You can apply the same function to columns in case you need to scroll horizontally as opposed to vertically.

Freeze Rows Limitations

Google Sheets is known for simplifying spreadsheet tasks and doing a good job at keeping up with some more of the advanced features Excel users have come to love. However, when it comes to the “freeze” feature, the simplicity may prove a bit limiting to some more advanced users.

As of now, Google Sheets only allows you to freeze rows that appear consecutively from the top down. For instance, you can freeze rows 1-4, but you cannot freeze row 4 on its own. This makes the feature a bit more limited than what you would find in a program like Microsoft Excel.

If You Want to Isolate a Non-Consecutive Row

If there is important information on a non-consecutive row that you need to see, you’ll have to freeze up to that row and hide the rows before the desired one. You can always undo any freeze/hide later on. Now with that little disclaimer, let’s get to showing you how to freeze rows on Google Sheets!

Using the Freeze Rows Feature

The process is a simple one. Even before you fill in your spreadsheet you’ll be given three different freeze options. The feature does not rely on populated cell data to work.

  1. Go to View
  2. From here, you will click on the Freeze option.
  3. You should see the following:
  • No rows
  • 1 Row: If you want to freeze one row, select “1 Row.” This is a good option for those who have a simple header.
  • 2 Rows: If you want to freeze up to two rows (both row 1 and 2), select “2 Rows.” This is a good option for those who have merged cell headers.
  • Up to Current Row (x)

If you want to freeze rows further down the spreadsheet:

  1. Click on the row number along the left-hand side. This will highlight the row.
  2. Go to View
  3. Click Freeze
  4. Select Up to Current Row.

Readjusting Frozen Rows

Once any row or set of rows has been frozen, a thick, grey border will appear separating the frozen rows from the non-static portion of the sheet. You can move this border manually to readjust the rows you would like to keep static.

  1. Mouse over the border.
  2. A hand icon will appear.
  3. Click and drag the border up or down according to your needs.

Unfreezing Rows

You can easily undo all frozen rows.

  1. Go to View
  2. Click Freeze
  3. Select No Rows

You’ll know the changes have been applied when the grey border disappears and the entire spreadsheet is scrollable.

In Conclusion

This simple function can make a data-gathering session all that easier. Even with the limitations that come with it, it is a top-notch feature that adds to Google Sheets’ accessibility and ease of use.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.