How to Freeze More Than the Top Row in Excel

To freeze more than the top row in Excel, select the cell directly below the rows you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select A4 to keep rows 1 through 3 on screen while you scroll. You can also freeze columns at the same time by selecting a cell below and to the right of the rows and columns you want to hold in place.

This is useful when a worksheet has several heading rows, such as a title, a date range, and column labels. Frozen rows stay visible as you move down through the data, making it easier to understand what each column contains. The instructions below are for Excel for Microsoft 365 on Windows; the same selection principle applies in current Mac and web versions, though the ribbon layout can differ slightly.

What You’ll Need

An Excel workbook with the worksheet you want to work on.
A clear idea of which top rows, and optionally left-hand columns, should remain visible.
Access to the View tab. If the worksheet already has frozen panes, you will need to unfreeze them before setting a different freeze area.

Step-by-Step

Open the correct worksheet. Click the sheet tab containing the data. Freeze Panes applies to the active worksheet only, not every sheet in the workbook, so check the tab before changing the view.
Decide how many top rows to keep visible. Count from the top of the sheet. If you want rows 1, 2, and 3 to remain visible, you are freezing three rows. The row that you select next will not be frozen; it marks the first row that should scroll.
Clear any existing freeze setting if needed. On Windows, select View > Freeze Panes > Unfreeze Panes. If the menu currently offers Unfreeze Panes, a freeze is already active. Removing it first helps prevent the old boundary from confusing your new selection. If panes are not frozen, this step is unnecessary.
Click the cell immediately below the rows to freeze. To freeze the first three rows and no columns, click A4. To freeze the first two rows, click A3. In general, select a cell in the first row that should scroll. Use column A when you do not want to freeze any columns.
Choose the Freeze Panes command. Select View > Freeze Panes > Freeze Panes. Do not choose Freeze Top Row: that command freezes only row 1, regardless of the cell you selected. Freeze Panes uses the selected cell to set the boundary.
Check the boundary. A thin line should appear below the frozen rows. Scroll down with the mouse wheel or the vertical scrollbar. The frozen rows should stay visible while the rows beneath them move. If the line is not where you expected, use Unfreeze Panes and repeat the selection carefully.
Freeze rows and columns together if useful. Select a cell that is both below the rows and to the right of the columns you want to keep. For example, to freeze rows 1 through 3 and columns A and B, select C4, then choose View > Freeze Panes > Freeze Panes. Rows above the selected cell and columns to its left remain fixed.
Save the workbook if you want to retain the view. Freeze Panes changes how the worksheet is displayed, not its data. Save the workbook normally. When you reopen it, Excel generally retains the worksheet view, although shared workbooks and different Excel versions can display views differently.

Example: Imagine row 1 contains a report title, row 2 contains the reporting period, and row 3 contains field names. Select A4 and use Freeze Panes. You can then scroll through hundreds of records while all three context rows remain visible. If column A contains customer names that you also need to see while scrolling sideways, select B4 instead; that freezes the first three rows and column A.

Common Mistakes

Choosing Freeze Top Row by mistake. That command is a shortcut for freezing only the first row. To freeze two or more rows, select the appropriate cell and choose the main Freeze Panes command instead.
Selecting the row you want frozen rather than the row below it. Excel freezes rows above the active cell. To keep rows 1 to 4 visible, select a cell in row 5, such as A5.
Clicking the wrong cell when freezing columns too. The selected cell controls both boundaries. Selecting C4 freezes the first three rows and the first two columns; selecting A4 freezes rows only.
Forgetting about an earlier freeze. Excel does not stack a new freeze area on top of an old one. Unfreeze first, then select the cell for the new layout.
Confusing Freeze Panes with Split. Split divides the worksheet window into independently scrolling areas. It is a different viewing feature and can make the sheet behave unlike a simple fixed header. Use Freeze Panes when the goal is to keep the top rows visible while scrolling.
Expecting frozen rows to print on every page. Freeze Panes affects on-screen scrolling only. To repeat headings on printed pages, use the separate Print Titles setting on the Page Layout tab.

Tips

Use a cell reference as a quick check. To freeze the first N rows only, choose a cell in column A of row N+1. For example, A6 freezes rows 1 through 5. This rule works because Excel freezes the rows above the selected cell.
Plan the view before selecting. If you need both a multirow heading and a key identifier column, work out the intersection first. To hold rows 1–3 and columns A–B, choose C4. The selected cell itself stays in the scrolling area.
Keep the frozen area compact. Freezing many rows can leave little room for the data you are reviewing, especially on a laptop screen. Keep only the title, labels, or context that you need while scrolling.
Use zoom and row height thoughtfully. If the frozen section takes up too much screen space, reduce the zoom level or adjust unnecessarily tall row heights. This changes the display, not the freeze boundary.
Remember that this is a view setting. Freezing rows does not protect them from edits, sort them, or make them repeat in print. Use worksheet protection, sorting, or print settings separately when those are your goals.
On Mac or Excel for the web, look for the same command. The menu may appear in a different position, but select the cell first and then use View > Freeze Panes. In Excel for the web, the View tab contains the pane-freezing controls; if the available choices are limited, open the workbook in the desktop app for the full set of controls.

Troubleshooting

The wrong number of rows stays visible. Choose View > Freeze Panes > Unfreeze Panes, then count the rows again. For three frozen rows, click A4—not A3—and choose Freeze Panes. Scroll to confirm that rows 1–3 remain fixed and row 4 moves.

The first row is frozen, but the other heading rows move. You probably selected Freeze Top Row. Unfreeze it, select a cell in the row immediately below the full heading area, and choose the main Freeze Panes command. If the first three rows are needed, select A4.

A column is frozen unexpectedly. The selected cell was probably not in column A. When freezing rows only, select a cell in column A. For instance, A4 freezes the top three rows without freezing any columns. If you intended to freeze a column too, verify that the selection is one column to the right of the last column to keep fixed.

The Freeze Panes options are unavailable or behave unexpectedly. Check whether the worksheet is in a view or editing state that restricts commands. Finish editing a cell by pressing Enter or Esc, return to Normal view from the View tab if needed, and try again. If the workbook is opened in a browser with reduced controls, use Open in Desktop App and set the panes there.

The boundary is hard to see or the worksheet looks divided. Look for the thin horizontal or vertical line separating fixed and scrolling cells. If you see multiple independently scrolling sections, you may have used Split. Turn off Split from the View tab, then apply Freeze Panes. Also make sure the worksheet is not simply scrolled far down or sideways; use the scrollbars to check which area is moving.

The frozen rows do not appear on printed pages. That is expected: frozen panes are for on-screen navigation. To repeat header rows when printing, go to Page Layout > Print Titles, then set the rows to repeat at the top in Page Setup. Check Print Preview before printing.

Frequently Asked Questions

Can I freeze more than one row in Excel?

Yes. Select a cell in the first row that should scroll, then choose View > Freeze Panes > Freeze Panes. Selecting A4 freezes rows 1 through 3.

Can I freeze the top three rows and the first column?

Yes. Select B4, then choose View > Freeze Panes > Freeze Panes. Excel freezes rows 1–3 and column A. For the first two columns and top three rows, select C4 instead.

Why does selecting a row number not freeze the rows I expect?

The freeze boundary is based on the active cell, not just the highlighted row. Click a cell below the rows you want fixed. The rows above it are frozen; the selected row and rows below it can scroll.

Can I freeze rows in the middle of a worksheet instead of at the top?

No. Freeze Panes keeps rows above the selected cell fixed, starting from the top of the worksheet. It cannot pin an arbitrary middle row while allowing rows above it to scroll independently.

Can I freeze different rows on different worksheets?

Yes. Freeze Panes is set separately for each worksheet. Select each sheet and apply its own freeze boundary. Avoid selecting multiple sheet tabs unless you intend to group sheets for other changes.

How do I remove frozen rows?

Choose View > Freeze Panes > Unfreeze Panes. This restores normal scrolling and does not delete or alter any worksheet data.

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.