Excel Freeze Panes Tutorial: Keep Rows and Columns Visible

To keep headings or identifier columns visible while you scroll in Excel for Microsoft 365 on Windows, select the cell just below the rows and just to the right of the columns you want to keep on screen, then choose View > Freeze Panes > Freeze Panes. For a simpler option, use View > Freeze Panes > Freeze Top Row or Freeze First Column.

What Freeze Panes Does

Freeze Panes keeps selected rows at the top of the worksheet, selected columns at the left, or both in place as you scroll through the rest of the sheet. The frozen area remains visible so you can keep referring to column headings or row labels without returning to the beginning of the worksheet. It changes how the worksheet is displayed, not the underlying data.

For example, a sales sheet might have a header row with headings such as Date, Region, and Revenue, followed by hundreds of transactions. Freezing the top row keeps those headings visible while you move down the list. If column A contains employee names and the remaining columns contain monthly figures, freezing the first column keeps each row’s name in view as you scroll horizontally.

Freeze Panes applies to the active worksheet, not automatically to every sheet in the workbook. It is useful in a worksheet window, but it does not make rows or columns repeat on printed pages. For printouts, use the separate Print Titles feature.

Freeze the Top Row or First Column

These built-in commands are the quickest choices when you need to keep only the first row or first column visible. In Excel for Microsoft 365 on Windows:

Open the worksheet you want to adjust.
Select the View tab on the ribbon.
Open Freeze Panes in the Window group.
Choose Freeze Top Row or Freeze First Column.

Freeze Top Row keeps worksheet row 1 visible when you scroll down. Freeze First Column keeps column A visible when you scroll to the right. These options refer to the sheet’s first row or first column; they do not freeze whichever row or column happens to be selected. If your headings are in row 3, for instance, Freeze Top Row will keep row 1 visible, not row 3. Use a custom freeze for headings lower down the sheet.

Freeze Specific Rows and Columns Together

To freeze a custom area, select a cell that is immediately below all the rows and immediately to the right of all the columns you want to keep visible. Then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selected cell and the columns to its left. The selected cell itself is not the boundary area that becomes frozen.

Suppose a worksheet has two heading rows and employee names in column A. Select cell B3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 stay at the top, and column A stays at the left. The rest of the worksheet scrolls below and to the right of those frozen areas. This is one of the most useful setups for a large report with stacked headings and a key field.

To freeze just rows 1 through 3, select A4 before choosing Freeze Panes. To freeze columns A and B but no rows, select C1. The rule is consistent: the active cell marks the upper-left corner of the scrolling area. Excel freezes everything above and to the left of that corner.

How to Choose the Right Cell

Decide first what must remain visible while you navigate. Then translate that choice into a cell selection: the row number should be one greater than the last row to freeze, and the column letter should be one column to the right of the last column to freeze.

Keep row 1 only: use Freeze Top Row, or select A2 and choose Freeze Panes.
Keep column A only: use Freeze First Column, or select B1 and choose Freeze Panes.
Keep rows 1–2 and column A: select B3.
Keep rows 1–4 and columns A–C: select D5.

These examples assume the areas to freeze start at the worksheet’s top and left edges, as freeze panes are designed to hold the rows above and columns to the left of the selected cell. You cannot use this feature to freeze an arbitrary middle block while allowing areas on both sides of it to scroll independently. If your layout has headings or labels separated from the top-left corner, consider reorganizing the sheet or using a table and filters instead.

Scrolling and the Freeze Boundary

After freezing panes, Excel shows a boundary line that separates the fixed area from the scrolling area. Scroll down to move the unfrozen rows, or scroll horizontally to move the unfrozen columns. The frozen headings and labels stay put while the data area moves. You can still select and edit cells in either area; freezing is not a way to protect cells from changes.

For a quick check, move down several screens and then scroll back up. If the rows or columns you intended to keep visible remain on screen, the setup is working. If too many rows or columns are frozen, the scrolling area can become cramped, especially on a small display. Freeze only the context you need, and consider widening the Excel window or reducing the frozen area if little room remains for data.

Unfreeze or Change the Panes

To remove the current freeze, select View > Freeze Panes > Unfreeze Panes. This restores normal scrolling on the active worksheet. If you want a different arrangement, unfreeze first, select the new boundary cell, and apply Freeze Panes again. Starting from a clear, unfrozen view makes it easier to understand which rows and columns the next selection will hold in place.

If you select Freeze Top Row or Freeze First Column after setting a custom arrangement, check the resulting boundary rather than assuming the old arrangement remains. These commands change the current freeze configuration. You can also save the workbook after setting the view so that the worksheet opens with the intended arrangement in supported desktop Excel versions. Other people opening the workbook may still change the view on their own copy or session.

Common Problems and Misconceptions

The wrong rows stay visible: Freeze Top Row always targets row 1. If your actual headings are lower, unfreeze and use a custom cell such as A4 to hold rows 1–3.
The selected row or column is frozen unexpectedly: The selected cell defines the scrolling region. Excel freezes rows above it and columns to its left, not the row and column containing the cell.
The whole sheet seems to move: Check that Freeze Panes is active and that you are scrolling the worksheet rather than changing the active sheet or window. A visible boundary line can help identify the frozen area.
There is not enough room to work: Too many frozen rows or columns can cover much of a small window. Unfreeze and select a closer boundary.
Freeze Panes does not repeat headings when printing: Screen freezing and printed page headings are separate features. Set print titles through Page Layout > Print Titles when you need repeated rows or columns on printed pages.

Another common misconception is that freezing protects data. It does not lock cells, prevent edits, or stop someone from changing values. Use worksheet protection if you need to restrict editing, and use Freeze Panes only to make navigation easier.

Freeze Panes, Split, and Tables

Freeze Panes is for keeping a top section or left section visible while the rest of the worksheet scrolls. Split is a different viewing tool: it divides the worksheet window into separate panes that can be scrolled independently. A split can help compare distant parts of a sheet, but it is not usually the simplest way to keep column headings in view. To remove a split, use View > Split to turn it off; to remove frozen panes, use Unfreeze Panes.

Excel tables offer another kind of context. When you convert a data range into a table, its header row can appear in place of the worksheet’s column letters as you scroll within the table, depending on the view and location. Tables also provide features such as filter buttons and structured formatting. They do not replace every use of Freeze Panes: a worksheet may have explanatory rows above a table, or labels that need to remain visible while navigating beyond the table. Choose the tool based on the layout and task.

Excel for Mac and Excel for the Web

In Excel for Microsoft 365 on Mac, use the View tab and the Freeze Panes commands to freeze the top row, first column, or a custom selection. The ribbon’s appearance can differ from Windows, but the custom-selection rule is the same: select the cell below and to the right of the area to keep visible, then apply Freeze Panes. There is no need to select the heading row itself.

Excel for the web also provides freeze controls on the View tab. The exact arrangement of commands can vary as the web interface changes, but look for Freeze Panes and its options. If a workbook is opened in a different Excel version or browser, confirm the view after making changes. For a custom arrangement, the same boundary principle applies wherever the command is available.

Frequently Asked Questions

Can I freeze more than one row in Excel?
Yes. Select the cell directly below the last row you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select A4 to freeze rows 1 through 3.

Can I freeze a row and a column at the same time?
Yes. Select the cell below the rows and to the right of the columns you want to freeze. Selecting B3 freezes rows 1 and 2 and column A.

Why is Freeze Top Row not freezing my heading row?
That command targets worksheet row 1, regardless of where your headings are. If the headings are in another row, unfreeze the current setting, select the cell immediately below the headings, and apply Freeze Panes.

How do I remove Freeze Panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the frozen rows and columns from the current worksheet view without changing worksheet data.

Can I freeze panes in the middle of a worksheet?
You can freeze rows above and columns to the left of a selected cell, but you cannot freeze an arbitrary interior block by itself. Freeze Panes anchors areas to the top and left edges of the worksheet.

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.