How to Freeze and Unfreeze Rows or Columns in Google Sheets

Keep important info front and center as you work

Frost on faucet, water tap, Switzerland

Brigitte Blättler / Getty Images 

When working with a large spreadsheet, keeping specific rows or columns always in view can be very helpful. Perhaps you want column headers to be displayed even as you scroll down off of the first page, or maybe you'd like to compare two rows of data that are positioned far apart from each other. Freezing and unfreezing rows and columns in Google Sheets is very easy.

The steps here were performed in Google Chrome version 75 but are similar in any modern browser.

In this example, we'll freeze the first row to show how it works when you scroll away from the first row.

  1. Select the row you'd like to freeze.

    Click or tap the row number to the left of the row you want to freeze to select the entire row. To select an entire column, select the letter at the top of it.

  2. Select View > Freeze.

    View > Freeze menu in Google Sheets
  3. From the options that are displayed, select the one that fits your needs.

  • No rows: Unfreezes all rows.
  • 1 row: Freezes the first row.
  • 2 rows: Freezes the first two rows.
  • Up to current row (x): Freezes all rows up to the one currently selected, represented by x.
  • No columns: Unfreezes all columns.
  • 1 column: Freezes the first column.
  • 2 columns: Freezes the first two columns.
  • Up to current row (x): Freezes all columns up to the one currently selected, represented by x.

When you scroll horizontally or vertically, the column or row that you chose to freeze remains in view no matter where you are within the spreadsheet.

To unfreeze a column or row at a later time, follow steps 1 and 2 again and select No rows or No columns.

Freezing a Column or Row on a Smartphone or Tablet

Follow these instructions to freeze columns and/or rows on Android and iOS (iPad, iPhone, iPod Touch) devices.

The following steps were performed in Android version 8 but will be similar across devices.

  1. Launch the Google Sheets app.

  2. Open the spreadsheet you're working on (or create a new one).

  3. Select the row or column that you wish to freeze by tapping on it once so that it becomes highlighted.

    Tap the row number to the left of the row you want to freeze to select the entire row. To select an entire column, select the letter at the top of it.

  4. Tap the highlighted column again so that the context menu appears.

    Freeze row in Google Sheets on Android
  5. Tap the three dots at the right to open the context menu.

  6. Select FREEZE.

Now, when you scroll horizontally or vertically, the column or row that you chose to freeze remains in view no matter where you are in the spreadsheet.

To unfreeze a column or row at a later time, follow steps 3 and 4 again and select UNFREEZE COLUMN or UNFREEZE ROW.