Excel Freeze Panes: Keep Headers Visible While Scrolling

In Excel for Microsoft 365 on Windows, go to View > Freeze Panes and choose Freeze Panes, Freeze Top Row, or Freeze First Column. To keep a custom combination visible, select the cell immediately below the rows and to the right of the columns you want to keep on screen, then choose View > Freeze Panes > Freeze Panes.

What the Freeze Panes command does

Freeze Panes keeps selected worksheet rows or columns in place while you scroll through the rest of the sheet. It is useful when a long list extends beyond the screen and you need to keep its column labels, row identifiers, or both in view. For example, a sales worksheet might have hundreds of records below a header row. Freezing that top row lets you scroll through the records without losing the meaning of each column.

The command changes how the worksheet is displayed; it does not lock cells against editing, protect data, or alter the values in the workbook. You can still select and edit frozen cells, and other people can still edit them unless separate protection settings are applied. The frozen area stays visible as you move around the unfrozen part of the worksheet.

How to freeze rows and columns together

Excel bases a custom freeze on the active cell at the time you issue the command. Rows above that cell and columns to its left are frozen. The cell itself and everything below or to its right remain in the scrollable area. This makes the selected cell a boundary marker, rather than a cell that Excel freezes.

Click the cell below the last row you want to keep visible and to the right of the last column you want to keep visible.
Choose View > Freeze Panes > Freeze Panes.
Scroll down or across to check that the intended rows and columns stay in place.

For instance, suppose row 1 contains headings and columns A and B contain an ID and a customer name. Select cell C2 before choosing Freeze Panes. Excel freezes row 1 and columns A:B, leaving the records in the rest of the sheet free to scroll. If you want the first three rows and the first column to remain visible, select B4. Rows 1 through 3 and column A will be frozen.

To freeze rows only, select a cell in column A below the rows you want to retain. To freeze columns only, select a cell in row 1 to the right of those columns. Selecting A4, for example, freezes rows 1 through 3 and no columns. Selecting C1 freezes columns A and B and no rows.

Choosing among the three menu options

The Freeze Panes menu offers three commands, each suited to a different layout:

Freeze Panes: Uses the active cell to freeze all rows above it and columns to its left. Choose this for a custom arrangement or to freeze rows and columns together.
Freeze Top Row: Keeps worksheet row 1 visible while you scroll vertically. It does not freeze a lower row just because that row contains the table headings.
Freeze First Column: Keeps column A visible while you scroll horizontally. It does not freeze a different column, such as column B.

The dedicated Top Row and First Column commands are quick choices, but they cannot be used to specify a different row or column. If headings begin on row 4 because the sheet has a title and notes above the data, use the custom Freeze Panes command and select a cell beneath the headings. Similarly, if the identifier you need is in column C, select a cell to the right of C rather than choosing Freeze First Column.

Plan the boundary before freezing

Before using the command, decide which information must remain visible and whether it occupies consecutive rows or columns starting at the top and left edges. Freeze Panes can keep the upper rows and leftmost columns in place, but it cannot freeze an isolated middle row or a column without also freezing the columns before it. To keep rows 1 and 3 while row 2 scrolls, for example, this command cannot create that arrangement.

Think about the screen space the frozen area will use. Freezing several rows and columns can make a large worksheet easier to understand, but it also leaves less room for the scrolling data. A narrow ID column plus one header row may be enough for a simple list; a planning sheet with several heading rows may need more. If the sheet is difficult to read because its labels are spread across many rows, reorganizing or simplifying the layout may work better than freezing a large block.

Hidden rows or columns can also make a freeze boundary less obvious. If the result is not what you expected, check which cell was active when you selected the command and whether rows or columns are hidden. Unfreeze the current arrangement and try again after confirming the intended boundary.

Unfreeze panes and change the arrangement

Excel does not provide a separate drag handle for moving a freeze boundary. To change which rows or columns stay visible, first remove the current freeze and then apply a new one. In Windows Excel, choose View > Freeze Panes > Unfreeze Panes. Then select the correct boundary cell and choose Freeze Panes again, or select one of the preset commands.

If the menu shows Unfreeze Panes, a freeze arrangement is currently active. Use that command before applying a different one; otherwise you may mistake the existing setup for a newly selected boundary. Unfreezing only changes the scrolling display. It does not delete rows, move data, or change worksheet contents.

After setting a freeze, test it in both directions that matter. Scroll down to see whether the heading rows remain, and scroll horizontally to check the key identifying columns. If the wrong area stays fixed, unfreeze and repeat the selection step. Checking right away is quicker than trying to diagnose the boundary after working in the sheet for a while.

Windows, Mac, and Excel for the web

In Excel for Microsoft 365 on Windows, use View > Freeze Panes on the ribbon. The three choices described above are in that menu. The command applies to the active worksheet, so make sure you are on the sheet you intend to change.

Excel for Mac also provides Freeze Panes from the View tab. Ribbon organization and appearance can vary with the Excel release and window size, but look for the Freeze Panes control on that tab; the custom selection principle is the same. Excel for the web also has Freeze Panes under View. In the web version, available controls and their placement can depend on the current interface, but select a cell at the intended boundary before choosing the custom freeze option.

These steps concern Excel, not Google Sheets, whose menus and behavior are different. If you open a workbook in another spreadsheet app, do not assume that the command is in the same place or that the saved view will behave identically. When collaborating, check the worksheet in the version people actually use if the frozen arrangement is important to their workflow.

Freeze Panes compared with Split and print titles

Split is a related View command, but it serves a different purpose. A split divides the worksheet window into separate panes that can be scrolled independently. Freeze Panes instead keeps the specified top rows and left columns fixed while the remaining area scrolls. Use a split when you need to compare distant parts of the same sheet; use Freeze Panes when you need labels to remain visible alongside a scrolling list.

Freezing a row on screen is also not the same as repeating it on printed pages. Freeze Panes affects the worksheet view, while print titles control which rows or columns repeat on paper or in a print-to-PDF output. In Windows Excel, set those through Page Layout > Print Titles, then specify rows to repeat at the top or columns to repeat at the left in the Page Setup dialog. A worksheet may need both settings if it is used on screen and printed.

Excel tables offer another related convenience: when you scroll within a table, its column names can appear in the worksheet’s column-heading area in place of the usual column letters. That can help with a single table header row, but it is not a general substitute for freezing several worksheet rows or keeping identifying columns visible during horizontal scrolling.

Common problems and practical fixes

The wrong row or column is frozen: The active cell likely was not at the intended boundary. Choose Unfreeze Panes, select the cell below and right of the desired frozen area, and apply the custom command again.
Freeze Top Row keeps row 1, not my headings: That preset always targets the worksheet’s first row. For headings farther down, select a cell below them in column A and use Freeze Panes.
I cannot freeze a middle column by itself: Excel freezes a continuous block from the left edge. To retain column D, for example, columns A through D must be included; Excel cannot freeze D while allowing A through C to scroll.
The frozen area takes up too much room: Unfreeze and set a smaller boundary. Freezing too many rows or columns can leave little space to view the working data, especially on a small display.
My headings disappear in print: Freeze Panes is not a print setting. Use Page Layout > Print Titles to repeat heading rows on printed pages.
I cannot tell whether panes are frozen: Open View > Freeze Panes and check whether the menu offers Unfreeze Panes. You can also scroll the worksheet to see whether the expected edge remains stationary.

For a worksheet with a large blank title area, consider whether the title rows need to remain visible during data entry. If not, freeze only the actual column-heading row and any essential identifier columns. A thoughtful boundary makes the data easier to scan without turning the fixed area into a second, oversized window.

Frequently Asked Questions

How do I freeze the first two rows in Excel?
Select cell A3, then choose View > Freeze Panes > Freeze Panes. The rows above A3—rows 1 and 2—stay visible. The Freeze Top Row preset would freeze only row 1, so use the custom command for two rows.

Can I freeze the top row and the first column at the same time?
Yes. Select cell B2 and choose View > Freeze Panes > Freeze Panes. That freezes row 1 and column A. For more rows or columns, select the cell just below and to the right of the larger area you want to keep visible.

Why is Freeze Panes greyed out or unavailable?
First check that you are in a normal worksheet view and that the workbook is not in a state that restricts editing or view changes. If a freeze is already active, the menu may show Unfreeze Panes instead. In Excel for the web or Mac, interface availability can vary; confirm that you are viewing an editable worksheet rather than a read-only preview.

Does Freeze Panes protect cells from editing?
No. It only affects scrolling and visibility. To prevent changes, use worksheet protection separately, and choose protection settings appropriate to the workbook. A frozen header remains editable unless you take separate steps to protect it.

Does Freeze Panes make headings repeat on every printed page?
No. It keeps rows or columns visible while navigating the worksheet on screen. To repeat headings in printouts, use Page Layout > Print Titles and set the appropriate rows or columns in Page Setup.

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.