Freeze Panes in Excel: How to Keep the First Row Visible

To keep the first row visible while you scroll in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Freeze Top Row. Excel keeps row 1 at the top of the worksheet as you move down, making it easier to refer to column headings without changing the data or its layout.

What Freeze Top Row Does

Freeze Top Row pins the worksheet’s first row to the top of the Excel window. The rows below it continue to scroll normally. If row 1 contains headings such as Date, Customer, Region, and Total, those labels remain visible while you inspect records farther down the sheet.

The command affects how the worksheet appears on screen; it does not lock the row against editing, protect its contents, or repeat the row on printed pages. It also does not move or copy anything. The freeze boundary is a visual division between the fixed area and the part of the sheet that scrolls.

Freezing is useful in long lists, schedules, inventory sheets, and other layouts where the meaning of a value depends on its column heading. It can also help when reviewing a report on a laptop screen, where only a portion of the worksheet is visible at once.

How to Freeze the First Row

In Excel for Microsoft 365 on Windows, use the View tab on the ribbon. You do not need to select row 1 or click a cell in the header before using the dedicated command.

Open the worksheet where you want the heading to stay visible.
Select View on the ribbon.
Open Freeze Panes.
Select Freeze Top Row.
Scroll down to confirm that row 1 remains at the top of the window.

Excel marks the frozen boundary with a thin line below the first row. The worksheet is still one continuous grid; the line simply indicates where the scrolling area begins. You can continue to edit cells in either the frozen area or the scrolling area unless other worksheet protections are in place.

In Excel for Mac, the corresponding ribbon command is generally View > Freeze Panes > Freeze Top Row. In Excel for the web, open the View tab and choose Freeze Panes > Freeze Top Row. The wording and arrangement can vary slightly with interface updates, but look under View for the Freeze Panes menu.

Choosing Between Freeze Top Row and Freeze Panes

The Freeze Panes menu includes commands for common layouts. Freeze Top Row is the simplest choice when only row 1 should stay visible. Freeze First Column keeps column A visible during horizontal scrolling. Freeze Panes lets you choose a custom boundary, which is useful when the worksheet has multiple heading rows or identifying columns.

For the custom command, Excel freezes rows above the active cell and columns to its left. For example:

To freeze rows 1 and 2, select cell A3, then choose View > Freeze Panes > Freeze Panes.
To freeze columns A and B, select cell C1, then choose Freeze Panes.
To freeze row 1 and column A together, select cell B2, then choose Freeze Panes.

That last example is a frequent source of confusion. Selecting Freeze Top Row does not also freeze the first column. To hold both areas in place, use the custom Freeze Panes command with the selection at B2. The selected cell itself remains in the scrolling area; the rows above it and columns to its left are the parts that stay fixed.

Freezing More Than One Row or Column

Use the custom Freeze Panes command when your headings occupy more than one row. Suppose a sales worksheet has a report title in row 1 and column labels in row 2. To keep both visible, select A3 and choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 will remain at the top as you scroll through the transactions.

Likewise, a sheet may use columns A and B for an employee ID and name, with data extending far to the right. Select C1 before choosing Freeze Panes to keep those two identifying columns visible during horizontal scrolling. For a layout that needs both fixed rows and fixed columns, select the cell immediately below the rows and immediately to the right of the columns you want to hold.

Check the boundary before committing to a custom setup. If you want rows 1 through 3 and columns A through C to remain visible, select D4. If you select D3 instead, only rows 1 and 2 are above the selection, so row 3 will scroll. The position of the active cell—not the highlighted range—is what determines the custom freeze boundary.

How to Unfreeze or Change the Boundary

Excel normally allows one freeze configuration per worksheet window. If the wrong rows or columns are fixed, or you want to replace a custom setup with Freeze Top Row, first clear the existing freeze:

Open View > Freeze Panes.
Select Unfreeze Panes.
Open the menu again and choose Freeze Top Row, Freeze First Column, or a custom Freeze Panes setup.

Unfreeze Panes removes the current freeze boundary; it does not delete worksheet content. Then select the appropriate command to create the new arrangement. For example, if a sheet currently freezes rows 1 and 2, choose Unfreeze Panes before switching to Freeze Top Row. Otherwise, Excel may continue to apply the existing custom freeze instead of the layout you intended.

Common Problems and Misconceptions

If the first row still scrolls, the most likely issue is that Freeze Top Row was not applied to the active worksheet, or a different freeze arrangement is in place. Open the Freeze Panes menu and check whether it offers Unfreeze Panes. If it does, a freeze is already active; unfreeze it and apply the intended command again.

Other practical checks include:

Confirm the active sheet. Freeze settings apply to a worksheet, not automatically to every sheet in the workbook. Repeat the command on each sheet where you need it.
Check the boundary. If you used the custom command, verify that the active cell was in the right position before choosing Freeze Panes.
Distinguish freezing from splitting. Split divides a window into separately scrollable panes. If you see multiple scroll areas rather than a simple fixed heading, look for the Split control on the View tab and turn it off if appropriate.
Remember that scrolling can be horizontal or vertical. Freeze Top Row holds a row during vertical movement; it does not keep a left-hand column visible when you move sideways.

A freeze also does not prevent a user from changing the contents of row 1. To restrict editing, use worksheet protection and choose the appropriate locked-cell settings; that is a separate feature with a different purpose.

Freeze Panes, Excel Tables, and Printing

Excel Tables can make headings easier to follow in a structured list. When you scroll within a table, Excel can show the table’s column names in the worksheet’s column-heading area, which may reduce the need to freeze the first row for that table. This behavior is tied to working within the table and is not the same as freezing worksheet row 1. A table also offers features such as filtering, but converting a range to a table changes how the data is organized, so it is not necessary just to keep a heading visible.

Freeze Panes is also not a print setting. A row frozen on screen does not automatically repeat on every printed page. To repeat heading rows in printouts, use Page Layout > Print Titles, then set the rows to repeat at the top in Page Setup. This is useful for a long report printed across multiple pages; use Freeze Panes for on-screen navigation and Print Titles for printed output.

These features can be used independently. A workbook might freeze row 1 for people reviewing it on screen and also set row 1 as a print title so it appears on each printed page. One setting does not replace the other.

When Freezing the First Row Is Most Useful

Freeze Top Row is especially helpful when a worksheet contains many records and the headings explain what each field means. Consider a volunteer roster with hundreds of entries: columns might identify the person, shift, location, and status. Without a fixed heading row, a value such as Evening or Confirmed can become difficult to interpret after scrolling several screens down.

It is less useful when the worksheet is short enough to fit on screen, or when row 1 is a title and the actual column headings appear in row 3. In that case, freezing only the top row may preserve the title but let the useful headings scroll away. Use the custom command to freeze rows 1 through 3, or consider moving the column labels to the first row if the worksheet design allows it.

Before sharing a workbook, consider whether the fixed area helps a reader understand the data and whether it takes up too much of the visible screen. Freezing several rows and columns can make navigation easier, but a large fixed area leaves less room for the scrolling worksheet, particularly on a small display.

Frequently Asked Questions

What is the quickest way to freeze the top row in Excel?
Choose View > Freeze Panes > Freeze Top Row. The command is available in Excel for Microsoft 365 on Windows, and similar Freeze Panes commands are available in Excel for Mac and Excel for the web.

Can I freeze the top row and first column at the same time?
Yes. Select cell B2, then choose View > Freeze Panes > Freeze Panes. Excel freezes the row above and the column to the left, so row 1 and column A remain visible.

Why is Freeze Top Row unavailable or not working as expected?
Check that you are on the intended worksheet and look in the Freeze Panes menu for Unfreeze Panes. If a different boundary is active, unfreeze it first. Then apply Freeze Top Row again.

Does freezing the first row make it repeat when I print?
No. Freeze Panes controls the worksheet view on screen. For printed pages, set repeating heading rows through Page Layout > Print Titles.

Does Freeze Top Row work if my headings are in row 2?
Not by itself; it freezes worksheet row 1. To keep rows 1 and 2 visible, select A3 and choose the custom Freeze Panes command.

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.