Freeze Multiple Rows in Excel: Step-by-Step Guide

To freeze multiple rows in Excel, select the cell in column A directly 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 on screen as you scroll. The key is to use the main Freeze Panes command, not Freeze Top Row, which freezes only row 1.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows, with the workbook open.
The worksheet where you want the rows to stay visible. Freeze panes applies to the active worksheet, not every sheet in the workbook.
A clear idea of how many rows from the top should remain on screen. Excel freezes consecutive rows starting at row 1; it cannot freeze a separate row while leaving rows above it scrolling.

Step-by-Step

Open the correct worksheet. Click the sheet tab containing the data you want to scroll through. If the workbook has several sheets, check that you are working on the intended one: each worksheet can have its own freeze-pane setting. If panes are already frozen on this sheet, remove that setting first as described in step 3.
Decide which top rows should stay visible. Count from row 1 down to the last row you want to keep in view. For instance, if row 1 contains column headings and rows 2 and 3 contain a report title and date, freezing the first three rows will keep all three visible. You can freeze more than one row, but they must be the consecutive rows at the top of the sheet.
Find the first row that should scroll. The selection needs to be in the row immediately below the rows you want to freeze. To keep rows 1 through 3 visible, select a cell in row 4. To keep rows 1 and 2 visible, select a cell in row 3. The selected cell itself is not frozen; Excel freezes the rows above it.
Choose the right column in that row. If you only want to freeze rows, click a cell in column A, such as A4 when freezing rows 1 through 3. If you also want columns to remain visible, select a cell to the right of the columns you want frozen. Excel will freeze the rows above the selection and the columns to its left at the same time.
Open the Freeze Panes menu. On the ribbon, select View > Freeze Panes. In the menu, choose Freeze Panes, the first command in the group. Do not choose Freeze Top Row if you need multiple rows; that separate command is designed to freeze only the first row.
Check that the freeze worked. Scroll down in the worksheet. The frozen rows should remain at the top while the rest of the sheet moves. Look for a thin boundary line beneath the frozen area. If you froze columns as well, scroll horizontally to confirm that those columns remain visible on the left.
Adjust the setting if you picked the wrong cell. Return to View > Freeze Panes > Unfreeze Panes. Select the correct cell below the intended rows, then choose View > Freeze Panes > Freeze Panes again. Excel does not let you drag the boundary line to change the number of frozen rows; unfreeze and reapply the setting instead.

For a quick example, suppose a sales sheet has a title in row 1, a reporting period in row 2, and field names in row 3. Select A4, then use View > Freeze Panes > Freeze Panes. When you scroll to a salesperson near the bottom of the list, the title, period, and field names will remain visible. If you select A3 by mistake, only rows 1 and 2 stay fixed, because Excel freezes the rows above the selected cell.

Common Mistakes

Choosing Freeze Top Row. This command freezes row 1 only, even if you previously selected a cell farther down the worksheet. For multiple rows, select the correct cell and choose the general Freeze Panes command.
Selecting a cell in the row you want frozen. Excel freezes the rows above the selected cell, not the selected row. To include row 3, select a cell in row 4 or lower.
Selecting the wrong column. A selection such as C4 freezes both the rows above row 4 and the columns to the left of column C. If the goal is only to freeze rows, use a cell in column A.
Expecting non-adjacent rows to stay put. Freeze Panes keeps a continuous block at the top. You cannot freeze rows 1 and 3 while allowing row 2 to scroll. Consider repeating the important information in a header area or using a different view if you need separated rows.
Forgetting that another freeze is already active. A new freeze-pane selection may not be available or may not behave as expected while existing panes are frozen. Choose Unfreeze Panes first, then set the new position.
Expecting frozen rows to appear on printed pages. Freeze Panes controls what stays on screen while scrolling; it does not set repeating print headers. Use the print settings for repeating rows when the goal is to show headings on every printed page.

Tips

Freeze the headings that make the data understandable. If a sheet uses several header lines—for example, a report title, date range, and column labels—freeze all of those rows together. This makes it easier to identify values while scrolling through a long list.
Combine frozen rows and columns when useful. To keep the first two rows and the first column visible, select B3, then choose View > Freeze Panes > Freeze Panes. Excel freezes everything above and to the left of that cell. Before doing this, confirm that freezing the first column will not take up too much of the worksheet window.
Use the worksheet grid to confirm your selection. The Name Box, to the left of the formula bar, displays the active cell address. After clicking, check that it says A4 for three frozen rows, or the equivalent cell address for your chosen row count.
Keep the frozen area compact. Frozen rows use space at the top of the window. If you freeze many rows, less room remains for scrolling data, especially on a laptop display. Freeze only the rows readers need to identify the columns or understand the report.
Remember the setting is sheet-specific. If a workbook has multiple data sheets, repeat the process on each sheet where you want frozen headings. Changing the setting on one worksheet does not automatically apply it to the others.

Troubleshooting

The wrong number of rows stays visible. First choose View > Freeze Panes > Unfreeze Panes. Then count the rows to keep, select the cell in the next row down, and apply Freeze Panes again. For example, select A6 to freeze rows 1 through 5. Remember that the selected row is the first row that can scroll.

The Freeze Panes command is unavailable or does not respond as expected. Check whether the worksheet is protected or whether the workbook is opened in a restricted editing state. If you can edit the sheet, try unfreezing any existing panes and then select a normal cell in the grid. If you only have read-only access, save an editable copy if permitted before changing worksheet views.

Rows seem to disappear when you scroll. Confirm that you used Freeze Panes rather than Split. Split divides the worksheet window into independently scrolling sections and is a different feature. If needed, unfreeze panes, select the correct cell, and apply the general Freeze Panes command again.

The frozen section takes up too much of the window. Unfreeze panes and choose a lower freeze point so fewer rows remain fixed. You can also zoom out or make the Excel window larger, but reducing the number of frozen rows is often the simplest fix.

You are using Excel for Mac or Excel for the web. In current versions, look on the View tab for Freeze Panes and choose the option to freeze at the current selection. Menu wording and placement can differ slightly by version. Use the same selection rule: click in the row below the rows to keep, and in the column to the right of any columns to keep. If the web interface offers only preset choices, open the workbook in the desktop app to set a custom multi-row position.

Frequently Asked Questions

Can I freeze three or more rows in Excel?
Yes. Select a cell in the row immediately below the last row to keep visible, then choose View > Freeze Panes > Freeze Panes. For five rows, select a cell in row 6.

Can I freeze rows that are not at the top?
Not with Freeze Panes. The feature keeps consecutive rows starting at row 1 visible. It cannot hold an isolated row in place while rows above it scroll.

Can I freeze multiple rows and the first column together?
Yes. Select the cell below the last row and to the right of the last column you want frozen. For the first two rows and column A, select B3 and apply Freeze Panes.

Will the frozen rows remain visible when I close and reopen the file?
The freeze-pane setting is saved with the worksheet in the workbook. If you want the setting retained, save the workbook after applying it.

Does freezing rows change the printed pages?
No. It changes the on-screen scrolling view only. To repeat headings on printed pages, use the worksheet’s print-title settings instead.

How do I remove frozen rows?
Go to View > Freeze Panes > Unfreeze Panes. This removes the frozen panes from the active worksheet; it does not delete any rows or change the cell contents.

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.