How to Freeze Selected Rows in Excel While You Scroll

To freeze selected rows in Excel, click the cell in column A immediately below the last row you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, click A4 to keep rows 1 through 3 on screen while you scroll. Excel freezes consecutive rows from the top of the worksheet, not separate rows scattered farther down.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows.
The row numbers you want to keep visible. Frozen rows must start at row 1 and continue downward without gaps.
If the worksheet already has frozen panes, be ready to unfreeze them before setting a different selection.

You do not need to select or highlight the rows themselves. The active cell tells Excel where the frozen area ends: rows above it are frozen, and columns to its left may be frozen too. This makes the cell you choose important.

Step-by-Step

Open the correct worksheet. If your workbook has several sheets, click the tab for the sheet where you want the rows to stay visible. Freeze settings apply to the current worksheet; they do not automatically carry over to every sheet in the workbook.
Decide how many top rows to keep on screen. Count from row 1 down. To keep only the header in row 1, you can use the dedicated Freeze Top Row command. To keep rows 1 and 2, you will set a custom freeze at row 3. To keep rows 1 through 5, set it at row 6. The row immediately below the desired frozen section is the boundary.
Remove an existing freeze if necessary. On the ribbon, select View > Freeze Panes > Unfreeze Panes if that option is available. Excel allows one freeze-panes arrangement per worksheet at a time. Clearing the current setting first makes it easier to set the new boundary and avoids mistaking an old freeze for the one you intended.
Click the boundary cell in column A. For example, if you want rows 1 through 3 to remain visible, click A4. If you want rows 1 through 10, click A11. Use column A so that you freeze rows without also freezing any columns. You can click a cell rather than selecting its entire row; the active cell is what matters.
Open the Freeze Panes menu. Select the View tab on the Excel ribbon, then choose Freeze Panes in the Window group. If the Excel window is narrow, the command may be inside a collapsed or compact ribbon group. Expand the ribbon or widen the window if you cannot see it.
Choose Freeze Panes from the menu. Click the first Freeze Panes command in the dropdown, not Freeze Top Row. The first command uses the active cell to set a custom boundary. Freeze Top Row is a shortcut that freezes row 1 only, regardless of where you clicked.
Check the result by scrolling. Use the mouse wheel or scroll bar to move down the worksheet. The chosen top rows should remain visible while the rows below them move. Excel usually shows a thin line at the edge of the frozen area. If you also froze columns accidentally, scroll horizontally to check whether columns on the left stay fixed.

For a simple header in row 1, the alternative is View > Freeze Panes > Freeze Top Row. This is convenient when you need only the first row, but it is not the right choice for a header made up of several rows. Use the custom Freeze Panes command for two or more top rows.

In Excel for Mac, use the View tab and its Freeze Panes menu; the controls are similar, though their placement can differ by window size and version. In Excel for the web, use View > Freeze Panes and choose the available freeze option. Some interface details vary, but the same selection rule applies: set the active cell immediately below the rows you want to keep visible.

Common Mistakes

Clicking inside the rows you want frozen. Excel freezes rows above the active cell, not the row containing it. If you click A3, row 3 is below the boundary and will scroll. Click A4 to freeze rows 1 through 3.
Choosing Freeze Top Row for a multirow heading. This command keeps only row 1 visible. For a heading that occupies rows 1, 2, and 3, click A4 and choose the general Freeze Panes command.
Clicking in a column other than A unintentionally. If you click D4, Excel freezes rows above row 4 and columns to the left of column D. That means columns A through C will also remain fixed. To freeze rows only, choose a cell in column A.
Trying to freeze nonadjacent rows. The feature cannot keep, for example, row 1 and row 5 fixed while rows 2 through 4 scroll independently. Frozen rows form one continuous block starting at the top of the sheet.
Forgetting an old freeze is still active. A worksheet can keep its previous freeze boundary until you unfreeze it. If the result seems to ignore your new selection, use Unfreeze Panes and set the boundary again.

Tips

Use a concrete boundary check. Before choosing the command, note the row number of the first row that should scroll. If row 4 should be the first moving row, click a cell in row 4. This simple check helps prevent off-by-one errors.
Freeze both a heading and identifying columns when useful. If you need rows 1 through 3 and columns A through B to stay visible, click C4 before choosing Freeze Panes. Excel freezes everything above and to the left of that cell. Confirm that the fixed columns are intentional before using this combined setup.
Keep frozen rows useful but compact. A large frozen block leaves less screen space for the worksheet data that scrolls. Consider whether every title, subtitle, and blank row needs to remain visible. For a long table, a concise header is often easier to work with.
Remember that freezing changes the view, not the data. It does not lock cells against editing, protect a worksheet, or change what gets printed. Use sheet protection for editing restrictions, and adjust print titles separately if you want headings repeated on printed pages.
Set the view before presenting or sharing. Freeze panes are stored with the worksheet view, so other people opening the workbook may see the same frozen area. Save the workbook after checking the view, especially if the layout is important to its readers.

Troubleshooting

The wrong number of rows stays visible. Choose View > Freeze Panes > Unfreeze Panes, then count the rows again. Click the cell in column A whose row number is one greater than the last row you want frozen. For example, click A6 to freeze rows 1 through 5. Select the general Freeze Panes command afterward.

Columns are frozen as well as rows. The active cell was probably to the right of column A. Unfreeze the current setting, click the correct boundary cell in column A, and apply Freeze Panes again. If you intended to freeze columns too, check that the cell is exactly one column to the right of the last column you want fixed.

The Freeze Panes command is unavailable or behaves unexpectedly. Check whether the worksheet is in a mode or state that limits editing, such as a protected sheet or a dialog that is still open. Close the dialog and, if permitted, review Review > Protect Sheet. Also check whether the workbook is being edited in a browser or an older Excel version, since the ribbon layout and available options can differ. If the sheet is protected by someone else, ask for permission rather than trying to bypass protection.

The frozen line is hard to see, or scrolling seems not to work. Click a cell below the frozen boundary and scroll farther down; the change can be subtle when the sheet is short. If the worksheet is zoomed in or the frozen rows fill most of the window, reduce the zoom using the zoom control at the bottom of Excel, or hide unnecessary rows. To reset the arrangement, unfreeze panes and apply the setting again.

You need to freeze a different set of rows. Excel does not add a second independent frozen section. First unfreeze the existing panes, then choose the new boundary. If you need to keep headings visible while moving around a complex worksheet, consider whether rearranging the table so its headings are together at the top would make the freeze behavior clearer.

Frequently Asked Questions

Can I freeze several selected rows at once?

Yes, if they are consecutive rows at the top of the sheet. Click a cell in the row immediately below them in column A, then choose View > Freeze Panes > Freeze Panes. For rows 1 through 4, click A5.

Can I freeze rows that are in the middle of the worksheet?

No. Freeze Panes keeps rows from the top of the worksheet visible. It cannot pin a middle row while allowing the rows above it to scroll away. Move the information you need to keep visible to the top, or use another layout that suits the task.

Can I freeze rows and columns at the same time?

Yes. Select the cell below the last row and to the right of the last column you want frozen. For example, click C4 to freeze rows 1 through 3 and columns A and B. Then choose the general Freeze Panes command.

How do I unfreeze rows?

Go to View > Freeze Panes > Unfreeze Panes. The rows and columns will scroll normally again. You can then choose a different boundary if needed.

Does freezing rows affect printing or editing?

No. Freeze Panes changes what stays visible while you scroll on screen. It does not prevent editing and does not automatically repeat rows on printed pages. Use worksheet protection to restrict edits or the print-title settings to repeat headings in printouts.

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.