Excel Row Fixed While Scrolling? Freeze Panes Explained

How-to basics · Updated November 18, 2026

To keep an Excel row visible while you scroll, select the row below it, then choose View > Freeze Panes > Freeze Panes. To keep the first row visible, choose View > Freeze Panes > Freeze Top Row. Excel for Microsoft 365 on Windows uses these commands to hold headings in place without changing the worksheet data.

How to keep a row visible while scrolling

Freeze Panes fixes selected rows and columns at the top and left of the worksheet window. The selection matters: Excel freezes the rows above the active cell and the columns to its left. The active cell itself is not frozen, so choose a cell just below and to the right of the area you want to keep visible.

  1. Open the worksheet and select the cell below the row or rows you want to keep visible.
  2. If you also want to keep columns visible, select a cell to the right of those columns as well.
  3. On the ribbon, choose View > Freeze Panes > Freeze Panes.
  4. Scroll down or across to confirm the chosen headings stay in view.

For example, select cell A2 to keep row 1 visible. Select C2 to keep row 1 and columns A and B visible. The command affects the worksheet view; it does not move, copy, or protect any cells. You can still edit the frozen cells normally.

How Freeze Panes uses your selection

Freeze Panes draws a boundary based on the active cell. Rows above the selection remain visible when you scroll vertically, and columns to its left remain visible when you scroll horizontally. This lets you anchor the labels that give meaning to the data while moving through the rest of a large sheet.

To freeze the first three rows and the first two columns, select C4 and choose View > Freeze Panes > Freeze Panes. Rows 1 through 3 are above C4, and columns A and B are to its left. When you scroll, those rows and columns stay in place while the rest of the worksheet moves.

One detail often causes confusion: selecting a row header is not the same as selecting the cell beneath the row you want to freeze. If you want rows 1 and 2 to stay visible, select a cell in row 3, such as A3, before using Freeze Panes. If you select A2, only row 1 is held in place.

Freeze the top row or first column

For a simple heading row, Excel has a dedicated command. Choose View > Freeze Panes > Freeze Top Row. This keeps worksheet row 1 visible as you scroll vertically. It is convenient when the column labels are in the first row and you do not need to freeze any columns at the same time.

To keep the leftmost column visible instead, choose View > Freeze Panes > Freeze First Column. This is useful when column A contains names, product codes, dates, or other identifiers that you need to compare with values farther to the right.

The dedicated options refer to the worksheet’s actual first row or column, not the first row or column currently visible after scrolling. If your headings are in row 4, Freeze Top Row will hold row 1, not row 4. Use the general Freeze Panes command with a cell below row 4 to keep those headings visible instead.

Unfreeze or change the frozen area

Excel does not let you add a second, separate frozen region to a worksheet. To change what stays visible, first remove the existing freeze and then set a new boundary.

  • Choose View > Freeze Panes > Unfreeze Panes.
  • Select the cell that defines the new boundary.
  • Choose View > Freeze Panes > Freeze Panes, or use one of the dedicated top-row or first-column options.

For instance, if you froze only row 1 and later decide to keep columns A and B fixed too, unfreeze the current panes, select C2, and apply Freeze Panes. Conversely, if too many rows or columns are fixed, unfreeze them and choose a cell closer to the top-left corner. The change applies to the active worksheet, so check other sheets separately if they need the same setup.

Common problems and practical fixes

If the wrong rows remain on screen, the active cell was probably in the wrong place when you applied the command. Unfreeze the panes, select the cell immediately below the desired rows and to the right of any desired columns, and apply the general Freeze Panes option again. Before clicking the command, check the Name Box to confirm which cell is selected.

If Freeze Panes is unavailable or behaves unexpectedly, try these checks:

  • Finish editing the current cell by pressing Enter or Esc. Excel may disable view commands while you are editing a cell.
  • Check that you are on the worksheet you intend to change. Freeze settings are worksheet-specific.
  • Choose View > Normal if the workbook is in a different worksheet view and the command is unavailable.
  • Look for an existing frozen area. If you need a different arrangement, use Unfreeze Panes first.

If the frozen line is hard to spot, scroll a little and look for a darker divider beneath the frozen rows or to the right of the frozen columns. Freeze Panes does not make a heading bold, repeat it on printed pages, or stop another person from changing its contents. Those are separate formatting, printing, or protection tasks.

Freeze Panes versus Split and Print Titles

Freeze Panes and Split both divide the worksheet window, but they are designed for different browsing needs. Freeze Panes keeps a defined top section and left section in place while the unfrozen portion scrolls. Split creates independently scrollable panes, which can help compare distant parts of the same worksheet. If you need headings to remain anchored while reviewing records, Freeze Panes is usually the more direct choice.

Freezing rows is also different from repeating rows when printing. A frozen row stays visible in the on-screen worksheet as you scroll; it does not automatically appear at the top of every printed page. To repeat a heading row on printouts in Excel for Windows, use Page Layout > Print Titles, then set the rows to repeat at top in the Page Setup dialog. Print Titles controls page output, while Freeze Panes controls the working view.

These distinctions matter when a workbook will be both reviewed on screen and printed. You may use Freeze Panes for scrolling and set Print Titles separately for paper or PDF pages. Neither feature changes the underlying table or the values in its cells.

Choosing a useful layout for large worksheets

The best frozen area is usually the smallest one that preserves useful context. Freezing too many rows or columns can leave a narrow area for the data you actually need to inspect, especially on a laptop screen. Consider which labels you need to understand a value, then anchor only those.

  • For a simple list with headings in row 1, freeze the top row.
  • For records identified by names in column A, freeze the first column.
  • For a report with several title and heading rows, freeze the rows below the full heading block.
  • For a wide table with both row labels and column headings, use a cell below and to the right of both areas.

Suppose a sales worksheet has a title in row 1, a reporting period in row 2, column labels in row 3, and customer names in column A. If all three top rows and the customer names should remain visible, select B4 and choose Freeze Panes > Freeze Panes. That keeps rows 1 through 3 and column A in view. If the title and period are not needed while reviewing records, freezing only row 3 and column A may provide more usable space, but because those are not contiguous from the worksheet edge, Excel’s standard Freeze Panes boundary cannot freeze row 3 alone while leaving rows 1 and 2 unfrozen. You would need to rearrange the sheet or accept freezing the rows above it too.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, use the View tab and its Freeze Panes options; the basic behavior is the same: the selected cell determines which rows above and columns to the left stay visible. Ribbon placement and wording can vary slightly by release, so look for Freeze Panes on the View tab if the Windows arrangement is not identical. There is no need to use a Windows-only shortcut to set the boundary.

Excel for the web also includes freeze options on the View tab, although available commands and their presentation can differ from the desktop app. If a command is missing in your browser session, opening the workbook in the desktop app may provide the full set of view controls. Freezing panes is a display choice rather than a change to cell contents, so it is separate from editing or calculating the workbook.

Frequently Asked Questions

Can I freeze more than one row in Excel?
Yes. Select a cell in the row immediately below the last row you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select A4 to keep rows 1 through 3 visible.

Can I freeze a row and a column at the same time?
Yes. Select the cell below the rows and to the right of the columns you want fixed. Selecting C2 and applying Freeze Panes keeps row 1 and columns A and B visible.

Why does Freeze Top Row keep the wrong row visible?
Freeze Top Row always refers to worksheet row 1. If your heading is lower down, use the general Freeze Panes command and select a cell directly below the heading rows instead.

Does freezing a row protect it from editing?
No. It only keeps the row visible while you scroll. To restrict editing, use worksheet protection; that is a separate feature and requires its own settings.

Will a frozen row repeat when I print?
Not automatically. Use Page Layout > Print Titles and specify the rows to repeat at the top of printed pages. Freeze Panes affects what you see while scrolling on screen.

How do I remove a frozen row?
Choose View > Freeze Panes > Unfreeze Panes. You can then leave the sheet unfrozen or select a different cell and apply a new freeze arrangement.

Related

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.