How to Freeze a Header Row in Excel While Scrolling

To keep your column headings visible while you scroll in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Freeze Top Row. For headings below the first row, select the row immediately beneath them, then choose View > Freeze Panes > Freeze Panes. Freezing changes what stays visible on screen; it does not change your worksheet data or print settings.

This is useful in long lists, reports, and tables: you can move down the sheet and still see which column contains a date, name, price, or other value. Before you start, identify which row or rows contain the headings. If the heading is not in row 1, use the custom Freeze Panes command rather than Freeze Top Row.

What You’ll Need

A workbook open in Microsoft Excel. The steps below use Excel for Microsoft 365 on Windows; most recent desktop versions use the same ribbon commands.
A worksheet with a heading row, and a clear idea of how many rows should remain visible when you scroll.
Permission to make changes to the workbook. A protected sheet or workbook may restrict view changes or disable some commands.

Step-by-Step

Open the worksheet you want to adjust. Click its sheet tab at the bottom of the Excel window. If your workbook has several sheets, freezing a row on one sheet does not automatically freeze it on the others; repeat the steps on each sheet where you need a fixed heading.
Check where the headings are. Look at the row numbers along the left edge of the sheet. If your labels are in row 1, the built-in Freeze Top Row command is the quickest choice. If the labels are in row 3, for example, decide whether rows 1 through 3 should all stay visible. Freeze Panes keeps all rows above the selected cell, so selecting the wrong row can freeze too many or too few.
Freeze a heading in the first row. Click the View tab on the ribbon. In the Window group, open Freeze Panes and select Freeze Top Row. Excel places a thin boundary beneath row 1. Scroll down with the mouse wheel, trackpad, or vertical scrollbar to confirm that the first row stays on screen. The row remains visible as you move through the worksheet.
Freeze a heading row lower down, or several rows. Click the first cell in the row directly below the last row you want to keep visible. For headings in row 3, click A4 if you want rows 1 to 3 frozen. Then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selected cell. You can also freeze columns at the same time: select a cell that is both below the rows and to the right of the columns you want to keep visible. For example, select B4 to freeze rows 1 to 3 and column A.
Test the result. Scroll down and, if applicable, horizontally to check the frozen boundary. Make sure the intended heading rows and columns remain visible, and that you can still reach the rest of the sheet. If the wrong area is frozen, use the correction steps below instead of trying to drag the boundary.
Save the workbook if you want to keep the change. Freeze Panes is a worksheet view setting, not a data edit. Save the workbook as usual so the view arrangement is retained for later use. If other people use the same file, let them know which sheet and rows have been frozen, since they may initially see the same view setting.

Excel for Mac and Excel for the web: In current versions, look for Freeze Panes on the View tab, then choose Freeze Top Row or Freeze Panes as appropriate. The ribbon layout may differ slightly by version or window size. In Excel for Mac, the same selection rule applies: for custom freezing, select the cell below and to the right of the rows and columns to keep visible before choosing Freeze Panes. In Excel for the web, use the View tab’s Freeze Panes controls; if a command is not available in your current web interface, open the workbook in the desktop app.

Common Mistakes

Choosing Freeze Top Row when the headings are lower down. This command freezes worksheet row 1, not the row that happens to contain your headings. If your labels are in row 4, use custom Freeze Panes and select a cell in row 5 to freeze rows 1 through 4.
Selecting the heading row instead of the row below it. Excel freezes rows above the active cell. To keep rows 1 and 2 visible, select a cell in row 3. Selecting a cell in row 2 freezes only row 1, which can leave part of a multi-row heading scrolling out of view.
Forgetting that custom freezing can include columns. Excel freezes everything above and to the left of your selected cell. If you select D5, you freeze rows 1 through 4 and columns A through C, not just the heading row. To freeze rows only, select a cell in column A, such as A4.
Assuming every sheet is affected. Freeze Panes applies to the active worksheet. If another sheet needs the same treatment, select that sheet and configure it separately. Check the sheet tab before making the change.
Confusing freezing with repeating print headings. Frozen rows stay visible while you work on screen. They do not necessarily repeat on printed pages or in a PDF. Use Page Layout > Print Titles to set rows to repeat when printing.
Trying to add a second freeze without clearing the first. A worksheet can have one freeze-pane arrangement at a time. If you need a different combination of rows and columns, first select View > Freeze Panes > Unfreeze Panes, then make a fresh selection and freeze again.

Tips

Use a simple selection rule. To freeze rows only, select a cell in column A immediately below the rows to keep. To freeze columns only, select a cell in row 1 immediately to the right of the columns to keep. To freeze both, select a cell below and to the right of the area you want fixed.
Keep the frozen area small. Freezing many rows can leave little room to view the data beneath them, especially on a laptop screen. Freeze only the title and heading rows you need to understand the entries, rather than a large block of introductory notes.
Use Freeze Top Row for ordinary lists. When the labels are in row 1, this preset is less error-prone than custom selection. It freezes the top worksheet row regardless of which cell is active, so there is no need to select A2 first.
Know when a table is enough. Excel tables make it easier to sort and filter data, and their column names can appear in the table header while you work with the table. A table does not replace Freeze Panes in every situation, particularly when you want other worksheet rows or columns to stay visible too.
Use zoom and window size to check usability. After freezing, adjust the zoom or maximize the Excel window if the fixed rows take up too much of the screen. This changes the display size, not which rows are frozen.
Separate screen views from print layout. If your goal is to repeat headings on every printed page, set print titles separately. In Windows desktop Excel, open Page Layout > Print Titles and enter the rows to repeat at top. Preview the printout, since a frozen on-screen row alone does not guarantee a repeated printed heading.

Troubleshooting

The heading scrolls away anyway. First check that the command was applied to the correct sheet. If the heading is in row 1, choose Freeze Top Row. If it is lower, unfreeze the current setting, select a cell immediately below the heading rows, and choose Freeze Panes. Then scroll down to test it. Also confirm that you are scrolling the worksheet itself, rather than viewing a different sheet or workbook window.

The wrong rows or columns stay on screen. Choose View > Freeze Panes > Unfreeze Panes to clear the current arrangement. Select the correct cell and apply Freeze Panes again. For example, to keep rows 1 and 2 and column A visible, select B3 before freezing. To keep rows 1 and 2 only, select A3. Check the active cell before choosing the command; it determines the boundary.

Freeze Panes is unavailable or greyed out. Check whether the worksheet is protected, whether you are editing a cell, or whether a dialog or other mode is taking focus. Press Enter or Esc to finish editing, close any open dialog, and check the Review tab for sheet protection controls. If the workbook is protected, you may need the owner or password holder to allow the change. In a browser, try opening the workbook in desktop Excel if the command is missing from the available ribbon.

The freeze line is hard to see, or the view seems split. Look for the thin boundary between the frozen section and the scrolling area. If you see separate panes or can scroll sections independently, you may have used View > Split rather than Freeze Panes. Turn off Split from the View tab, then apply the appropriate freeze command. To remove a freeze, use Unfreeze Panes; you do not need to delete or move any cells.

The headings do not repeat when printed. That is expected: Freeze Panes controls the working view. Set repeating print rows separately with Page Layout > Print Titles, then check File > Print preview. If you need the headings visible both on screen and in printed copies, configure both settings.

Frequently Asked Questions

Can I freeze more than one header row?
Yes. Select a cell in the row immediately below the last heading row you want 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 while allowing rows above it to scroll independently. Freeze Panes keeps a continuous block of rows from the top of the worksheet through the row above your selection. If the heading is in row 5, for example, selecting A6 freezes rows 1 to 5.

Can I freeze the top row and first column together?
Yes. Select B2, then choose View > Freeze Panes > Freeze Panes. This keeps row 1 and column A visible. The Freeze Top Row preset alone freezes only the top row.

How do I unfreeze a header?
On the worksheet with the frozen area, select View > Freeze Panes > Unfreeze Panes. The sheet returns to normal scrolling. You can then apply a different freeze arrangement if needed.

Does freezing a header change the data or printout?
No. It changes the worksheet’s scrolling view, not cell values or formulas. To repeat headings on printed pages, use Page Layout > Print Titles as a separate setting.

Will the freeze setting work on Mac or in Excel for the web?
Current Mac and web versions have Freeze Panes controls on the View tab, though the ribbon may look different. Use the same rule for custom freezing: select a cell below and to the right of the area you want to keep visible. If the web version does not show the needed command, open the workbook in desktop Excel.

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.