Keep header rows visible while you scroll

Freeze panes locks rows and columns in place while the rest of the sheet scrolls. The rule: everything above and to the left of the selected cell gets frozen. So to pin row 1 plus column A, select cell B2, then go to View > Freeze Panes > Freeze Panes. To pin just the first two columns, select the third column first. Undo it any time with View > Freeze Panes > Unfreeze Panes.

Source: support.microsoft.com · checked 2026-07-04

Looking for Microsoft Excel's keyboard shortcuts? The full cheat sheet is the main event.