Excel Freeze Panes in the Middle of a Sheet: How It Works

Yes. In Excel for Microsoft 365 on Windows, select the cell immediately below and to the right of the rows and columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, select C5 to keep rows 1–4 and columns A–B on screen while you scroll through the rest of the sheet.

What Freeze Panes Does

Freeze Panes keeps specified rows at the top of the worksheet and specified columns at the left while the unfrozen part of the sheet scrolls. The setting is based on the active cell when you apply it: Excel freezes the rows above that cell and the columns to its left. The frozen area stays in place as you move through the worksheet, so labels or identifiers remain available for comparison with distant data.

This means you can set the boundary well below the first row or well to the right of column A. In everyday terms, you can freeze panes “in the middle” of a sheet. But Excel does not pin any arbitrary block of cells wherever it happens to sit: the frozen rows must start at the top of the worksheet, and the frozen columns must start at the left edge. The selected cell defines the lower-right corner of the frozen area.

How to Freeze Panes from a Cell in the Middle

Use these steps in the desktop version of Excel for Microsoft 365 on Windows:

Open the worksheet and scroll to the area where you want the frozen boundary. Scrolling to a location does not itself set the boundary.
Select the cell immediately below the last row and immediately to the right of the last column you want frozen.
Choose View > Freeze Panes > Freeze Panes.
Scroll down or across to confirm that the intended rows and columns remain visible.

For example, if rows 1–4 contain a title, instructions, column headings, and a second header line, and columns A–B contain an ID and a customer name, select C5 before choosing Freeze Panes. Excel keeps rows 1–4 and columns A–B in view. Cell C5 is not frozen; it is the first cell in the scrolling area.

To change the boundary, first choose View > Freeze Panes > Unfreeze Panes. Select a new anchor cell and apply Freeze Panes again. Excel does not add a second independent freeze boundary on top of an existing one; unfreeze the current arrangement before creating a different one.

Choosing the Correct Cell

The most common mistake is selecting the row or column you want to freeze instead of the cell after it. Think of the selected cell as the first cell that should remain scrollable, not as part of the frozen selection.

To freeze rows 1–4 only, select A5. There are no columns to the left of column A, so no columns are frozen.
To freeze columns A–B only, select C1. There are no rows above row 1, so no rows are frozen.
To freeze row 1 and column A, select B2.
To freeze rows 1–4 and columns A–B, select C5.

Before applying the command, count the rows and columns you want held in place, then move one row down and one column right to find the anchor. This simple check helps prevent freezing one extra row or column. If the result is wrong, use Unfreeze Panes and repeat with the corrected cell.

Using the Built-In Top Row and First Column Options

The Freeze Panes menu also includes shortcuts for common layouts: Freeze Top Row and Freeze First Column. These commands are useful when the only heading is in row 1 or the only identifier is in column A. They are not substitutes for selecting an anchor when you need to freeze several rows or columns, such as rows 1–4 and columns A–B.

These preset commands target the worksheet’s top row or first column; they do not freeze whichever row or column happens to be visible in the middle of the screen. For example, scrolling to row 20 and choosing Freeze Top Row still freezes row 1, not row 20. To keep rows 1–19 visible, select a cell in row 20 and use the general Freeze Panes command—but consider whether keeping that many rows fixed will leave enough room to work.

What You Can and Cannot Freeze

Freeze Panes supports a single frozen section along the top and left edges. You can combine frozen rows and columns, but each frozen part is contiguous from the edge of the worksheet. You cannot freeze row 1 and row 10 while allowing rows 2–9 to scroll, nor can you freeze columns A and D while columns B–C scroll independently. Excel’s freeze feature is not a way to pin scattered ranges.

There is also a practical screen-space limit. If you freeze many rows or columns, the scrolling region becomes small or may be difficult to use, especially on a laptop display. A large frozen block can make the sheet feel stuck even when the setting is technically working. Keep only the headings and identifiers that are genuinely useful for interpreting the visible data, and unfreeze or choose a smaller boundary when the layout becomes cramped.

Freeze Panes changes how the worksheet is displayed; it does not rearrange, copy, or protect the underlying data. It does not make headings repeat when you print. If your goal is to repeat selected rows at the top of printed pages, use Page Layout > Print Titles and set the rows to repeat there. That print setting is separate from the on-screen freeze setting.

Freeze Panes Compared with Split

Freeze Panes and Split can both divide the worksheet view, but they solve different problems. Freeze Panes keeps a top section, a left section, or both fixed while the rest of the sheet scrolls. It is usually the better choice when you need headers or row identifiers to stay visible while reviewing a long list.

Split divides the worksheet window into separate panes that can be scrolled to different parts of the sheet. It is useful when you want to compare distant areas, such as a summary near the top with detailed rows farther down. Unlike a frozen header, a split pane is not simply a permanent set of top rows or left columns attached to the scrolling area; each pane provides another view of the worksheet. In Excel for Windows, find the command at View > Split. Choose View > Split again to remove the split. If you only need the headings to stay in place, use Freeze Panes instead.

Common Problems and How to Fix Them

If the wrong rows or columns stay visible, the anchor cell was likely one row or one column away from the intended boundary. Unfreeze, select the cell directly below and to the right of the desired frozen area, and apply the command again. Remember that Excel freezes everything above and to the left of the selected cell, not the cell itself.

If Freeze Panes appears unavailable or the view behaves unexpectedly, check the following:

An existing freeze is active: Choose View > Freeze Panes > Unfreeze Panes, then make a new selection.
You are in a different worksheet view: Return to Normal view if the current view is making the worksheet difficult to navigate, then review the View tab’s options.
You are using Split: Remove the split if you want a standard frozen-pane layout, then set Freeze Panes from the intended anchor cell.
The frozen block uses too much space: Unfreeze and select a nearer boundary so more of the scrolling area is visible.

A heavy line at the boundary between fixed and scrolling cells is a visual cue that panes are frozen. Scroll vertically and horizontally to test both directions: a layout may correctly freeze rows but not the columns you expected, or vice versa.

Excel for Mac and Excel for the Web

In Excel for Mac, the same basic rule applies: select the cell below and to the right of the area to keep visible, then use View > Freeze Panes. The exact menu presentation can vary slightly by Excel release, but look for Freeze Panes, Freeze Top Row, Freeze First Column, and Unfreeze Panes in the View controls. The cell-selection logic is the same as in Windows.

Excel for the web also offers freeze controls on the View tab. Select the appropriate cell before choosing the freeze command, and check the resulting boundary by scrolling. Some interface details and available controls can differ between the browser and desktop app, so if a command is not visible, check the View tab or open the workbook in the desktop version. Freezing panes is a view setting; it does not alter the worksheet’s cell values.

Frequently Asked Questions

Can I freeze rows that are not at the top of the sheet?
Not as an isolated set. Freeze Panes always holds rows starting at row 1, so selecting a cell in row 11 freezes rows 1–10. To keep only a later section visible while another section scrolls, consider Split instead.

Can I freeze columns and rows at the same time?
Yes. Select the cell below the last row and to the right of the last column to freeze, then choose View > Freeze Panes > Freeze Panes. Selecting C5, for example, freezes rows 1–4 and columns A–B.

Why does Excel freeze more than I wanted?
Excel freezes all rows above and columns to the left of the active cell. If you selected C5, rows 1–4 and columns A–B are frozen. Unfreeze the panes, then select a cell closer to the top-left corner for a smaller frozen area.

Can I freeze a row in the middle but let the rows above it scroll?
No. Freeze Panes cannot hold a middle row independently while earlier rows move. Its row section always begins at the top of the worksheet. Split may help you compare different vertical positions, but it does not turn a middle row into a conventional frozen header.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current frozen arrangement; it does not delete or change any worksheet data. You can then select another anchor cell and freeze a different set of rows or columns.

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.