To keep headings or identifying columns visible while you scroll in Excel, use View > Freeze Panes. Select the cell just below the rows and just to the right of the columns you want to keep on screen, then choose View > Freeze Panes > Freeze Panes. This pins those rows and columns in place; it does not prevent anyone from editing their cells. If you mean stopping edits, use worksheet protection instead.
What You’ll Need
- Excel for Microsoft 365 on Windows, or a recent Excel version with the Freeze Panes command.
- A worksheet with the headings or columns you want to keep visible. Save your workbook before changing its view if you want a convenient restore point.
You do not need to select or protect the cells in advance. Freeze Panes changes how the worksheet is displayed as you scroll, not the data, layout, or permissions. The instructions below are for Excel on Windows; Mac and web differences are noted where they matter.
Step-by-Step
-
Decide what should stay visible. Freeze Panes can hold rows at the top, columns at the left, or both. For a typical list, you might keep the column headings in row 1 and names in column A visible while you move through the rest of the data. Identify the last row and last column you want fixed before choosing a command.
-
Select the cell at the boundary of the area to freeze. Excel freezes the rows above the selected cell and the columns to its left. For example, to keep row 1 and column A visible, select B2. To keep rows 1 through 3 and columns A and B visible, select C4. The selected cell itself is not part of the frozen area; it marks the top-left corner of the part that will scroll.
Take care with this step: selecting A2 freezes the first row only, while selecting B1 freezes the first column only. If you want both, the selected cell must be below and to the right of both areas.
-
Apply Freeze Panes. On Windows, open the View tab on the ribbon. In the Window group, select Freeze Panes, then choose Freeze Panes from the menu. The first menu item is the general command that uses your current cell selection. Excel adds a thin boundary line to indicate which rows and columns are fixed.
If you only need the top row, select View > Freeze Panes > Freeze Top Row. If you only need the first column, select View > Freeze Panes > Freeze First Column. These preset commands do not require you to pick a boundary cell. They are handy for simple layouts, but use the general Freeze Panes command when you need a combination or several rows or columns.
-
Check the result by scrolling. Use the mouse wheel, scroll bar, or arrow keys to move down and across the worksheet. Frozen rows should remain at the top, and frozen columns should remain on the left. For the B2 example, row 1 and column A stay visible while the rest of the sheet moves. If the wrong area stays in place, undo the view setting by unfreezing and repeat the selection carefully.
-
Unfreeze the worksheet when you no longer need the fixed area. Go to View > Freeze Panes > Unfreeze Panes. This removes the frozen rows and columns; it does not delete or move any worksheet content. You can then select a different boundary cell and apply Freeze Panes again. A worksheet can have one frozen arrangement at a time, so unfreeze the current one before setting a different arrangement.
-
Use the equivalent command on Mac or Excel for the web. In Excel for Mac, select the boundary cell, then use View > Freeze Panes > Freeze Panes; the available menu wording can vary slightly by release. The top-row and first-column presets are also in the View menu. In Excel for the web, use the View tab and its Freeze Panes menu. If the command is missing or arranged differently, check that you are in the Excel workbook view rather than a read-only preview.
Common Mistakes
Choosing the wrong boundary cell: Excel interprets the selection as the dividing point. If you select C4, it freezes three rows and two columns, not four rows and three columns. Count the rows above and columns to the left of your selection before applying the command.
Expecting Freeze Panes to protect data: A frozen heading can still be edited or deleted. Freeze Panes only affects what remains visible during scrolling. To restrict edits, use Review > Protect Sheet. Protection is a separate feature, and it may require unlocking cells users should be able to change before protecting the sheet.
Using Split instead: The Split command creates separate worksheet panes that can scroll independently. It is useful for comparing distant parts of a sheet, but it is not the same as pinning headings. If you want a fixed header area, use Freeze Panes. If the sheet already has splits, turn them off before troubleshooting an unexpected view.
Trying to freeze a middle row or column as if it were a top heading: Freeze Panes fixes rows above the selected cell and columns to its left. It does not pin an arbitrary row in the middle of a worksheet while allowing rows above it to scroll independently. Move the headings to the top or use Split when you need separate scrolling areas.
Tips
- Keep the frozen area compact. Several frozen rows or columns can take up much of the available screen, especially on a laptop. Freeze only the labels people need to interpret the visible data.
- Check for hidden rows and columns. Hidden rows or columns within the area can make the frozen boundary appear unexpected. Unhide relevant areas first if you cannot tell which cells Excel is holding in place.
- Use headings that remain useful on their own. A frozen row with clear labels such as Date, Customer, and Status is easier to read than a title row that does not identify each data column.
- Remember that the setting is a view choice. It does not change the workbook’s values or formulas. Other people opening the workbook may see the saved worksheet view, but they can change their own view by unfreezing or applying another arrangement.
- Use a preset when the layout is simple. Freeze Top Row and Freeze First Column are quick choices for a single header row or identifier column. For multiple rows or columns, select the correct boundary cell and use the general Freeze Panes command.
Troubleshooting
The wrong rows or columns are frozen. Choose View > Freeze Panes > Unfreeze Panes, click the correct boundary cell, and apply Freeze Panes again. For example, to keep the first two rows and first column visible, select B3: the two rows above it and the column to its left are the areas that will stay fixed.
The sheet will not scroll as expected. Check whether the active cell is inside a frozen region and try dragging the worksheet scroll bar. Also inspect the View tab for Split; split panes can make scrolling behave differently. If you are unsure which display setting is active, turn off Split if selected, unfreeze panes, and apply the intended freeze again.
Freeze Panes is unavailable or disabled. Make sure you are viewing a worksheet, not a chart sheet, and that the workbook is not in a restricted or read-only state. If the sheet is protected, some view or window actions may be limited depending on the workbook settings. Check Review > Unprotect Sheet if you have permission and the sheet is protected, then try the View command again.
The frozen line is hard to see. Scroll slightly and look for the boundary between the fixed area and the moving cells. If the window is narrow or zoom is high, reduce zoom or widen the workbook window to make the frozen section easier to distinguish. Zoom changes magnification, not which rows or columns are frozen.
The command seems to do nothing. Verify that you selected the general Freeze Panes command after clicking the right cell, rather than selecting a preset that freezes only the top row or first column. If needed, unfreeze first and repeat the sequence. In shared or protected workbooks, ask the owner whether permissions or workbook settings restrict changing the view.
Frequently Asked Questions
Can I freeze both rows and columns at the same time?
Yes. Select a cell below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, B2 freezes row 1 and column A.
Can I lock a cell so it stays visible while I scroll?
Excel does not pin one isolated cell with Freeze Panes. It freezes complete rows above the selected boundary and complete columns to its left. Put the cell in a row or column that should remain visible, then freeze that area.
Does Freeze Panes stop other people from editing a heading?
No. It changes the scrolling view only. Use worksheet protection if you need to restrict editing, and configure which cells are editable separately from the Freeze Panes setting.
Can I freeze a row that is not at the top?
Not as a standalone fixed row while the rows above it scroll freely. Freeze Panes holds the rows above the selected cell, beginning from the top of the worksheet. Reorganize the layout or consider Split for independently scrolling areas.
Will freezing panes change my printout?
No. Freeze Panes is a screen-view setting and does not repeat rows on printed pages. To repeat column headings when printing, use Page Layout > Print Titles and set the rows to repeat at the top.
How do I freeze more than one heading row?
Select the cell in the first unfrozen row and first unfrozen column, then apply the general Freeze Panes command. To hold rows 1 through 3 and no columns, select A4; to hold those rows plus column A, select B4.
Related
- Choose an Excel Data Range: Methods, Tips, and Shortcuts
- Excel Letter Count: Count Letters and Characters in Cells
- Excel Very Slow Loading Data? Causes and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Copying Text from Excel to Word: Formatting, Links and TablesTo copy cells from Excel into Word, select the cells, press Ctrl+C in Excel, place the cursor in…
- Add a Header in Excel on the First Page OnlyTo add a header only to the first printed page in Excel for Microsoft 365 on Windows, open…
- Data to Columns in Excel: Split Text Step by StepTo split a column in Excel, select the cells, then choose Data > Text to Columns. Choose Delimited…
- Freeze Panes in Excel 365: Keep Rows and Columns VisibleTo freeze panes in Excel 365 for Windows, select the cell immediately below the rows and to the…
- Excel Date Difference: Days, Workdays, and Inclusive CountsTo find the number of days between two dates in Excel, subtract the earlier date from the later…
- Block a Sender in Outlook Mail: Steps, Limits and TipsTo block a sender in Outlook, select a message from that person, open the message actions or Junk…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.