How to freeze rows and columns in Excel

Last updated: 5 Oct 20262 min read

how-to

Freeze Panes keeps selected header rows or identifying columns visible while the rest of a worksheet scrolls.

Pick the boundary cell

Select the cell immediately below the rows and immediately right of the columns you want to keep visible. To retain rows 1 and 2 plus columns A and B, select C3. Then open View, Freeze Panes and Freeze Panes. Excel freezes everything above and left of the active cell, so a mistaken selection can retain a much larger region than intended.

Use the simple variants

If you only need the first row or first column, use the dedicated Freeze Top Row or Freeze First Column action where it appears in your Excel version. Scroll far enough to confirm the intended headers remain visible. If you inherited a workbook, unfreeze the current panes before choosing a new boundary so the outcome is easy to understand.

Separate view from data

Freezing does not sort, protect or lock the values in cells. It changes how the sheet is viewed while scrolling. A collaborator may see a different scroll position, and a printed sheet needs its own print-title settings if headers must repeat on paper. Filtering is a separate operation that hides rows by condition rather than holding headers in place.

Check the workbook

Use a sheet with 47 records and two header rows. Freeze at C3, scroll to row 40 and column H, and verify both header rows and the first two identifier columns remain visible. Unfreeze from View when the task changes. If the result seems wrong, inspect the selected cell and any existing split panes before repeating the command.

Common Mistakes

Do not select the last header cell; select the cell below and right of the retained area.
Do not confuse freezing with cell protection.
Do not assume frozen headers automatically repeat when printed.