How to Freeze Panes in Excel: Keep Rows and Columns

To freeze panes in Excel for Microsoft 365 on Windows, select the cell immediately below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For a quick option, use View > Freeze Panes > Freeze Top Row or Freeze First Column.

What Freeze Panes Does

Freeze Panes keeps selected worksheet rows, columns, or both in view while you scroll through the rest of the sheet. It is especially useful when a worksheet extends beyond one screen and you need to keep column labels, dates, employee names, or product identifiers visible as you inspect the data below or beside them.

Freezing panes changes how the worksheet is displayed; it does not move, copy, lock, or protect cells. You can still edit the frozen cells unless the worksheet has separate protection settings. Other people who open the workbook can also change the freeze setting in their view. The feature applies to the active worksheet, so check which sheet is selected before using it.

How to Freeze Panes Step by Step

Open the worksheet you want to work with and decide which rows and columns should remain visible.
Select the cell just below the last row you want frozen and just to the right of the last column you want frozen. If you only want to freeze rows, select a cell in column A. If you only want to freeze columns, select a cell in row 1.
On the ribbon, choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above and the columns to the left of the selected cell.
Scroll down, right, or both ways to confirm the intended headings stay on screen. If the wrong area is fixed, unfreeze it and repeat the steps with a different cell.

The selected cell itself is not the boundary of the frozen area: the rows above it and columns to its left are. For example, selecting C4 freezes rows 1 through 3 and columns A and B. The remaining worksheet scrolls in the area to the right and below those frozen sections.

Examples: Freeze a Header, Several Rows, or Columns

These examples assume the worksheet starts at cell A1. Choose the cell shown, then use View > Freeze Panes > Freeze Panes, unless the example names a dedicated command.

Keep the top three rows visible: select A4. Rows 1, 2, and 3 remain visible as you scroll down. This works well when a report has a title and a two-row header.
Keep columns A and B visible: select C1. The first two columns remain on screen while you scroll horizontally to later columns.
Keep the top three rows and first two columns visible: select C4. Excel freezes rows 1–3 and columns A–B together.
Keep only row 1 visible: choose View > Freeze Panes > Freeze Top Row. You do not need to select a cell first.
Keep only column A visible: choose View > Freeze Panes > Freeze First Column. This is handy for a list where each row’s identifier is in column A.

For instance, in a sales sheet with dates and headings in rows 1–3, and salesperson and region in columns A and B, selecting C4 keeps all of those labels in view. You can then scroll to later months or down to additional sales records without losing the context needed to read each value.

Choosing Which Rows and Columns to Freeze

Freeze the smallest useful set of labels. Keeping too many rows or columns fixed can leave little room for the data you are trying to inspect, particularly on a laptop screen. Before choosing a boundary, consider how the sheet is actually read: a wide financial report may need its account names fixed on the left, while a long inventory list may need only its column headings at the top.

When both directions matter, freeze a rectangular area from the worksheet’s top-left corner. Excel freezes all rows above and all columns to the left of your selected cell; it does not let you choose unrelated rows or columns individually. For example, selecting D6 freezes rows 1–5 and columns A–C, not just row 5 and column C. If the result includes extra blank rows or columns, choose a cell closer to the top-left corner.

It is also worth checking whether the worksheet has blank rows or columns before the data. A blank row above the headings still counts when you choose the freeze boundary. The correct selection is based on worksheet positions, not on which row looks like the first meaningful heading.

Unfreeze Panes and Correct a Mistake

To remove the current frozen rows and columns, choose View > Freeze Panes > Unfreeze Panes. Excel then allows the entire sheet to scroll normally. If you need a different combination, unfreeze first, select the new boundary cell, and apply Freeze Panes again. Applying a new freeze choice replaces the existing one; it does not add a second, independent frozen region.

If the wrong rows or columns stay visible, check the selected cell and count the rows above it and columns to its left. A common mistake is selecting the row or column that should remain frozen rather than the cell just beyond the frozen area. To freeze row 1 and columns A–B together, for example, select C2—not B1.

If the command seems unavailable or does not behave as expected, try these checks:

Confirm that the correct worksheet is active. Freeze settings are applied to a sheet, not to every sheet in the workbook at once.
Look for an existing freeze and choose Unfreeze Panes before setting a new boundary.
Check that you selected a cell in the worksheet grid, not a chart, shape, or another object.
Scroll both vertically and horizontally. A freeze boundary may be easy to miss if you test only one direction.
If the frozen area is so large that it hides much of the working space, unfreeze and select a cell closer to A1.

Freeze Panes is not the same as protecting a worksheet. If the goal is to stop other people from changing headings or formulas, use the relevant cell-locking and worksheet-protection features; freezing only keeps an area visible during scrolling.

Excel for the Web and Mac

In Excel for the web, open the worksheet and look for View > Freeze Panes. The available commands and their presentation can vary with the current web interface, but the selection principle is the same: choose the cell below and to the right of the area to keep visible, then apply the freeze command. If the web version does not offer the precise control you need, open the workbook in the desktop app.

In Excel for Mac, use the View tab and its Freeze Panes controls when they are available in your ribbon layout. Select the boundary cell first for a custom combination, or choose the top-row or first-column option for a single heading area. Menu placement can differ by Mac version and interface, so search the ribbon or menus for “Freeze Panes” if the command is not where you expect. The key behavior—freezing rows above and columns to the left of the selection—remains the same.

These instructions use the ribbon and therefore do not depend on a keyboard shortcut. Excel access-key sequences are tied to the application’s interface and can vary, so the visible ribbon path is the clearest route across Windows versions and layouts.

Freeze Panes Compared with Other Options

Freeze Panes is meant for navigating a worksheet on screen. It should not be confused with printing titles, which repeat chosen rows or columns on printed pages. If a heading must appear on every printed page, configure print titles through the page-layout or print setup controls; freezing a row alone does not make it repeat in a printout.

It is also different from hiding rows or columns. Hidden cells are removed from the visible worksheet area until they are unhidden, whereas frozen cells remain visible while the rest of the sheet scrolls. Excel’s Split command can divide the worksheet into independently scrollable panes, which is useful when comparing distant parts of a sheet, but that is a different display arrangement from keeping one header area fixed. For ordinary data lists, Freeze Panes is usually the simpler choice.

For structured data, an Excel table can provide helpful column headers and filtering controls, but a table does not replace every freeze-pane use case. If you need a particular set of worksheet rows or left-hand columns to stay in view during scrolling, set Freeze Panes separately. Conversely, if the sheet fits on screen or its labels are repeated throughout the data, freezing may not be necessary.

Frequently Asked Questions

How do I freeze the first two rows in Excel?
Select cell A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible when you scroll down.

Can I freeze a row and a column at the same time?
Yes. Select the cell below the row area and to the right of the column area you want to keep visible. For example, select B2 to freeze row 1 and column A together.

Why is Freeze Panes freezing the wrong rows or columns?
The command freezes every row above and every column to the left of the selected cell. Unfreeze the current setting, then select the cell immediately beyond the intended frozen area.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current freeze setting from the active worksheet but does not delete or change any cell data.

Does Freeze Panes keep headings visible when I print?
No. It affects worksheet scrolling on screen, not repeated print headings. Set print titles separately if you want rows or columns to appear on each printed page.

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.