Freeze Heading Row in Excel: Keep Column Labels Visible

To keep your column labels visible as you scroll in Excel, select View > Freeze Panes > Freeze Top Row. This freezes worksheet row 1. If your headings are lower down or span more than one row, select the cell just below them and use View > Freeze Panes > Freeze Panes instead. You can remove the freeze later from the same menu.

What You’ll Need

A workbook open in Microsoft Excel. These steps are for Excel for Microsoft 365 on Windows; the equivalent View commands are also available in current Excel for Mac and Excel for the web, though their ribbon layouts can look different.
Know which worksheet row contains the heading you want to keep visible. The Freeze Top Row command always freezes row 1, not whichever row contains your active cell.
If you need to freeze several heading rows, identify the row immediately below the last heading row before you start.

Step-by-Step

Open the worksheet you want to change. If the workbook has multiple sheets, select the correct sheet tab at the bottom. Freeze settings apply to the current worksheet only, so repeat the process on other sheets if needed.
Choose the quick option when the heading is in row 1. Open the View tab on the ribbon, choose Freeze Panes, then select Freeze Top Row. The first row remains displayed at the top of the worksheet as you scroll down. You can start from any selected cell; this command specifically targets row 1.
Check that it worked. Scroll down using the mouse wheel, scroll bar, or keyboard. Row 1 should remain visible while the data below it moves. A thin line below the frozen area may indicate the boundary. Return to the top to check that the sheet still behaves as expected.
Use Freeze Panes for headings in another row. If the labels are in row 3, for example, click cell A4. Then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selected cell, so rows 1 through 3 stay visible. The selected cell’s column position also matters: choosing A4 freezes rows only, while choosing B4 freezes rows 1 through 3 and column A.
Freeze multiple heading rows when needed. To keep rows 1 and 2 visible, select A3 and choose View > Freeze Panes > Freeze Panes. To keep rows 1 through 4, select A5 instead. The rule is to select a cell in column A, directly below the final row you want frozen. Excel keeps all rows above the selection fixed, not just the row immediately above it.
Freeze a heading and one or more leading columns, if useful. The same command can hold both rows and columns in place. For example, select B2 and choose Freeze Panes to keep row 1 and column A visible. More generally, click the cell one row below the last heading row and one column to the right of the last column you want to hold still. Then choose View > Freeze Panes > Freeze Panes.
Remove or change the freeze. Choose View > Freeze Panes > Unfreeze Panes. If you want a different arrangement, unfreeze first, select the correct cell, and apply Freeze Panes again. Freeze Top Row and Freeze Panes are alternatives for the current sheet; applying another freeze replaces the existing freeze rather than adding an independent one.

On Excel for Mac, use the View tab and its Freeze Panes controls; some versions also expose freeze commands through the Window menu. In Excel for the web, use the View tab and Freeze Panes. If the ribbon is compact or simplified, look for the command within the View options rather than a separate worksheet setting. The command names and the basic row-selection rule are the same.

Common Mistakes

Using Freeze Top Row for a heading below row 1. If your table begins at row 4, Freeze Top Row keeps blank or introductory rows at the top instead of locking the table headings. Select A5 and choose Freeze Panes to keep rows 1 through 4 visible, or adjust the selection to include exactly the rows you want retained.
Selecting the heading row instead of the row underneath it. To freeze through row 3, selecting A3 is too high: it freezes only rows above that cell, which means rows 1 and 2. Select A4 to include row 3. Think of the selected cell as the upper-left corner of the area that will continue to scroll.
Choosing a cell in the wrong column. Freeze Panes uses both the selected cell’s row and column. Selecting C4 freezes rows 1 through 3 and columns A and B. If you only want rows fixed, make the selection in column A, such as A4.
Expecting a table heading to freeze automatically. Formatting data as an Excel Table does not by itself keep its heading row visible during ordinary worksheet scrolling. Apply Freeze Panes separately if you want a heading row that is not row 1, or use Freeze Top Row when the heading is in row 1.
Confusing a freeze with a split or print setting. Split divides the worksheet into independently scrolling areas, which is different from keeping a header stationary. Print Titles repeat selected rows on printed pages; they do not keep rows on screen as you scroll.

Tips

Use a deliberate layout for long lists. Put the column labels in row 1 when practical. Then Freeze Top Row is quick to apply, and the data can begin directly underneath. If the workbook needs a title or notes above the labels, use Freeze Panes with a cell below all rows that should remain visible.
Consider what the reader needs to see. Freezing several rows can preserve a report title, date range, and headings together, but it reduces the vertical space available for data. Keep the frozen area only as tall as necessary, especially on a laptop display.
Keep the selection in column A for row-only freezing. This simple habit avoids accidentally locking columns as well. If you do want a left-hand identifier column to stay put, move the selection one column to its right before applying Freeze Panes.
Test the view at different scroll positions. Scroll down enough to see that the headings remain, then scroll back to the top. If the view seems confusing, unfreeze and apply the command again with a clearly chosen cell.
Remember that the setting belongs to a worksheet view. A freeze on one tab does not automatically freeze the same rows on every other tab in the workbook. Check each sheet where users need persistent labels.
Use a freeze for navigation, not data protection. Freezing affects what stays visible on screen; it does not lock cells against editing, protect a worksheet, or prevent rows from being changed. Use worksheet protection separately if you need to restrict edits.

Troubleshooting

The heading disappears when I scroll. Confirm that you applied the command to the right worksheet and that you scrolled within that sheet. If the heading is in row 1, reapply View > Freeze Panes > Freeze Top Row. If it is lower down, unfreeze and select a cell in column A immediately below the last heading row before choosing Freeze Panes.

The wrong rows remain visible. Choose Unfreeze Panes, then count the rows from the top that you want to keep. Select column A in the next row down. For instance, to keep rows 1 through 5, select A6. Avoid selecting the heading cell itself, because Excel freezes the rows above the selected cell, not the selected row.

A column is frozen when I only wanted rows. Unfreeze and repeat with a selection in column A. Any columns to the left of the selected cell are held in place too. To keep column A as well as the top row, select B2 instead.

The Freeze Panes command is unavailable or does not respond. Check that you are viewing a worksheet rather than a chart sheet, and try clicking a normal cell in the worksheet grid. If the workbook is in a shared or restricted state, some editing features may be limited; check whether you have permission to edit and whether the workbook is protected. The freeze command may also be tucked into a compact ribbon menu, so expand the View tab or use the ribbon search box to find Freeze Panes.

The sheet looks divided into separate scrolling areas. You may have selected Split instead of Freeze Panes. Turn off Split from the View tab, then apply the appropriate Freeze Panes command. If a freeze is active, use Unfreeze Panes first and set it again after the split is cleared.

The headings do not repeat on printed pages. Freezing panes changes the on-screen view only. To repeat rows when printing in desktop Excel for Windows, open Page Layout > Print Titles, then set the rows to repeat at top in the Page Setup dialog. Check Print Preview to verify the printed result; those settings are separate from the on-screen freeze.

Frequently Asked Questions

Can I freeze a heading row that is not the first row?
Yes. Select a cell in column A directly below the row or rows to keep visible, then choose View > Freeze Panes > Freeze Panes. For a heading in row 4, select A5 to freeze rows 1 through 4.

Can I freeze more than one row?
Yes. Select a cell below the last row you want to hold still, then apply Freeze Panes. For example, select A3 to freeze rows 1 and 2. The rows must be a continuous block starting at the top of the worksheet.

Can I freeze the top row and the first column at the same time?
Yes. Unfreeze any existing setting, select B2, and choose View > Freeze Panes > Freeze Panes. Excel keeps row 1 and column A visible. Adjust the selected cell if you need to freeze more than one row or column.

Why does Freeze Top Row keep the wrong row visible?
That command always freezes worksheet row 1, even if your active cell is elsewhere. For headings farther down the sheet, use Freeze Panes and select the cell below the heading instead.

Will the freeze still be there when I reopen the workbook?
Freeze settings are saved with the workbook’s worksheet view when the file is saved. Save the workbook after setting the freeze. If other people use the file, ask them to check the view in their copy or session, especially if they work from a separate downloaded copy.

Does freezing a row make it repeat when I print?
No. Freezing keeps rows visible while you scroll on screen. Use Page Layout > Print Titles in desktop Excel for Windows to set rows that repeat on printed pages.

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.