How to Freeze Rows and Columns in Google Sheets to Keep Headers Visible

When working with large financial statements, inventory spreadsheets, or employee rosters containing hundreds of records in Google Sheets, scrolling down or across your sheet immediately pushes your column headers and row labels off the screen. Without visible headers, discerning whether a column of figures represents revenue, tax, or gross profit requires constantly scrolling back up to the top. Google Sheets eliminates this hassle with row and column freezing, which locks your designated header rows firmly in place.

Why Freeze Rows and Columns?

Locking key reference coordinates streamlines data entry and audit tasks:

• Continuous Context: Keeps column titles (like Customer Name, SKU, Date, Price) permanently pinned at the top of your window as you scroll through thousands of rows.
• Side-by-Side Data Comparison: Freezing the primary identifier column (Column A) lets you scroll horizontally across dozens of monthly metrics while still knowing which customer or product each row belongs to.
• Clean Collaborative Sharing: Frozen panes are preserved when sharing spreadsheets with team members or clients, guaranteeing an organized viewing experience.

Method 1: Drag the Grey Header Boundary Bars (Fastest)

Google Sheets includes interactive freeze bars positioned right next to the select-all box in the upper-left corner of the grid:

1. Open your spreadsheet in Google Sheets.
2. Look at the top-left intersection above Row 1 and to the left of Column A. You will notice a thick grey line bordering the bottom of the column headers and the right side of the row numbers.
3. Hover your mouse over the thick horizontal grey line until your cursor changes into a hand icon.
4. Click and drag the grey bar downward past Row 1 (or Row 2).
5. Release the mouse button. All rows above the grey bar are now permanently frozen.
6. To freeze the first column, hover over the thick vertical grey line to the left of Column A and drag it one column to the right.

Method 2: Freeze Panes via the View Menu

If you prefer standard menu controls or want to lock multiple rows based on your current cursor position:

1. Click to select any cell inside the row or column you want to freeze up to.
2. Click on the View menu at the top of the interface.
3. Hover over Freeze.
4. Select your desired rule from the flyout menu:
   • 1 row: Locks Row 1 only.
   • 2 rows: Locks Rows 1 and 2 (ideal when you have both main and sub-headers).
   • Up to row [X]: Locks every row down to your active highlighted cell.
   • 1 column: Locks Column A.
   • Up to column [X]: Locks columns from A through your current selection.

How to Unfreeze Rows or Columns

If you need to return your worksheet to standard scrolling behaviour, click View > Freeze and select No rows or No columns. Alternatively, drag the thick grey divider lines back to their home positions in the top-left corner.