How to Freeze and Unfreeze Rows or Columns in Google Sheets

When working with a large spreadsheet, keeping specific rows or columns always in view can be helpful. Perhaps you want column headers to display as you scroll down the page, or maybe you'd like to compare two rows of data that are positioned far apart from each other. Here's how to freeze and unfreeze rows and columns in Google Sheets using a web browser and the mobile app.

Freeze a Row in the Sheets Web App

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.

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.

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.

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.

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.