Excel / How to Freeze and Unfreeze Rows and Columns
To freeze rows and columns in Excel, select the cell just below the last row and just to the right of the last column you want to keep visible. For row 1 and column A, select B2 and choose View → Freeze Panes → Freeze Panes. To remove the freeze, choose Unfreeze Panes from the same menu.
The menu paths are for desktop Excel on Windows. Freeze Panes changes what stays in view as you scroll. Use sheet protection to prevent editing.
Freeze rows and columns together
- Return to the top-left of the worksheet and choose an anchor cell. For example, select C3 to keep the first two rows and columns A and B visible. The rows above and the columns to the left form the frozen area.
- On the View tab, open Freeze Panes and select the main Freeze Panes command. The same menu also has commands for the top row and first column.
- Check the boundary below the rows and to the right of the columns. Scroll down and right. With C3 as the anchor, rows 1–2 and columns A–B should stay in view.
| Area to freeze | Cell to select |
|---|---|
| Top row only | A2 |
| Column A only | B1 |
| Top row and column A | B2 |
| First two rows and columns A and B | C3 |
Freeze just the top row or first column
- For row 1 only, use View → Freeze Panes → Freeze Top Row. To get the same result with the main Freeze Panes command, start at the top-left of the sheet and select A2.
- For column A only, choose View → Freeze Panes → Freeze First Column. With the main command, use B1. To keep both row 1 and column A, select B2 and use the main command once.
Unfreeze panes or move the boundary
- On the worksheet with frozen panes, choose View → Freeze Panes → Unfreeze Panes. Scroll to check that the header row and key column now move with the rest of the sheet.
- To move the boundary, unfreeze first, select a new anchor cell, and freeze again. For example, if only the top row was frozen and you want column A too, unfreeze and apply Freeze Panes from B2.
Microsoft’s guide to Freeze Panes in Excel
When the wrong area stays visible
If your headings are in row 3 and you want them visible as you scroll, select A4. Rows 1–3 will stay visible. Check the entire block starting at the top of the sheet when choosing the anchor.
If the command is unavailable, finish editing the cell with Enter or Esc and reopen the menu. If the panes are scrolling independently, check the Split setting on the View tab. Split lets you view different areas of the same sheet at once.
Repeat headers on printed pages
To repeat headings on printed pages, use Page Layout → Print Titles. On the Sheet tab, enter $1:$2 in Rows to repeat at top to repeat the first two rows. Check the headings on page two and later pages in print preview.




