A spreadsheet can be manageable with thirty rows and infuriating with three thousand. Scroll down to row 450 and the column headings disappear. Suddenly the number in column H could mean revenue, postage, quantity or something else entirely. Excel's Freeze Panes feature solves that by keeping selected rows and columns on screen while the rest of the worksheet scrolls.
The detail that trips people up is where to click first. Excel freezes the rows above and the columns to the left of your selected cell. Once you understand that rule, you can keep a header row, a product-name column or both visible without altering any of the spreadsheet's data.
Decide what must remain visible
Look at your worksheet before opening any menus. Which row contains the column names? Which column identifies each record?
For a simple table with headings in row 1, freezing the top row is usually enough.
For a sales sheet with a title in rows 1 and 2 and actual headings in row 3, you may need to freeze the first three rows instead.
Start with the View tab
Open the workbook in Excel and select the worksheet you want to change.
On the ribbon, select View, then locate the Freeze Panes menu. Microsoft documents this menu for current desktop versions of Excel.
The command affects how the worksheet is displayed; it does not change formulas, delete records or permanently lock cells against editing.
Freeze just the top row
Use View > Freeze Panes > Freeze Top Row when your headings occupy row 1.
Scroll down. Row 1 should remain visible at the top while lower rows move.
If your heading is actually in row 4, this shortcut won't keep it on screen. Use the custom selection method instead.
Freeze just the first column
Use View > Freeze Panes > Freeze First Column when column A contains product names, dates or other identifiers.
Scroll horizontally to the right. Column A should remain in view.
This can be particularly helpful when a wide worksheet includes many monthly totals or categories.
Freeze several top rows
Click the row immediately below the last row you want fixed. For example, select a cell in row 4 if rows 1 through 3 must stay visible.
Now use View > Freeze Panes > Freeze Panes. The rows above your selection become fixed.
To keep the selection precise, choose cell A4 when you only want rows frozen and no columns.
Freeze several columns
Click the column immediately to the right of the columns you want fixed.
For example, select C1 to keep columns A and B visible as you scroll to the right.
Select View > Freeze Panes > Freeze Panes, then test with a horizontal scroll. Column letters to the right should move while the first two remain.
Freeze rows and columns together
Suppose you want to keep the first two rows and the first column in view.
Select cell B3. That position is one column to the right of A and one row below row 2.
Then select View > Freeze Panes > Freeze Panes. Excel keeps rows 1–2 and column A visible.
Why the selected cell matters
The selected cell is not itself the area being frozen. It marks the boundary below and to the right of the fixed area.
Selecting D6 would freeze rows 1–5 and columns A–C, potentially leaving very little room to view other data.
If the result feels wrong, unfreeze and choose a more sensible cell. There is no need to undo worksheet edits.
Remove frozen panes
Open View > Freeze Panes > Unfreeze Panes.
The worksheet returns to normal scrolling. Your headings and data remain in their original cells.
Microsoft provides this command specifically for reversing the display setting. It is safe to use when experimenting with a large worksheet.
Only one frozen area per worksheet
Freeze Panes works from one boundary in a worksheet. You cannot create unrelated independent frozen blocks scattered across the sheet.
If you need several parts of a workbook visible simultaneously, consider opening another window of the workbook or using Excel's Split feature.
Split divides the view into separate scrolling areas, which is different from simply fixing headings.
If Freeze Panes is greyed out
Check whether you're editing a cell. Press Enter or Escape to leave cell-editing mode and try again.
Review the worksheet view. Some commands may be unavailable in certain layouts or workbook states.
If using Excel in a browser or a limited edition, available controls may differ from the desktop instructions. Consult Microsoft's guidance for that version.
Frozen lines are easy to miss
Excel may display a thin divider marking where the frozen area ends.
If scrolling behaves oddly, look for a boundary line near the top or left of the worksheet.
Try Unfreeze Panes and repeat with the intended cell. This is often quicker than hunting through many settings.
What happens when you print?
Freeze Panes controls the screen display, not the printed page layout.
To repeat heading rows on every printed page, use the appropriate Print Titles or page setup features for your Excel version.
Don't assume that visible frozen headings will automatically print at the top of every sheet of paper.
What happens when you sort?
The command doesn't protect a heading row from a badly configured sort or turn your range into a structured table.
When sorting data, select the correct range and indicate that it contains headers as appropriate.
For regular work, converting a properly arranged data range to an Excel Table may give you other useful navigation and filtering features.
Excel Tables have related behaviour
Structured Tables can provide convenient header handling and filters, but they're not identical to freezing several custom rows and columns.
You can still use Freeze Panes when a table is wide enough that its first column keeps disappearing.
Choose the tool that solves the actual navigation problem instead of adding unnecessary spreadsheet complexity.
It is a worksheet-level setting
Freezing panes on Sheet1 doesn't automatically freeze matching rows on Sheet2.
Switch sheets and configure each one that needs it. A workbook with different layouts may require different frozen boundaries.
Save the workbook after setting up the view if you want the arrangement retained.
A realistic example
Imagine a stock sheet with row 1 containing the report title, row 2 holding column names and column A showing item codes.
Click B3 and choose View > Freeze Panes > Freeze Panes.
You can now scroll through quantities and prices while the title, headers and item codes stay visible.
The quick fix
Select the cell immediately below the rows and to the right of the columns you want to keep, then use View > Freeze Panes.
If you choose the wrong area, select Unfreeze Panes and start again. Your actual spreadsheet data hasn't been changed.