Course / Sheets and workbooks

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.

In Excel, it's View → Freeze Panes. Here, it's Freeze panes in the toolbar.

Steps

  1. Scroll down the orders: the headings vanish. Scroll back up, click Freeze panes in the toolbar, and choose Freeze top row.

  2. Scroll to the bottom of the table. With the headings still in view, total the amounts in E31: =SUM(E2:E29).

  3. Keep the order numbers in view as well. Click B2, the first cell that should still scroll, then Freeze panes → Freeze panes.

  4. Let it all go again: Freeze panes → Unfreeze panes.

Remember

In the function reference: SUM

Previous: Add, rename and link sheets · Next: Drop-down lists and data validation