When you scroll down a long spreadsheet, the header row disappears and you lose track of which column is which. Freezing panes keeps headers (or the first column) visible at all times.
Freeze the top row in Excel
- Go to the View tab.
- Click Freeze Panes.
- Choose Freeze Top Row.
A thin grey line appears under row 1. Scroll down and the header stays in place.
Freeze the first column
- Go to View → Freeze Panes.
- Choose Freeze First Column.
Useful for wide sheets where column A holds names or IDs.
Freeze several rows and columns at once
This is the option most people miss. Excel freezes everything above and to the left of the cell you select.
- Click the cell just below the rows and just right of the columns you want to freeze.
- Go to View → Freeze Panes → Freeze Panes.
| You want to freeze | Select this cell first |
|---|---|
| Rows 1–2 | A3 |
| Rows 1–3 | A4 |
| Column A and row 1 | B2 |
| Columns A–B and rows 1–2 | C3 |
Unfreeze panes
Go to View → Freeze Panes → Unfreeze Panes. You need to unfreeze before changing which rows or columns are frozen.
Keyboard shortcut
Press Alt, W, F, F one after another (not together) to open Freeze Panes. Then press R for top row or C for first column. On a Mac, use the View menu.
Freeze rows in Google Sheets
- Go to View → Freeze.
- Choose 1 row, 2 rows, or Up to row X (based on the selected cell).
- For columns, choose 1 column, 2 columns, or Up to column X.
Quicker method: drag the thick grey bar at the top-left corner of the sheet down or right to the row or column you want.
To unfreeze, choose View → Freeze → No rows (and No columns).
Troubleshooting
- Freeze Panes is greyed out: you’re probably editing a cell (press Esc), the sheet is protected, or you’re in Page Layout view. Switch to View → Normal.
- The wrong rows froze: you had scrolled down when you froze. Excel freezes what’s visible at the top. Unfreeze, press Ctrl + Home, then freeze again.
- Header is still not visible when printing: freezing only affects the screen. To repeat headers on every printed page, use Page Layout → Print Titles and set “Rows to repeat at top”.
Alternative: use an Excel table
Converting your data to a table (Ctrl + T) also helps. When you scroll down inside a table, Excel replaces the column letters (A, B, C) with your header names, so you always know which column you’re in. Tables also make removing duplicates and building pivot tables easier.