Freeze panes: keep the headings in view
Freeze the top row, or rows and columns together, so the headings of a long table stay put while you scroll. Beginner · 4 min · Freeze panes, Freeze top row, Unfreeze
Scroll down a long table and the headings go off the top. Thirty rows later, is that column units or amount?
Freeze panes pins rows at the top, columns at the left, or both. They stay where they are while the rest of the sheet scrolls under them.
There are three choices, and one rule covers them all: everything above and to the left of the selected cell is frozen.
- Freeze top row: the headings.
- Freeze first column: the names or codes.
- Freeze panes: whatever is above and left of the cell you selected. Select B2 for the top row and the first column.
In Excel, it's View → Freeze Panes. Here, it's Freeze panes in the toolbar.
Steps
Scroll down the orders: the headings vanish. Scroll back up, click Freeze panes in the toolbar, and choose Freeze top row.
Scroll to the bottom of the table. With the headings still in view, total the amounts in
E31:=SUM(E2:E29).Keep the order numbers in view as well. Click
B2, the first cell that should still scroll, then Freeze panes → Freeze panes.Let it all go again: Freeze panes → Unfreeze panes.
Remember
- Freeze panes keeps rows at the top and columns at the left in view.
- Freeze top row and Freeze first column cover the usual cases.
- For anything else, select the first cell that should still scroll, then Freeze panes.
- It changes the view only: no cell or formula is affected.
In the function reference: SUM
Previous: Add, rename and link sheets · Next: Drop-down lists and data validation