alexs AL

Freezing more than one row at the top in Excel

My spreadsheet has a two-row header and Freeze Top Row only keeps the first one in place. How do I freeze the first two rows, and maybe the first column as well?
freeze top row
1

Leave A Reply

Log in to post an answer.

1 Answer

A
ajay87 Oct 21, 2026
alexs
click the row number just BELOW the last row you want to keep, so for rows 1-3 select row 4, then View > Freeze Panes > Freeze Panes. Not "Freeze Top Row", that one only ever does row 1. If the option is greyed out you're either still typing in a cell (hit Esc) or in Page Layout view. And if something is already frozen, Unfreeze Panes first, otherwise it looks like nothing happened.
Reply