How to Freeze a Row in Excel
Keep your header row visible while you scroll through a long spreadsheet. "Freeze," "lock," and "pin" a row all mean the same thing in Excel — here's how to do it, including freezing several rows at once.
The fastest answer: View → Freeze Panes → Freeze Top Row. Row 1 now stays put while the rest of the sheet scrolls. If you need more control — several rows, or rows and columns together — the rest of this takes under a minute.
Freeze the top row
Go to the View tab, click Freeze Panes, and choose Freeze Top Row. That's it — your header row stays visible no matter how far down you scroll. You don't need to select anything first; Excel always freezes row 1 with this option.
Freeze several rows at once
Say your header spans the first three rows. Click the row below the last one you want frozen — row 4 in this case — then go to View → Freeze Panes → Freeze Panes. Everything above the selected row locks in place. The rule to remember: select the row below what you want frozen.
Freeze rows and columns together
To freeze both the top rows and the leftmost columns, click the single cell that sits just below and to the right of everything you want frozen — for example, cell B2 to freeze row 1 and column A — then View → Freeze Panes → Freeze Panes. Excel freezes everything above and to the left of that cell.
Unfreeze
Changed your mind? View → Freeze Panes → Unfreeze Panes clears all frozen rows and columns in one click.
Spend less time scrolling spreadsheets
Ask a question about your Excel data in plain English and get the answer back in seconds — no scrolling, no formulas. Free to start.
Try Quiriz free →