Excel Freeze Panes Freezes Too Many Rows? Here’s the Fix

Excel Freeze Panes Freezes Too Many Rows? Here's the Fix

Excel Freeze Panes freezes too many rows when the active cell was below the row you meant to keep fixed: Excel freezes every row above that cell, as well as every column to its left. To reset it, choose View > Freeze Panes > Unfreeze Panes, select the cell directly below the rows you want to keep visible—usually A2 to freeze only row 1—and choose View > Freeze Panes > Freeze Panes.

How Freeze Panes decides what stays fixed

Freeze Panes is based on the active cell when you apply the command. Excel draws a boundary above that cell’s row and to the left of its column. Rows above the boundary stay visible while you scroll down; columns to its left stay visible while you scroll horizontally. Excel does not ask how many rows you want to freeze, so selecting the wrong cell can make the result look unexpectedly large.

For example, if A5 is active, applying Freeze Panes fixes rows 1 through 4. If C5 is active, it fixes rows 1 through 4 and columns A and B. The selected cell itself is not frozen as a special extra row or column; it marks the top-left corner of the scrollable area. This is why a selection several rows below your headings can freeze all the rows above it, even if you intended to keep only the header visible.

The Freeze Panes command creates one frozen area at the top and/or left of the worksheet. It is not a way to pin several separate rows scattered through the sheet. The rows and columns that remain fixed are contiguous from the worksheet’s top and left edges.

Choose the right cell for the rows you need

Before applying Freeze Panes, decide which rows should remain visible and count from the top of the worksheet. To freeze the first n rows, select a cell in row n+1. To freeze the first n columns, select a cell in column n+1. If you need both, the selected cell must be below the rows and to the right of the columns you want to retain.

Keep only row 1 visible: select A2 and choose View > Freeze Panes > Freeze Panes, or choose Freeze Top Row.
Keep rows 1 through 3 visible: select A4 and choose Freeze Panes.
Keep columns A and B visible: select C1 and choose Freeze Panes.
Keep rows 1 through 2 and columns A and B visible: select C3 and choose Freeze Panes.

Freeze Top Row is a convenient shortcut when the worksheet’s first row contains the headings you need. It always freezes worksheet row 1; it does not mean the first row currently visible after scrolling, filtering, or hiding rows. Similarly, Freeze First Column fixes worksheet column A. If the headings begin lower down, or your labels are in another column, use Freeze Panes with the appropriate cell instead.

Remove the current freeze before correcting it

Excel does not usually let you adjust an existing freeze boundary by dragging it into a new position. The reliable fix is to remove the current setting and create a new one:

Open the worksheet where the unwanted frozen rows appear. Freeze settings apply to individual worksheets, so changing one sheet does not automatically change the others.
Go to View > Freeze Panes > Unfreeze Panes. If the menu offers Unfreeze Panes, a freeze is currently active.
Click the cell that marks the correct boundary. For just the top row, choose A2; for the top three rows, choose A4.
Choose View > Freeze Panes > Freeze Panes. Check the boundary and scroll to confirm the result.

Unfreezing does not delete, move, or edit cell contents. It only changes how the worksheet behaves when you scroll. If you cannot find the command, make sure you are on the View tab and that the worksheet is active rather than editing a cell. On a narrow ribbon, some commands may be grouped or hidden in a menu, but the feature remains under View.

Check the boundary and the selected cell

After applying the command, look for the boundary line that separates the frozen area from the scrolling area. A horizontal boundary below row 4, for instance, indicates that rows above it are being kept in place. A vertical boundary after column B indicates that columns A and B are fixed. The line can be subtle, so scroll down or sideways as a practical check: the frozen section should remain in view while the rest of the sheet moves.

A common slip is clicking a cell after scrolling and assuming Excel will interpret it as a visible position in the layout. The command uses the selected cell’s worksheet row and column, not the number of rows currently on screen. For example, if you scroll down to row 20, click A20, and then apply Freeze Panes, Excel can freeze rows 1 through 19. That may look like an enormous frozen block or leave very little room to scroll. Return to the top-left area, select the intended boundary cell, and apply the command again.

Also check that the correct worksheet is active. A workbook can have different freeze settings on different tabs, and clicking a neighboring sheet to inspect it will not change the original sheet’s view. If the settings seem inconsistent, repeat the unfreeze-and-apply steps on the exact worksheet where the problem occurs.

Other reasons scrolling can seem stuck

Too many frozen rows are not the only reason a worksheet may appear to stop scrolling. A freeze may be combined with hidden rows, an active filter, grouped rows, or a split window. These features affect what you can see in different ways, so clearing Freeze Panes alone may not resolve every symptom.

Hidden rows: If rows between the headings and the visible data are hidden, the frozen area may seem to skip rows. Check the row numbers along the left edge and unhide rows if appropriate.
Filtered data: A filter can hide records that do not match the current criteria. Clear or change the filter if expected records are missing; this is separate from freezing.
Grouped rows: Outline controls can collapse detail rows. Expand the group if you need to see them.
Split panes: Split divides the window into separate scrolling sections. It is different from freezing and can make scrolling feel unusual. Check View for the Split command and turn the split off if it is active and unwanted.

Frozen panes do not remove content, protect cells, or prevent edits. They only keep chosen rows or columns on screen during scrolling. If you can select and edit a frozen cell, that is normal; use worksheet protection or other controls if your goal is to prevent changes.

Freeze Panes versus Freeze Top Row and Split

These commands solve related but different problems. Freeze Panes lets you choose a boundary for both rows and columns. Freeze Top Row is a shortcut for keeping worksheet row 1 visible, while Freeze First Column keeps column A visible. Use those shortcuts when their fixed position matches your layout. If you need several header rows, a non-first label column, or both rows and columns, select the boundary cell and use Freeze Panes.

Split, by contrast, divides the worksheet window into separate panes that can scroll independently. It can be useful when comparing distant parts of a large sheet, but it is not the usual way to keep headings in place while browsing data. If the screen has multiple scrolling sections rather than one fixed header area and one scrolling body, check whether Split is active.

Excel on Mac and in a web browser

In Excel for Microsoft 365 on Windows, use the View tab and its Freeze Panes menu. The basic selection rule is the same across desktop versions: the active cell determines which rows above it and columns to its left are frozen. Excel for Mac also provides freeze commands on the View tab; the names and ribbon layout can vary slightly by release, but choose Unfreeze Panes first and then select the intended boundary cell before applying Freeze Panes again.

Excel for the web also includes freeze options on the View tab. If you do not see the same ribbon layout as the Windows desktop app, look for Freeze Panes in the web version’s View controls. The underlying rule remains the important part: select a cell below and to the right of the area to keep visible. If a workbook opens with a freeze setting created elsewhere, that setting can still affect scrolling in the browser; reset it on the worksheet if needed.

Practical choices for large worksheets

Freeze only the information that helps you interpret the rows you are reading. A long block of frozen rows reduces the space available for the scrolling data, particularly on a laptop display or when the ribbon and formula bar are expanded. If you freeze four rows but only need the column headings, the worksheet may feel cramped even though the command is working correctly.

Before choosing a boundary, consider what you need to compare while scrolling:

For a simple list, keep the heading row visible so column names remain clear.
For a report with a title, a date range, and a separate header row, freeze through the row that contains the labels you need—but avoid retaining extra notes or blank rows unless they are useful.
For a wide table with identifying names in column A, freeze that column as well as the header row by selecting B2 before applying Freeze Panes.

If the frozen area leaves too little room to work, unfreeze and choose a smaller area. You can also adjust zoom or hide irrelevant columns, but those steps do not change which rows are frozen. For shared workbooks, remember that freeze panes are a viewing convenience, not a guarantee that every reader will have the same screen size or preferred layout.

Frequently Asked Questions

How do I freeze only the first row in Excel?
Choose View > Freeze Panes > Freeze Top Row. Alternatively, select A2 and choose Freeze Panes. Both approaches keep worksheet row 1 visible as you scroll down.

Why does Excel freeze rows above the one I selected?
The selected cell is the boundary marker, not the first row to freeze. Excel freezes all rows above that cell. To freeze only rows 1 through 3, select a cell in row 4 before applying Freeze Panes.

Can I drag the Freeze Panes line to change it?
No. To change the boundary, choose View > Freeze Panes > Unfreeze Panes, select the new boundary cell, and apply Freeze Panes again.

Why is Unfreeze Panes missing from the menu?
If Unfreeze Panes is not available, the current worksheet may not have frozen panes. Check for Split or hidden rows if scrolling still seems restricted, and make sure you are inspecting the worksheet where the issue occurs.

Can I freeze a header row that is not row 1?
Yes. Select the cell directly below the last row you want fixed, then choose Freeze Panes. For example, select A6 to keep rows 1 through 5 visible. Excel freezes all rows above the selected row, including any blank rows in that range.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.