How to Freeze Rows and Columns in Excel — Keep Headers Visible While Scrolling

Scrolling down a spreadsheet with hundreds of rows only to lose sight of the header row — and then having to scroll back up just to remember what each column means — is one of the most common frustrations in everyday office work. Excel's Freeze Panes feature solves this in seconds: the rows or columns you choose stay locked on screen no matter how far you scroll.

Freeze the Top Row — Lock the Header in One Click

This is the most common use case. If row 1 contains column labels like "Name," "Department," or "Date," you can keep it visible regardless of how far down you scroll.

1. Click the View tab on the ribbon.
2. Click Freeze Panes to open the dropdown.
3. Select Freeze Top Row.

No need to select a specific cell first — Freeze Top Row always locks row 1 regardless of your cursor position. A thin horizontal line appears between rows 1 and 2 to indicate the freeze boundary.

Freeze the First Column — Lock the Leftmost Column

When column A contains identifiers such as employee names or product codes, you can keep it visible while scrolling right.

1. Click View → Freeze Panes.
2. Select Freeze First Column.

Like Freeze Top Row, this option always locks column A regardless of which cell is selected. A thin vertical line appears between columns A and B.

Freeze Both Rows and Columns — Cell Selection Is the Key

To freeze a header row and a label column at the same time, use the third option simply called Freeze Panes. Here, the cell you select before clicking matters.

The one-sentence rule: everything above the selected cell's row and everything to the left of its column gets frozen. Select B2 and you freeze row 1 (above B2) and column A (to the left of B2).

1. Click the cell that sits one row below and one column to the right of what you want frozen. For example, to freeze row 1 and column A, click B2.
2. Go to View → Freeze Panes → Freeze Panes.

Freeze lines appear at the top and left edges of the selected cell. Scroll down and row 1 stays; scroll right and column A stays.

How to Unfreeze

With any freeze active, go to View → Freeze Panes → Unfreeze Panes. All freeze lines are removed at once. You can then select a different cell and re-apply a new freeze if needed.

Print Titles vs. Freeze Panes — They Are Not the Same

Freeze Panes only affects what you see on screen. If you print a long spreadsheet, page 2 and beyond will not repeat the header row unless you set up Print Titles separately.

1. Click the Page Layout tab.
2. Click Print Titles.
3. In the Page Setup dialog, click into the "Rows to repeat at top" field and select the row you want repeated (e.g., click row 1 in the sheet — Excel fills in $1:$1 automatically).
4. Click OK. Every printed page will now include that row at the top.

In short: Freeze Panes = on-screen scrolling, Print Titles = printed page headers. You can use both at the same time — they do not conflict.

Freeze Rows and Columns in Google Sheets

Google Sheets offers the same feature under a slightly different menu path.

1. Click View in the top menu bar.
2. Hover over Freeze to open the submenu.
3. For rows, choose No rows / 1 row / 2 rows / Up to current row.
4. For columns, choose No columns / 1 column / 2 columns / Up to current column.

Unlike Excel, rows and columns are set independently — no need to position your cursor first. To unfreeze, return to the same menu and select "No rows" or "No columns."

A Tool That Pairs Well

After finishing your spreadsheet, if you need to share it as a PDF, try the Word / Excel to PDF converter. Upload the file and download a clean PDF instantly — no desktop software required. If the PDF then needs a signature, FreeSign lets you add one in the same workflow.

Frequently Asked Questions

Q. I set Freeze Panes but my header row doesn't appear on page 2 when I print.
Freeze Panes only controls on-screen display and has no effect on printing. To repeat a header row on every printed page, go to Page Layout → Print Titles and set "Rows to repeat at top."

Q. The Freeze Panes option is grayed out. What's wrong?
This usually happens when a cell is in edit mode or the worksheet is protected. Press Esc to exit edit mode, or unprotect the sheet via Review → Unprotect Sheet, then try again.

Q. I selected B2 but only the row got frozen — the column didn't.
Make sure you chose the third menu item — Freeze Panes — not "Freeze Top Row" or "Freeze First Column." The first two options ignore your cell selection and always freeze only row 1 or column A respectively.

Q. Is there a limit to how many rows or columns I can freeze?
There is no hard limit, but freezing too large an area leaves little scrollable space on screen. In practice, freezing 1–3 rows and 1–2 columns covers virtually all real-world needs.