Freeze Top Row in Excel: Steps, Tips, and Common Issues

To keep the first row visible while you scroll in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Freeze Top Row. Excel holds row 1 at the top of the worksheet while the rows below it move, making column headings easier to read in a long table.

What Freeze Top Row does

Freeze Top Row is a worksheet viewing option. It keeps the first row in place on your screen as you scroll down through the rest of the sheet; it does not change the row’s contents, move data, or lock cells against editing. You can still select and edit cells in the frozen row, and the setting does not alter what is stored in the workbook.

The feature is useful when row 1 contains labels such as Date, Customer, Region, and Amount. Without a frozen heading, scrolling to row 80 can leave you looking at numbers without knowing which column each number belongs to. With the top row frozen, those labels remain visible so you can follow each record correctly.

Freeze Top Row always means worksheet row 1. It does not mean the first row currently visible after scrolling, the first row in a selected range, or a heading several rows down. If your actual headings are in row 4, you need a different freeze setup to keep rows 1 through 3 visible.

How to freeze the top row

In Excel for Microsoft 365 on Windows, use the ribbon command. You do not need to select row 1 or a cell before applying it.

Open the worksheet you want to work with.
Select the View tab on the ribbon.
Choose Freeze Panes in the Window group.
Select Freeze Top Row from the menu.
Scroll down to confirm that row 1 stays visible.

A thin line below the frozen row indicates the boundary between the fixed area and the part of the sheet that scrolls. The line can be subtle, especially with a busy worksheet or a narrow window. The more reliable check is to scroll down: the contents of row 1 should remain at the top.

On Windows, the ribbon KeyTips may let you reach the command with Alt+W, F, R, pressing the keys in sequence rather than holding them all together. KeyTips can differ with Excel versions, ribbon layouts, and language settings, so the View menu is the dependable route if that sequence does not work. Excel for Mac does not have the same default Windows KeyTip sequence; use the View tab and its Freeze Panes menu.

Freeze a heading row that is not row 1

If your column labels are lower down, use Freeze Panes rather than Freeze Top Row. The general rule is that Excel freezes the rows above the selected cell and the columns to its left. For example, if headings are in row 4 and you want rows 1 through 4 to stay visible, select cell A5, then choose View > Freeze Panes > Freeze Panes. Rows 1 through 4 remain fixed while the rows below them scroll.

For a simple table with a title in row 1, a blank row in row 2, and headings in row 3, selecting A4 before choosing Freeze Panes keeps all three upper rows in view. Excel freezes the rows above the selected cell, not just the row that looks like a heading. This distinction matters: selecting A3 would freeze only rows 1 and 2, leaving the labels in row 3 free to scroll away.

Before applying a custom freeze, think about how much of the screen should remain fixed. Keeping several large-height rows on screen can leave little room for the records you need to review. If the frozen area is larger than expected, unfreeze it and choose a cell closer to the headings.

Freeze the top row and first column together

Freeze Top Row and Freeze First Column are convenient one-part options, but choosing either one on its own does not add the other frozen area. To keep both the headings in row 1 and labels in column A visible at the same time, use the general Freeze Panes command from cell B2.

If another freeze setting is active, first choose View > Freeze Panes > Unfreeze Panes.
Select cell B2.
Choose View > Freeze Panes > Freeze Panes, the first command in the menu.
Scroll down and to the right to check that row 1 and column A remain visible.

Cell B2 is the key because it is immediately below row 1 and immediately to the right of column A. In general, selecting a cell below and to the right of the rows and columns you want to retain freezes everything above and to the left. For example, selecting C4 freezes rows 1 through 3 and columns A and B. Use this deliberately: Excel may freeze more than you intended if you select a cell farther down or across.

Unfreeze panes and change the setting

To remove a freeze, select View > Freeze Panes > Unfreeze Panes. The worksheet returns to normal scrolling. Then apply the setting you actually want. For example, if you first froze rows 1 through 3 with a custom selection but only need row 1, unfreeze the panes and choose Freeze Top Row.

Excel uses one freeze configuration at a time on a worksheet. Choosing a different freeze option replaces the current configuration; it does not stack a second independent freeze on top. If a menu choice appears unavailable or the result is unexpected, unfreezing first is a useful way to clear the existing arrangement and start again.

Freeze settings belong to individual worksheets. Freezing the top row on one tab does not automatically freeze the top row on every other tab in the workbook. Apply the setting separately to each worksheet where it is useful. The workbook saves the view setting, so it generally remains in place when the file is saved and reopened.

Excel for Mac and Excel for the web

In Excel for Mac, the ribbon has the same general route: open View, choose Freeze Panes, and select Freeze Top Row. If you are using a version with a different ribbon arrangement, look for the Freeze Panes menu on the View tab. The Windows Alt+W, F, R KeyTip sequence is not the Mac equivalent; use the visible menu command rather than assuming a Windows shortcut will work.

In Excel for the web, open the workbook in a browser and use the View tab’s Freeze Panes controls. The available commands and their placement can depend on the current web interface and window width, but the goal is the same: choose Freeze Top Row for row 1, or select a cell and use Freeze Panes for a custom boundary. If the command is difficult to locate, expand the ribbon or check the View tab’s menus.

These are display controls, not changes to worksheet data. In a shared workbook, another person’s current scroll position is not the same thing as your freeze setting. If you are collaborating, confirm the saved workbook view behaves as expected when reopened; do not assume that freezing a row protects headings from edits or guarantees that every collaborator sees an identical active cell.

Freeze panes, split panes, and printed headings

Freeze panes are for keeping part of a worksheet visible while you navigate the rest. They are not the same as repeating headings on printed pages. If you want a header row to appear on every printed page, use Page Layout > Print Titles and set the rows to repeat at the top. A row that is frozen on screen does not automatically repeat in a printout.

Split panes also divide the worksheet window, but they create separate scrolling areas instead of simply keeping a chosen top section or left section fixed. A split can be useful when you want to compare distant parts of one sheet, such as the top and bottom of a long list. For ordinary column labels, Freeze Top Row is usually the simpler choice. If you see movable dividing bars or independent scroll areas, check whether Split was used rather than Freeze Panes.

Neither option should be confused with protecting a worksheet. Freezing a row does not prevent someone from changing or deleting its contents. If the goal is to restrict editing, worksheet protection is a separate feature with separate settings.

Common problems and quick checks

The headings still scroll away: Confirm that the headings are actually in row 1. If they are in a lower row, choose a cell immediately below the rows you want fixed and use Freeze Panes.
The wrong rows or columns are frozen: Choose Unfreeze Panes, then select the correct cell before applying the general Freeze Panes command. Remember that Excel freezes every row above and column to the left of that cell.
Only the first column stays visible: You may have selected Freeze First Column. Unfreeze it, then choose Freeze Top Row, or use B2 with Freeze Panes to keep both row 1 and column A.
The line is hard to see: Scroll the worksheet and check whether row 1 remains visible rather than relying only on the boundary line.
It does not repeat when printed: Set Print Titles under Page Layout. Freeze Panes controls the on-screen view, not printed page headers.
The setting seems to affect only one tab: Freeze panes are set per worksheet. Repeat the command on each relevant sheet.

If a worksheet is protected, shared, or displayed in a constrained window, some controls may appear differently or be harder to access. Check that you are on the intended worksheet and that Excel is showing the ribbon’s View commands. Avoid changing data to solve a viewing problem: freeze settings can be adjusted without rearranging the table.

Frequently Asked Questions

Can I freeze the top two rows in Excel?

Yes. Select cell A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible because they are above the selected cell. This is different from Freeze Top Row, which freezes only row 1.

Can I freeze the top row and first column at the same time?

Yes. First unfreeze any existing panes, select B2, and choose View > Freeze Panes > Freeze Panes. The row above and column to the left of B2 stay in view.

Why is Freeze Top Row greyed out?

Check whether the worksheet window or workbook is in a state that limits editing or view commands, and make sure you are using the worksheet View tab rather than another ribbon tab. If another freeze configuration is active, choose Unfreeze Panes and check the menu again. The exact availability can depend on the workbook and Excel version.

Does Freeze Top Row work when I print?

No. It keeps row 1 visible while you scroll on screen. To print the same heading row on multiple pages, use Page Layout > Print Titles and specify the row to repeat at the top.

How do I freeze a row below the first row?

Select the cell immediately below the last row you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select A6 to keep rows 1 through 5 fixed. The general command freezes all rows above the selected cell, whether or not they contain headings.

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.