How to Freeze Rows in Excel and Keep Headers Visible

To keep a row visible while you scroll in Excel, go to View > Freeze Panes > Freeze Top Row. To freeze several rows, click cell A in the row immediately below the rows you want to keep, then choose View > Freeze Panes > Freeze Panes. This guide covers Excel for Microsoft 365 on Windows; the main steps are similar in Excel for Mac and Excel for the web.

What You’ll Need

An Excel workbook with data arranged in rows and columns.
Know which row or rows contain labels you need to see while scrolling. The rows to freeze must be at the top of the worksheet, starting with row 1.
A desktop or web version of Excel. If you use the mobile app, its available viewing controls can differ by device and app version.

You do not need to select or format the labels themselves. Freezing changes how the worksheet is displayed; it does not move, lock, or protect cell contents. You can still edit frozen cells normally. If your heading is not in row 1, or there are blank rows above it, decide whether you want those rows to remain visible too. Excel freezes rows from the top down as one continuous block, not a single lower row by itself.

Step-by-Step

Open the worksheet and identify the rows to keep visible. Click the worksheet tab containing your data. Check the row numbers along the left edge. For example, if the column labels are in row 1, you need one frozen row. If a report title is in row 1 and column headings are in row 2, you may want to keep both rows visible. The freeze commands work on the active worksheet, so make sure you are on the right tab before continuing.
Choose the command that matches your layout. If you only want row 1 to stay visible, you can use Freeze Top Row directly. If you want two or more top rows to stay visible, locate the first row below the block you want frozen. For example, to keep rows 1 through 3 visible, the first unfrozen row is row 4. You will select a cell in that row before using Freeze Panes. Do not select a cell within the rows you intend to freeze.
Freeze just the top row, if that is all you need. On the ribbon, select View > Freeze Panes > Freeze Top Row. Excel keeps row 1 in place when you scroll down. This command is convenient for a basic table with its headings in the first row, and it does not depend on which cell is currently selected. If you already have another freeze arrangement active, first choose View > Freeze Panes > Unfreeze Panes, then apply the new choice.
Freeze multiple top rows. Click cell A in the row immediately after the last row you want to keep visible. To freeze rows 1 through 3, click A4. Then select View > Freeze Panes > Freeze Panes. Excel freezes every row above the selected cell. This is different from choosing Freeze Top Row, which freezes only row 1. For a two-row heading, click A3 and choose Freeze Panes; for a four-row block, click A5 and choose Freeze Panes.
Check the result by scrolling. Use the mouse wheel, the vertical scroll bar, or the arrow keys to move down the worksheet. The frozen rows should remain at the top of the worksheet window while the other rows move. Look for a thin line below the frozen area; it marks the boundary between frozen and scrolling rows. Scroll back to the top if you need to inspect the selection or compare the frozen headings with lower records.
Change or remove the freeze when needed. To replace the current setup, select View > Freeze Panes > Unfreeze Panes. Then select the correct cell and apply the desired freeze command again. For example, to change from one frozen row to three, unfreeze first, click A4, and choose Freeze Panes. Unfreezing changes the display only; it does not delete rows, change their order, or affect workbook data.

On Excel for Mac, use the View tab and its Freeze Panes menu; the available command names and basic selection logic are the same, although their position may differ slightly by version. In Excel for the web, use View > Freeze Panes and select the corresponding option. If you do not see the same ribbon layout, look for Freeze Panes on the View tab rather than using a Windows-only keyboard sequence.

Common Mistakes

Selecting the row you want frozen instead of the row below it. With Freeze Panes, Excel freezes rows above the active cell. To keep rows 1 through 3, select a cell in row 4, such as A4. Selecting A3 freezes only the rows above row 3, meaning rows 1 and 2.
Using Freeze Top Row when the heading is lower down. Freeze Top Row always targets worksheet row 1. It will not keep row 2 or a heading lower in the sheet fixed on screen. If the rows you need are at the top, use Freeze Panes with a cell just below them.
Expecting a lower row to stay fixed on its own. Freeze Panes freezes a contiguous block beginning at row 1. It cannot freeze row 8 while rows 1 through 7 scroll away. If necessary, rearrange the worksheet so the important headings are at the top, or use a different way to keep the information available.
Forgetting that the active cell also controls columns. When you select a cell other than column A, Freeze Panes can freeze columns to its left as well as rows above it. If you only want rows frozen, select a cell in column A, such as A4. If you intentionally want the first two columns and first three rows frozen, select C4.
Applying a new freeze without clearing the old one. Excel allows one freeze arrangement at a time. If a prior freeze is still active, unfreeze it first, then make a fresh selection. This avoids judging the new result against an old boundary.
Confusing freezing with protection. Frozen rows stay in view, but they are not protected from edits. If you need to stop users changing cells, worksheet protection is a separate feature and should be configured separately.

Tips

Keep the frozen block as small as practical. Freezing several tall rows can leave little room for the data you are trying to review, especially on a laptop screen. A compact heading and column labels are usually enough. If a multi-line title takes up a lot of vertical space, consider whether it needs to remain visible along with the column headings.

Use Freeze Top Row for a simple list whose field names are in row 1. Use Freeze Panes when you have a title, notes, or multiple heading rows above the records. Before choosing the command, count the top rows you want to retain and select the first row below that group. A quick check with a small test scroll can confirm the setup before you work through a long worksheet.

If you also need left-side identifiers to remain visible, you can freeze rows and columns together. Click the cell below the rows and to the right of the columns you want to preserve. For instance, selecting C4 freezes rows 1 through 3 and columns A and B. This is useful when names or item codes are on the left and the data extends far across the screen. If you only want rows, keep the selection in column A so no columns to the left are included.

Freeze Panes applies to the current worksheet, not every sheet in the workbook. If several tabs have similar layouts, repeat the setup on each one and confirm the result on each tab. You can also save the workbook after arranging the view so it opens with the current worksheet display settings, though the exact opening view can depend on the workbook and Excel environment.

Troubleshooting

The wrong number of rows stays visible: Unfreeze the current panes, count the rows you want to preserve, and select a cell in the next row down. For example, if rows 1 and 2 are headings, choose A3 before applying Freeze Panes. Remember that the selected row itself is not part of the frozen block.

The heading scrolls away even after you clicked Freeze Top Row: Confirm that you applied the command to the worksheet containing the data, and check whether the heading is actually in row 1. If it is in row 2 or below, use Freeze Panes instead. If there was an earlier freeze, choose Unfreeze Panes and set it up again.

Columns are frozen unexpectedly: The selected cell was probably not in column A. Choose Unfreeze Panes, click a cell in column A below the rows you want frozen, and choose Freeze Panes again. To freeze columns intentionally, select a cell to the right of the desired columns.

You cannot see the Freeze Panes command: Make sure the workbook is open in Excel rather than a file preview, and select the View tab. In a narrow window, ribbon groups or menus may be collapsed; maximize the window or open the View tab’s overflow controls. Excel for Mac and the web can arrange the controls differently, so look for the Freeze Panes option within View. If a sheet is protected or shared in a restricted environment, some actions may be unavailable; check the workbook’s permissions or ask its owner.

The freeze line is hard to notice or the screen seems unchanged: Scroll down a few rows to test it. A freeze does not make the rows look different, and if the worksheet is already at the top, the effect may not be obvious. If the rows still move, use Unfreeze Panes, select the correct cell again, and reapply the command.

Frequently Asked Questions

Can I freeze more than one row in Excel?
Yes. Select a cell in the first row below the rows to keep visible, then choose View > Freeze Panes > Freeze Panes. Selecting A4 freezes rows 1 through 3.

Can I freeze a row that is not at the top?
Not by itself. Excel freezes a continuous set of rows starting at row 1. A row lower in the sheet can only remain visible as part of that top block, so move or copy important headings to the top if appropriate.

What is the difference between Freeze Top Row and Freeze Panes?
Freeze Top Row keeps only worksheet row 1 visible. Freeze Panes uses the active cell: it keeps rows above the cell and columns to its left in place. For several top rows, select a cell in column A just below them and use Freeze Panes.

How do I freeze the top two rows?
First clear any existing freeze with View > Freeze Panes > Unfreeze Panes. Click A3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 should stay visible when you scroll down.

Will frozen rows appear when I print the worksheet?
Freezing is a screen-view setting, not a print setting. To repeat headings on printed pages, use Excel’s print-title settings separately, such as Page Layout > Print Titles, then set the rows to repeat at the top.

Does freezing rows prevent someone from editing them?
No. It only keeps the rows in view while scrolling. To restrict changes, use worksheet protection and set the permissions you need; freezing and protecting a sheet are separate actions.

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.