Excel Freeze Panes: Change Them While Scrolling?

No—Excel does not change the Freeze Panes boundary automatically as you scroll. To move it, unfreeze the current panes, select a new cell to define the rows and columns to keep visible, then choose View > Freeze Panes > Freeze Panes.

What Freeze Panes Does

Freeze Panes keeps selected worksheet rows, columns, or both visible while you scroll through the rest of the sheet. It is useful when a long table has headings that you need to see beside the records, or when key labels sit in columns to the left of the data. The frozen area stays in place on screen; the unfrozen area moves.

The boundary is set by the active cell when you apply the command. Excel freezes the rows above that cell and the columns to its left. For example, selecting D5 and choosing Freeze Panes keeps rows 1 through 4 and columns A through C visible. The active cell itself is not part of the frozen area. This lets you set a horizontal and vertical boundary together, rather than only freezing a single row or column.

Scrolling changes which unfrozen cells are displayed, not the boundary itself. If you scroll down, the frozen heading rows remain visible while the data below them moves. If you scroll right, frozen left-hand columns stay put while later columns move into view. Scrolling back does not remove or reposition the freeze.

How to Change the Frozen Rows or Columns

In Excel for Microsoft 365 on Windows, use the View tab on the ribbon. You cannot drag the Freeze Panes boundary to a new position while the panes are frozen. Instead, remove the existing freeze and apply a new one:

Open the worksheet whose frozen area you want to change.
Choose View > Freeze Panes > Unfreeze Panes.
Select the cell immediately below the rows and immediately to the right of the columns you want to keep visible.
Choose View > Freeze Panes > Freeze Panes.

For example, if the worksheet currently keeps row 1 and column A visible, but you want rows 1 and 2 plus columns A and B, first unfreeze. Then select C3 and apply Freeze Panes. Excel will keep rows 1–2 and columns A–B on screen. If you only need to adjust the row boundary, you still need to unfreeze first, then select the new boundary cell and freeze again.

The menu also offers shortcuts for common layouts: Freeze Top Row and Freeze First Column. Those commands do not let you choose an arbitrary boundary. Use the main Freeze Panes command when you need a particular number of rows, columns, or both.

Choosing the Right Cell

Think of the selected cell as the top-left cell of the scrolling region. Everything above it and everything to its left is frozen. This rule makes it easier to plan the layout before choosing the command:

To freeze the first two rows only, select A3 and choose Freeze Panes.
To freeze the first three columns only, select D1 and choose Freeze Panes.
To freeze the first two rows and first three columns, select D3 and choose Freeze Panes.
To freeze just the top row, use View > Freeze Panes > Freeze Top Row.
To freeze just the first column, use View > Freeze Panes > Freeze First Column.

These examples assume the rows and columns you want to lock begin at the top-left of the worksheet. If your headings start lower down or your table begins farther right, use the same boundary rule: select a cell below and to the right of the area to keep visible. Freeze Panes does not identify a table header automatically; it follows the cell selection.

What Happens When You Scroll

Once panes are frozen, use the mouse wheel, scroll bars, trackpad, or keyboard navigation to move through the unfrozen part of the sheet. The frozen rows and columns remain visible, and the scrollable area changes around them. This is especially helpful for wide sheets: freeze the row containing field names and the column containing customer or product names, then scroll down and across without losing those references.

For example, a sales worksheet might have dates and totals in rows below a two-row title and header area, with customer names in column A. Select B3 before freezing. Rows 1 and 2 and column A will remain visible while the sales records scroll vertically or the later data columns move horizontally. If the frozen area takes up too much of the screen, however, the remaining scrollable space can feel cramped. Freeze only the labels that are genuinely useful for orientation.

Freeze Panes also does not keep a particular cell selected or prevent the worksheet from moving. It pins part of the view, not the active cell. You can still edit cells in frozen or scrolling areas, subject to the workbook’s normal protection and editing settings.

Freeze Panes Versus Split

Freeze Panes and Split are related viewing tools, but they behave differently. Freeze Panes anchors rows or columns so they stay visible as the rest of the worksheet scrolls. Split divides the worksheet window into separate panes that can be scrolled independently. A split is useful when you want to compare distant parts of a sheet at the same time; it is not the same as keeping table headings fixed above all the records.

In Excel for Microsoft 365 on Windows, Split is available from View > Split. If a split is active, you may see divider bars and independently moving areas. If your goal is simply to keep a heading row visible, remove the split if necessary and use Freeze Panes instead. Do not assume that scrolling one split pane will move another one in sync.

Another common point of confusion is that hiding rows or columns is not freezing them. Hidden material is removed from view until you unhide it; frozen material remains visible while other parts scroll. Likewise, freezing panes does not lock cells against edits. Worksheet protection is a separate feature.

Common Problems and Fixes

If the wrong rows or columns remain visible, the most likely cause is that the selected cell was not at the intended boundary. Unfreeze, work out which rows should stay above the selection and which columns should stay to its left, then apply the command again. Selecting A1 and choosing Freeze Panes does not freeze a useful area because there are no rows above or columns to the left.

The menu says Unfreeze Panes: A freeze is already active. Choose Unfreeze Panes before setting a different boundary.
Only one row or column is frozen: Freeze Top Row or Freeze First Column may have been used. Unfreeze and select the appropriate boundary cell to freeze more than one.
The headings disappear anyway: Check that you are scrolling within the same worksheet and that the heading rows are actually above the selected boundary.
There is too little room to scroll: Reduce the number of frozen rows or columns, or adjust the window size and zoom. A large frozen block can leave little space for the rest of the sheet.
You are looking at a split: Use View > Split to review the split setting, then switch to Freeze Panes if you want anchored headings.

Freeze settings apply to the worksheet you are viewing, not automatically to every sheet in the workbook. If several tabs use the same layout, check each one separately. Also remember that saving the workbook preserves its worksheet view settings, so another person may see the same frozen area when opening it.

Excel on Mac and Excel for the Web

The basic behavior is the same in Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web: choose a boundary cell, freeze panes, and unfreeze before changing that boundary. In the desktop Mac app, use the View tab’s Freeze Panes controls; the precise ribbon arrangement can differ from Windows. The Windows ribbon path in this guide is View > Freeze Panes.

Excel for the web also provides Freeze Panes commands on the View tab. If you do not see a command or its options, check whether the workbook is open in editing mode and whether the ribbon is collapsed. The web interface can differ slightly from the desktop app, but the selection rule remains the same. If a workbook opens in a different version of Excel, confirm the frozen boundary there rather than expecting scrolling to change it.

When to Use Freeze Panes

Freeze Panes works best when the worksheet has stable labels that help you interpret a larger scrolling area. Typical examples include a header row with fields such as Date, Region, and Amount; a first column of employee names; or both headers and labels in a cross-tab report. For a small worksheet that fits on screen, freezing may add little value. For a very wide or tall sheet, it can prevent errors caused by losing track of which row or column you are reading.

Choose the smallest useful frozen area. Keeping one header row and one identifying column visible may be enough. If a report has several title rows, freeze only those that provide context while you work. For printed pages, Freeze Panes is not a print-layout setting; use the worksheet’s page layout and print-title options if you need headings repeated on paper. The on-screen freeze and printed repetition solve different problems.

Frequently Asked Questions

Can I change Freeze Panes without unfreezing first?
No. In Excel, unfreeze the current panes, select a new boundary cell, and apply Freeze Panes again. Scrolling cannot move the existing boundary.

How do I freeze the first two rows in Excel?
Select cell A3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 will stay visible as you scroll down.

Can I freeze 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. For example, select D3 to freeze rows 1–2 and columns A–C.

Does Freeze Panes stop me from editing the frozen cells?
No. It changes what stays visible while you scroll; it does not protect or lock cells. Use worksheet protection if you need to restrict editing.

Why does Freeze Panes keep the wrong area visible?
The selected cell defines the boundary. Unfreeze, select a cell whose rows above and columns to the left match the area you want to keep, and freeze again.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.