Skip to main content

How to Freeze Rows and Columns in Google Sheets

Joshua earned an MBA from USF and writes mostly about software and technology.

how-to-freeze-rows-and-columns-in-google-sheets

Suppose you are working on your Google Sheets file and you realize that it’s very difficult to work when you cannot see the row labels and column headers while navigating the document. This makes work challenging going back and forth to make sure you are in the correct cells. What a headache! It’s a good thing there is a fix for this in Google Sheets.

The fix for this situation is to freeze columns and rows. Freezing them will allow you to move as far down and to the right as you want so your column and row labels don’t leave your sight.

In the Google Sheet example below, I would like to freeze the first two columns and the first three rows to make identifying cells easier in my document.

how-to-freeze-rows-and-columns-in-google-sheets

To start the freezing process, I first on the view tab and freeze option shown in the illustration below. There are six different options for freezing listed below.

  • 1 row
  • 2 rows
  • up to 4 rows (Varies depending on the cell selected)
  • 1 column
  • 2 columns
  • up to 8 columns (Varies depending on the cell selected)
how-to-freeze-rows-and-columns-in-google-sheets

For my situation, I chose the option to have two columns freeze. I had to go back into the view tab to choose the two-row freeze option. You can tell where the columns and rows are frozen by the thick gray dividing line.

Note that the third option for columns and rows is not fixed. Moving your cursor to the coordinate where the freeze needs to start will change those options.

how-to-freeze-rows-and-columns-in-google-sheets

In the illustration below, the freeze was removed by choosing the no rows and no columns options. Notice that cell F23 was chosen.

how-to-freeze-rows-and-columns-in-google-sheets

Because F23 was chosen, the third option changed to allow freezes for all columns to the left of column F and all rows at and above row 23.

how-to-freeze-rows-and-columns-in-google-sheets

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2022 Joshua Crowder