Excel Freeze Panes: How Many Rows Should You Select?

If Excel freezes too many rows, unfreeze the panes and freeze them again from the cell immediately below the last row you want to keep visible. For example, to freeze rows 1 through 3 only, click cell A4, then choose View > Freeze Panes > Freeze Panes; Excel freezes rows above the active cell, not a number of rows you enter.

What “too many rows” means in Excel

Freeze Panes is useful when a worksheet has headings or labels that should remain visible as you scroll. The frozen area stays on screen while the rest of the sheet moves. If that area includes more rows than you intended, it can take up valuable screen space and leave less room to read the data. A typical example is wanting to keep one header row visible but accidentally freezing the first eight rows, including several ordinary records.

Excel does not ask how many rows to freeze in a dialog box. Instead, it uses the position of the active cell when you apply the Freeze Panes command. Rows above that cell are frozen. If the active cell is in row 9, rows 1 through 8 are included, even if you only meant to keep a single heading visible. This is why clicking a cell deliberately is more reliable than selecting a block of row headings.

Having many rows frozen is not necessarily an error. A worksheet with several lines of title, notes, and column headings may need a deeper frozen area. The issue is whether the frozen rows contain information that is genuinely useful to keep in view and whether they leave enough room to work.

How Freeze Panes decides what to keep visible

Excel divides the worksheet at the active cell. When you choose View > Freeze Panes > Freeze Panes, it keeps the rows above the active cell and the columns to its left stationary. The active cell itself and the cells below and to its right remain in the scrollable area. For instance, clicking D4 freezes rows 1 through 3 and columns A through C.

This row-and-column behavior can cause a surprise if you click too far to the right. If you want to freeze only rows, click a cell in column A. If you want to freeze only columns, click a cell in row 1. If you want both, choose a cell that is below the rows and to the right of the columns you intend to hold in place.

To freeze the first three rows only, click A4.
To freeze the first two columns only, click C1.
To freeze the first three rows and first two columns, click C4.

The two named shortcuts in the menu, Freeze Top Row and Freeze First Column, are special cases. They freeze row 1 or column A, respectively. Use the general Freeze Panes command when you need a different number or a combination of rows and columns.

Choose the right row before freezing

Start by deciding which information must remain visible while someone reads or edits the rest of the sheet. In a simple sales table, that is often the row containing field names such as Date, Region, and Amount. If those labels are in row 1, freezing the top row is usually enough. If a report has a title in row 1, a blank row in row 2, and column headings in row 3, freezing through row 3 may make more sense.

Find the last row that belongs in the stationary area, then choose the cell directly underneath it in column A if you do not want to freeze any columns. The “directly underneath” rule avoids off-by-one mistakes: the row of the selected cell is not frozen by the general Freeze Panes command. To keep rows 1 to 3 visible, select A4, not A3.

Before applying the setting, look at the row numbers and the worksheet layout. Hidden or unusually tall rows can make the frozen area appear larger than expected. A title row with wrapped text, for example, may occupy much more vertical space than an ordinary row. Consider whether that title needs to stay visible along with the column labels, or whether freezing only the labels would be more practical.

Freeze the intended rows in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, use these steps to set a precise boundary:

If panes are already frozen, go to View > Freeze Panes > Unfreeze Panes.
Click the cell in column A immediately below the last row you want frozen. For rows 1 through 3, click A4.
Choose View > Freeze Panes > Freeze Panes.
Scroll down to check that the intended rows stay in place and that the data below them moves.

On Excel for Mac, the same cell-position principle applies. Use the View tab and its Freeze Panes controls; menu and ribbon presentation can vary slightly by release. Excel for the web also offers Freeze Panes controls on the View tab, although the available interface can differ from desktop Excel. In each case, check the active cell before applying the general Freeze Panes command.

To freeze only row 1 without choosing a cell boundary yourself, use View > Freeze Panes > Freeze Top Row. To keep column A visible as you scroll horizontally, use View > Freeze Panes > Freeze First Column. These options do not mean “freeze the row or column currently selected”; they target the top row and first column specifically.

Remove an oversized frozen area

Excel does not provide a direct command to reduce an existing frozen area by one row. First remove the current freeze, then apply a new one at the correct boundary. Choose View > Freeze Panes > Unfreeze Panes, click the appropriate cell, and select Freeze Panes again. If you need only the first row, you can instead choose Freeze Top Row after unfreezing.

Unfreezing does not delete, move, or alter worksheet data. It changes how the sheet scrolls. It also does not clear filters, remove headings, or change row heights. After resetting the panes, scroll vertically and horizontally to confirm the result. If the sheet still seems crowded, inspect whether the frozen rows themselves are tall or whether another display feature, such as a split window, is active.

When you are unsure where the boundary should be, write down the last row you want to retain before unfreezing. For example, if the header occupies row 5 and rows 1 to 4 are report titles or notes, decide whether all five rows are necessary. If only the field names in row 5 matter, click A6 after unfreezing. If rows 1 to 5 all provide useful context, A6 is still the correct cell, because the rows above it are what Excel freezes.

Common reasons Excel freezes more than expected

The active cell is lower than intended. Clicking A8 freezes rows 1 through 7. To freeze only the first three, unfreeze and use A4.
You clicked to the right of column A. A cell such as C4 freezes both rows above it and columns to its left. Use A4 when the goal is rows only.
You used Freeze Top Row by mistake. That command always targets row 1. It will not freeze a heading located farther down the worksheet.
There are already frozen panes. Applying a new boundary without first choosing Unfreeze Panes may not produce the reset you expect. Clear the old setting first.
A split is being mistaken for a freeze. Split divides the worksheet into independently scrollable sections. Freeze Panes keeps a defined top or side area fixed while the remaining sheet scrolls.

Also distinguish a frozen row from a hidden row. Freezing keeps a row visible while other rows scroll; hiding removes it from view until it is unhidden. If a row number is missing or the sheet jumps over a row, check for hidden rows rather than assuming the freeze boundary is wrong.

Freeze Panes, Freeze Top Row, and Split

Freeze Panes is the flexible option: the active cell defines the horizontal and vertical boundaries, so it can hold several heading rows and, if needed, columns at the left. Freeze Top Row is faster when row 1 alone should remain visible. Freeze First Column is the equivalent for column A. These preset commands do not freeze a custom group of rows or columns.

Split serves a different purpose. It creates separate worksheet areas that can be scrolled independently, rather than keeping one top section fixed in the usual freeze-pane arrangement. If you see a divider and can scroll separate sections, check the Split control on the View tab. Turn off the split before setting a freeze if the divided view is not what you want.

For a wide table with many fields, freezing the heading row and a key identifier column can help keep both labels and record names visible. For a short, narrow worksheet, that may be unnecessary and can reduce the visible working area. The best setting depends on how the sheet is read, not on a universal recommended number of rows.

Practical limits and worksheet considerations

Freeze Panes changes the view, not the structure of a table or the contents of cells. It does not make headings repeat on printed pages; printing has separate page setup options, including repeating rows at the top of each printed page. It also does not lock cells against editing. Worksheet protection and frozen panes solve different problems.

A large frozen block can be technically valid but awkward on a laptop or in a small window. Leave enough visible area for the scrollable part of the sheet, especially if people need to compare many records. If a workbook is shared, consider whether the frozen region makes sense at the window sizes other users may use. The view can be saved with the workbook, but another person may adjust it while working.

For structured data, keeping one clear header row at the top of the table often makes navigation simpler. If the sheet includes lengthy explanatory text, consider placing that material elsewhere or using a concise heading area rather than freezing a large block. The goal is to keep the context needed to interpret the data without obscuring the data itself.

Frequently Asked Questions

How do I freeze only the first three rows in Excel?
Unfreeze any existing panes, click cell A4, then choose View > Freeze Panes > Freeze Panes. Rows 1 through 3 remain visible as you scroll.

Why does Excel freeze rows above the cell I selected?
That is how the general Freeze Panes command works: it freezes rows above the active cell and columns to its left. The selected cell marks the boundary; it is not itself included in the frozen area.

Can I freeze rows without freezing columns?
Yes. Click the boundary cell in column A. For example, A4 freezes rows 1 through 3 without freezing any columns to the left.

How do I change the number of frozen rows?
Choose View > Freeze Panes > Unfreeze Panes, then select a cell immediately below the new last frozen row and apply Freeze Panes again.

Does Freeze Top Row freeze the row I have selected?
No. Freeze Top Row targets worksheet row 1 regardless of the active cell. Use the general Freeze Panes command for a header located lower down.

Why is the frozen area still too large after I change it?
Check that you first chose Unfreeze Panes and then clicked the correct boundary cell. Also check for tall rows or a Split view, which can make the worksheet look as though more area is fixed than expected.

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.