To freeze a row in Excel, go to the View tab, click Freeze Panes, and choose Freeze Top Row to lock the very top row, or select the row below the ones you want to keep and click Freeze Panes to lock several rows at once. A thin gray line marks the frozen edge, and those rows now stay put while the rest of the sheet scrolls underneath. On Windows the shortcut is Alt then W then F, which opens the same menu without hunting through the ribbon.
Freezing rows is usually the first thing you do after converting a long PDF into a spreadsheet, because a bank statement or ledger can run hundreds of rows and you lose track of which column is which the moment the header scrolls off screen. Lock the header once and it follows you all the way down. Here is how to freeze rows, columns, and both together, plus what to do when the option is grayed out.
How do you freeze a row in Excel?
Open the View tab, click Freeze Panes, and pick the option you need. Freeze Top Row locks row 1 with a single click and is the fastest choice when your labels sit in the first row. To freeze a different row, first select the row just below the last one you want locked, then click Freeze Panes, Freeze Panes. Everything above the selected row stays fixed while the rows below scroll. The frozen area is remembered when you save the file, so anyone who reopens it sees the same locked header.
How do you freeze the top row in Excel?
Click any cell, go to View, Freeze Panes, and choose Freeze Top Row. Row 1 is now pinned and stays visible as you scroll down through the data. You do not need to select the row first; Freeze Top Row always locks row 1 regardless of where your cursor is. This is the right choice for a simple table whose column names live in the top row, which covers most spreadsheets that come out of a converted document.
How do you freeze multiple rows in Excel?
Select the row directly below the last row you want to freeze, then click View, Freeze Panes, Freeze Panes. To keep the top three rows visible, click the row header for row 4 (or select cell A4) before choosing Freeze Panes, and rows 1 through 3 lock in place. The rule is simple: whatever is above your selected row gets frozen. This is useful when a converted report has a title row, a date row, and a header row that all need to stay on screen.
How do you freeze a column in Excel?
Go to View, Freeze Panes, and choose Freeze First Column to lock the leftmost column so it stays visible as you scroll right. To freeze more than one column, select the column to the right of the last one you want locked (for example click column C to freeze columns A and B), then click Freeze Panes, Freeze Panes. Frozen columns are handy when the first column holds an account name, a date, or a description that you need to read against numbers far off to the right.
How do you freeze rows and columns at the same time?
Select the single cell that sits just below the rows and just to the right of the columns you want to lock, then click View, Freeze Panes, Freeze Panes. To freeze the top row and the first column together, click cell B2 first, because everything above and to the left of the selected cell freezes. Excel only supports one frozen region at a time, always anchored to the top left corner, so you pick the cross point and both a horizontal and a vertical pane lock at once.
What does each Freeze Panes option do?
| Option | What it locks |
|---|---|
| Freeze Top Row | Row 1 only |
| Freeze First Column | Column A only |
| Freeze Panes (with a row selected) | All rows above the selection |
| Freeze Panes (with a column selected) | All columns left of the selection |
| Freeze Panes (with a cell selected) | Rows above and columns left of the cell |
| Unfreeze Panes | Removes all frozen rows and columns |
Why is Freeze Panes grayed out?
Freeze Panes is disabled while you are editing a cell, so press Enter or Escape to leave edit mode and the option comes back. It is also unavailable in Page Layout view; switch to Normal view under the View tab and it works again. A third cause is a protected sheet, where the layout is locked; unprotect the sheet and try once more. If the button is active but nothing happens, you may already have panes frozen, so click Unfreeze Panes first and then set the new region.
How do you unfreeze rows and columns?
Go to View, Freeze Panes, and click Unfreeze Panes. The option only appears when a region is currently frozen, and clicking it clears every locked row and column in one step so you can scroll freely or set a new freeze point. There is no way to unfreeze just the rows and leave the columns; unfreezing removes the whole locked region, after which you reselect the cell you want and freeze again.
Freeze the header after a PDF conversion
When you turn a multi page statement into a spreadsheet, the header row is what tells you which column is the date, which is the description, and which is the amount. Freeze that row before you start scrolling and the labels stay with you across every page of data, which makes it far easier to spot a row that landed in the wrong place. It pairs well with summing the amount column to check the total, since you can keep the header in view while you scan for the row that broke the tie out. This works best when the PDF to Excel converter keeps each field in its own column to begin with, the same clean structure you want when you are scrolling through hundreds of line items pulled straight from each invoice.
The short version
Freeze Top Row locks row 1 in one click. To lock several rows, select the row below them and choose Freeze Panes; to lock columns, select the column to their right and do the same. For both at once, click the cell below the rows and right of the columns first. If Freeze Panes is grayed out, leave cell edit mode or switch to Normal view. Freezing the header row is the first cleanup step on any converted statement, so the labels never scroll away.