How to Freeze One Row in Excel: Keep Headers Visible

To freeze one row in Excel, select View > Freeze Panes > Freeze Top Row. Excel keeps row 1 visible while you scroll down, which is useful for column headings in a long list. Before you start, check that the row you want to keep on screen is the worksheet’s first row; the built-in command freezes row 1 specifically.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows. The steps are similar in Excel for Mac and Excel for the web, with version notes below.
A worksheet with headings or other information in row 1 that you want to keep visible while scrolling.
If the row you want to freeze is not row 1, a decision about whether freezing all rows above it would also work. Excel freezes rows from the top down, not an isolated middle row.

Step-by-Step

Open the worksheet you want to change. Click its sheet tab at the bottom of the Excel window. Freeze settings apply to the active worksheet, so repeat the process on each other sheet where you need a frozen heading. If the workbook has several similar tabs, confirm the sheet name before making the change.
Check the row you want to keep visible. If your column labels are in row 1, you can use the direct Freeze Top Row command. If you have a title or blank line above the labels, they may be in row 2 or lower. The direct command still freezes row 1, not the row containing your labels, so use the custom method described in step 6 if keeping all the preceding rows visible is acceptable.
Open the View tab. In Excel for Microsoft 365 on Windows, select View on the ribbon. If the ribbon is collapsed, expand it first or use the tab names that are visible at the top of the window. Make sure the worksheet is in Normal view if the freeze commands are unavailable; you can choose View > Normal.
Open the Freeze Panes menu. On the View tab, find the Window group and select Freeze Panes. A menu appears with options for freezing panes, the top row, or the first column. The wording and layout can vary slightly with window size, but the command is on the View tab.
Choose Freeze Top Row. Select Freeze Top Row from the menu. You do not need to select row 1 or click a particular cell first. Excel freezes the worksheet’s first row, and a thin horizontal line appears beneath it to show the boundary between the frozen and scrolling areas.
Test the result by scrolling down. Use the mouse wheel, trackpad, or vertical scroll bar to move several rows down. Row 1 should stay at the top of the worksheet while the rows below it move. Scroll back to the top when finished. Scrolling horizontally does not remove the frozen top row; it remains visible as you move across columns.
If needed, freeze a different top section. First select View > Freeze Panes > Unfreeze Panes to clear the existing setting. Then click the row immediately below the rows you want to keep visible, or select a cell in that row. For example, to keep rows 1 through 3 visible, select a cell in row 4, then choose View > Freeze Panes > Freeze Panes. Excel freezes every row above the selected cell, not just one chosen row.

In Excel for Mac, open the View tab and choose Freeze Panes > Freeze Top Row. To remove the freeze, use View > Freeze Panes > Unfreeze Panes. In Excel for the web, use the View tab and the Freeze Panes menu, then choose Freeze Top Row. If the ribbon is simplified or the browser window is narrow, expand the menu or widen the window to find the command.

Common Mistakes

Choosing Freeze Panes instead of Freeze Top Row. These options do different things. Freeze Top Row is the quickest way to keep row 1 visible. Freeze Panes uses your current cell selection to determine which rows above it and columns to its left stay fixed. If the wrong cell was active, the result may include extra rows or columns. Unfreeze the panes and start again with the appropriate command.

Expecting Excel to freeze a middle row by itself. Excel’s freeze feature holds a continuous block starting at the top of the worksheet. If the labels are in row 3 and you select row 4 before choosing Freeze Panes, rows 1, 2, and 3 will all remain visible. Excel cannot keep only row 3 fixed while allowing rows 1 and 2 to scroll away. Move the heading to row 1 if you need just that row to remain visible.

Using the wrong sheet or workbook view. A freeze applies to the active worksheet, not automatically to every tab in the workbook. It can also be hard to judge the result if you are in a view other than Normal. Select the intended sheet, return to Normal view, and test by scrolling before assuming the setting did not work.

Confusing frozen rows with repeated print headings. Freezing a row affects what stays visible on screen as you scroll. It does not by itself repeat the row at the top of every printed page or PDF page. Print titles are a separate page-layout setting, so configure those separately when you need repeated headings on paper.

Leaving an old freeze in place. A worksheet may already have a frozen section, particularly if someone else prepared the file. Applying another freeze command without checking the current state can produce an unexpected boundary. Choose Unfreeze Panes first when you want a clean reset, then apply the intended setting.

Tips

Keep your actual column labels in row 1 when possible. A simple layout with headings in the first row makes the one-click Freeze Top Row option work as expected. Put a report title in a worksheet title area or another location that does not push the labels down, if your layout allows. If the title must occupy its own row, freezing both the title and headings may still be useful, but it will take more vertical screen space.

Use Freeze Panes for a larger fixed area. Freeze Panes can hold rows and columns at the same time. For instance, if row 1 contains headings and column A contains names, select cell B2 and choose View > Freeze Panes > Freeze Panes. The rows above B2 and the columns to its left stay in place. If you only need row 1, use Freeze Top Row instead; it is less sensitive to the active cell.

Look for the boundary line. The thin line under the frozen section is a quick visual check that the command took effect. If you cannot see it clearly, scroll down a little or inspect the boundary between the fixed and scrolling areas. The line is not a worksheet border and does not print as a divider.

Remember that freezing changes the view, not the data. It does not lock cells against editing, protect the worksheet, or prevent someone from changing the headings. Use worksheet protection or other controls if you need to restrict edits. Freezing is a display aid for navigating a large sheet.

Save the workbook after setting up the view. Saving makes it easier to return to the workbook with the intended layout available. If the file is shared, ask another user to check the sheet in their own Excel version if the view matters to their workflow. The setting does not change the contents of the cells.

Troubleshooting

The heading disappears when you scroll. Confirm that you chose Freeze Top Row rather than just opening the menu. Then check that row 1 is the row you meant to keep visible. If your labels are lower down, use the custom Freeze Panes method and select a cell in the row immediately below the entire block you want held in place. If the command appears to have no effect, choose Unfreeze Panes and apply it again.

The wrong rows or columns stay on screen. This usually means the active cell was not where you expected when you selected Freeze Panes. Clear the existing setup with View > Freeze Panes > Unfreeze Panes. For rows 1 through 3 only, select a cell in row 4, preferably in column A if you do not want to freeze any columns, and choose Freeze Panes. For row 1 plus column A, select B2 before choosing Freeze Panes.

Freeze Panes is unavailable or appears grayed out. Check that you are working in a worksheet rather than a chart sheet, and switch to View > Normal. If the workbook is in a restricted state or the ribbon is not fully shown, make the relevant sheet active and check the View menu again. In the web app, confirm that the workbook has finished loading and that you are not looking at a read-only preview that does not allow changes.

You cannot tell whether the row is frozen. Scroll down far enough for the first rows to leave the screen if they were not frozen. A frozen row remains at the top while the rest of the grid moves underneath it. You can also use the vertical scroll bar. If row 1 is hidden or its height is extremely small, unhide it or adjust its height so the frozen content can be seen.

The setting does not seem to carry over to another tab. Freeze panes are set per worksheet. Click the other sheet tab and apply the freeze there as well. If you are working in Excel for the web or a shared workbook, make sure your changes are saved and that you are checking the same workbook and sheet rather than a separate copy.

Frequently Asked Questions

Can I freeze only row 2 in Excel?
Not by itself. Excel freezes rows continuously from row 1 down. To keep row 2 visible, you would also freeze row 1. If you want only the headings to stay visible, move them to row 1 or accept that the rows above them will also remain fixed.

Does Freeze Top Row keep the first row visible when I scroll sideways?
Yes. Freeze Top Row keeps row 1 in view as you scroll vertically or horizontally. The command does not freeze any columns, so columns can still move left and right.

How do I freeze both the top row and the first column?
Unfreeze any existing panes, select cell B2, then choose View > Freeze Panes > Freeze Panes. The cell above the selection and the column to its left become the fixed areas: row 1 and column A.

How do I remove a frozen row?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current frozen rows and columns from that worksheet; it does not delete or alter any cell data.

Will the frozen row appear on every printed page?
No. Freeze Panes is for on-screen scrolling. To repeat a heading when printing, use the separate Print Titles setting on the Page Layout tab and specify the row to repeat.

Can I freeze a row in Excel for the web?
Yes. Open the View tab, choose Freeze Panes, and select Freeze Top Row. The available layout can differ slightly from the Windows desktop ribbon, but the same basic option is provided.

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.