Excel Freeze Panes at Selection: Steps, Limits, and Tips

To freeze panes at a selection 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 visible, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above and the columns to the left of that cell; the selected cell itself remains in the scrollable area.

What “Freeze Panes at Selection” Means

Freeze Panes is designed to keep useful labels or reference information on screen while you scroll through a larger worksheet. Its position is determined by the active cell when you issue the command. Excel draws a boundary above that cell and another to its left, when applicable. The worksheet area above the horizontal boundary and left of the vertical boundary stays fixed; the rest can scroll.

For example, select B2 and freeze panes to keep row 1 and column A visible. Select D5 to keep rows 1 through 4 and columns A through C visible. That second setup is useful when a report has several header rows and multiple columns of identifying information. It does not freeze row 5 or column D: those begin the scrolling section.

Only the active cell matters, not a highlighted range. If several cells are selected, Excel uses the active cell within that selection as the reference point. Check which cell is active before choosing the command, especially when a range has been selected by dragging.

How to Freeze Panes at a Specific Cell

Open the worksheet and click the cell that marks the top-left corner of the area you want to scroll.
On the ribbon, select View > Freeze Panes > Freeze Panes. Choose the first Freeze Panes command in the menu, not Freeze Top Row or Freeze First Column.
Scroll down or right to confirm that the intended headings and identifying columns remain visible.

Suppose a table has two heading rows and three identifying columns. Select D3, then choose Freeze Panes. Rows 1 and 2 and columns A through C stay in place. If you instead select D4, the first three rows and first three columns stay fixed. This is why choosing the correct starting cell is more reliable than trying to adjust a freeze line afterward.

In the English Windows ribbon, the key-tip sequence Alt+W, F, F opens the Freeze Panes command. Press the keys in sequence, following the displayed key tips rather than holding all three together. Ribbon key tips can vary with language or interface changes, so the menu path is the clearest option. Excel for Mac also provides Freeze Panes on the View tab, though ribbon and menu layouts differ; use the visible command if the Windows key sequence does not apply. Excel for the web has freeze controls on the View tab, with labels or placement that can vary slightly by interface.

How to Choose the Right Cell

Work backward from what you need to keep visible. Count the complete rows and columns that should stay on screen, then select the first cell outside both groups. If you want only the top three rows frozen, select A4. If you want only columns A and B frozen, select C1. To freeze both groups together, select the cell below the last header row and right of the last reference column.

Column headings only: If the headings are in row 1, select A2 and freeze panes.
Row labels only: If labels are in column A, select B1 and freeze panes.
Headings and labels: If headings occupy rows 1–2 and labels occupy columns A–B, select C3.

When the worksheet has a title above its actual table headings, decide whether the title should remain visible too. For instance, if the title is in row 1 and the column headings are in row 3, selecting A4 freezes rows 1 through 3. If you want only row 3 to remain visible while rows 1 and 2 scroll away, Freeze Panes cannot freeze a lower row while leaving rows above it unfrozen. You may need to reorganize the sheet or use another display method.

Freeze Panes, Freeze Top Row, and Freeze First Column

The Freeze Panes menu offers preset choices as well as the selection-based command. Freeze Top Row keeps row 1 visible, and Freeze First Column keeps column A visible. These are convenient when the information to retain is in exactly those locations. The general Freeze Panes command is the flexible choice when you need a different boundary or need to freeze rows and columns together.

The presets do not mean “freeze whichever row or column is selected.” For example, selecting row 4 and choosing Freeze Top Row still freezes the worksheet’s first row. To freeze the first four rows, select A5 and choose the general Freeze Panes command. Similarly, to freeze columns A through C, select D1 and use the general command.

Changing or Removing a Freeze

To replace an existing freeze, first remove it: choose View > Freeze Panes > Unfreeze Panes. Then select the new boundary cell and choose Freeze Panes again. This reset matters because choosing a new position while panes are already frozen does not simply move the existing boundary.

After unfreezing, the worksheet returns to normal scrolling. Nothing is deleted or moved; freezing changes how the sheet is displayed, not the cell data. You can then set a different freeze or leave panes unfrozen. If the command displays Unfreeze Panes where you expected a freeze choice, a freeze is already active on that sheet view.

Common Problems and Misunderstandings

The wrong rows or columns stay visible: Unfreeze, check the active cell, and repeat. Remember that the selected row and column are on the scrolling side of the boundary.
Only the first row or column is frozen: You may have chosen a preset. Unfreeze and use the general Freeze Panes command with a carefully chosen cell.
The command is unavailable or behaves unexpectedly: Finish editing the cell by pressing Enter or Esc, then select a worksheet cell and try again. Also check whether the sheet is protected or whether an unusual window or display arrangement is affecting the ribbon.
Some rows or columns seem to be missing: Hidden rows or columns can make a boundary less obvious. Unhide the relevant area temporarily, set or inspect the freeze boundary, and then restore the intended layout.
The frozen area takes up too much of the screen: Unfreeze and choose a cell closer to the top-left corner. Freezing many rows and columns can leave too little room for the scrolling data, particularly on a small display.

Freeze Panes also does not lock cells against editing, protect formulas, or keep a heading visible when printing. Those are separate tasks: worksheet protection controls editing, while print titles are configured separately for printed pages. A freeze is a screen-view aid, not a security or print-layout feature.

Freeze Panes Compared With Split

Freeze Panes keeps the designated top and left portions stationary as you scroll the rest of the sheet. Split, available from the View tab, divides the worksheet window into sections that can be scrolled independently. Split can help compare distant parts of a sheet, but it does not serve the same purpose as keeping a header permanently fixed. If you see separate scroll bars or independently moving sections, you may have applied Split rather than Freeze Panes.

Choose Freeze Panes for a long list whose headers should remain visible. Consider Split when you need to inspect two different worksheet areas at once. To switch between approaches, remove the current arrangement using the relevant View controls, then apply the one that matches the task.

Practical Layout Example

Imagine a monthly sales worksheet with two header rows: the first identifies the reporting period, and the second contains field names. Columns A and B contain a product code and product name; columns C onward contain monthly figures. Selecting C3 and choosing Freeze Panes retains rows 1 and 2 and columns A and B while the figures scroll. The product name remains visible as you move right, and the field names remain visible as you move down.

If the same sheet has a title in row 1, a reporting-period label in row 2, and field names in row 3, select C4 instead to keep all three rows plus columns A and B. The tradeoff is screen space: the larger the frozen block, the less room remains to view data. For a sheet with only one header row and no row labels, A2 is a simpler, less restrictive choice.

Frequently Asked Questions

Can I freeze panes at any selected cell?

You can use most worksheet cells as the boundary reference. Excel freezes all rows above and columns left of the active cell, so choosing a cell far down or right can create a very large frozen area. Choose the first cell in the area you want to scroll, not the last cell you want frozen.

Does Freeze Panes freeze the selected row and column?

No. The selected cell is the upper-left corner of the scrollable area. Rows above it and columns to its left are frozen; its own row and column remain scrollable.

How do I freeze the top two rows?

Select A3, then choose View > Freeze Panes > Freeze Panes. The general command freezes the rows above the active cell, so rows 1 and 2 stay visible.

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

Yes. Select B2 and use the general Freeze Panes command. That freezes row 1 and column A together. If a freeze is already active, unfreeze it first and then set the new boundary.

Will frozen panes appear when I print the worksheet?

Not automatically. Freeze Panes affects on-screen scrolling. To repeat headings on printed pages, use the print-title settings in Excel’s Page Layout controls instead.

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.