Freeze Panes: Keep Headers Visible Even at Row 500

“What column is this again?” — a question freeze panes puts an end to for good. Set once which rows and columns should stay put, and the table header will follow you even when you scroll down to row five hundred. In sheets with dozens of columns, like the example below, it's the difference between clarity and constantly having to check back.

A typical scenario

HR staffer Eva is going through a sheet listing three hundred employees and a dozen columns — name, department, start date, salary, benefits. When she scrolls down, the header with the column names disappears off screen, and by row 240 she's no longer sure whether the number in the fourth column is a salary or a contract number. She has to scroll back up, check, scroll back down — and repeat for every column.

With freeze panes, the header stays pinned at the top the whole time she scrolls. Eva looks at row 240 and immediately sees which column is which. The first column with employee names stays put too, so even after scrolling right, she can still see which row belongs to whom.

How to do it

1. Click the cell that sits below the row and to the right of the column you want to freeze — typically cell B2, if you want to freeze the first row and the first column.
2. Go to View → Freeze Panes and choose Freeze Panes.
3. From that point on, Excel keeps everything above and to the left of the cell you selected in place — most often that's the table header and the first column of identifiers (name, ID, code).
4. If you only want to freeze the top row or just the first column, use the shortcuts Freeze Top Row or Freeze First Column in the same menu — no need to select anything beforehand.
5. To undo it, follow the same path: View → Freeze Panes → Unfreeze Panes.
6. You can spot frozen areas by a thin, darker line separating the frozen part from the rest of the sheet — a visual reminder of where the boundary runs.
7. Freezing works independently of filters and sorting, so even after sorting the table by a different column, the header stays put just as before.

The best tools

• Freeze Panes in Excel — a built-in feature, nothing to configure, works in every version of Excel.
• Google Sheets — View → Freeze — same idea, just in a different menu; useful for sheets shared with a team.
• Formatted tables (Ctrl + T) — as a companion to freezing: a table's header stays visible in the column headers even without freeze panes, once you apply table formatting to the data.
• Split window (View → Split) — a related feature that splits the sheet into two independently scrollable panes; useful when you need to compare two distant parts of the same sheet, not just freeze a header.

What you get out of it

• Time: an end to repeated scrolling up and down just to check what a column means.
• Clarity: in large sheets (hundreds to thousands of rows) you keep context in view at all times.
• Fewer mistakes: you won't mix up the salary column with the contract-number column just because you lost the header from view.
• Faster work in someone else's sheet: with data you didn't create yourself, you get oriented much faster when you know what you're actually looking at.

Pro tip

You can freeze multiple columns at once too — say, name and department stay on the left while the rest of a sheet with dozens of number columns scrolls to the right. Select the cell right after the last column you want frozen and repeat the process.