Excel Freeze Panes: Stop Freezing Too Many Columns

If Excel freezes too many columns, the freeze boundary is set too far to the right. Choose View > Freeze Panes > Unfreeze Panes, select the cell immediately to the right of the last column you want frozen, then choose View > Freeze Panes > Freeze Panes.

What Freeze Panes Does

Freeze Panes keeps selected worksheet rows and columns visible while you scroll through the rest of a worksheet. It does not lock cells against editing, protect data, or create a separate copy of the information. It changes how the sheet is displayed in the current workbook window.

Excel uses the selected cell to set the boundary. When you choose the general Freeze Panes command, columns to the left of the active cell are frozen, and rows above it are frozen. For example, selecting cell C4 and applying Freeze Panes keeps columns A and B and rows 1 through 3 visible. The selected cell itself is not part of the frozen area.

This boundary-based behavior is why a small selection mistake can produce a surprisingly large frozen area. If you select G1, Excel freezes columns A through F. It does not infer that you only meant to keep a particular label column visible.

Why Excel Freezes More Columns Than Expected

The most common cause is selecting a cell farther right than intended before applying the command. A range selection is not a request to freeze only that range: Excel uses the active cell within the selection to determine the boundary. If the active cell is D1, columns A through C are frozen even if you highlighted a different area first.

Other causes can make the boundary hard to notice:

The active cell is easy to miss. A large worksheet or a selection with several highlighted cells can obscure which cell is active.
Rows and columns are frozen together. Selecting a cell below and to the right of the intended boundary freezes both the rows above and columns to the left.
There is already a freeze setting. Applying a different freeze option can replace the existing arrangement, so the result may not match what you expect from the current view.
Hidden or narrow columns conceal the boundary. Frozen columns still occupy their position in the sheet, even if their width makes them difficult to notice.

Before changing the setting, look at the vertical line separating the frozen columns from the scrolling area. The horizontal line, if present, marks the boundary between frozen rows and scrolling rows. These lines help identify what Excel is keeping in place.

How to Unfreeze and Set the Right Boundary

On Excel for Microsoft 365 for Windows, use the View tab to reset and reapply the freeze. Follow these steps:

Open the View tab.
Choose Freeze Panes, then choose Unfreeze Panes. If the menu offers Freeze Panes instead of Unfreeze Panes, there may not be a frozen area to remove.
Click one cell at the boundary you actually want. To freeze only column A, select B1. To freeze columns A and B, select C1.
Choose View > Freeze Panes > Freeze Panes.
Scroll horizontally and vertically to confirm that the intended columns and rows stay visible.

Unfreezing first is useful because it clears the previous boundary instead of leaving you to guess how a new choice will interact with it. If you want both rows and columns frozen, choose a cell that accounts for both. For example, selecting C2 freezes columns A and B and row 1. Selecting B4 freezes column A and rows 1 through 3.

In Excel for Mac, the Freeze Panes commands are also on the View tab or in the View menu, depending on the version and ribbon layout. The same selection principle applies: remove the current freeze, select the boundary cell, and apply Freeze Panes. Excel for the web also provides freeze controls from the View tab; the labels and exact menu presentation can differ slightly from the Windows desktop app.

How to Choose the Correct Cell

A useful way to choose the cell is to count the rows and columns you want to keep visible, then move one position past each boundary. If you want to freeze the first three columns and the top two rows, select D3. The columns before D are A through C, and the rows before 3 are 1 and 2.

These examples show how the cell translates into a frozen area:

Only column A: select B1, then Freeze Panes.
Columns A through C: select D1, then Freeze Panes.
Only row 1: select A2, then Freeze Panes.
Rows 1 and 2 plus column A: select B3, then Freeze Panes.
Rows 1 through 4 plus columns A and B: select C5, then Freeze Panes.

The important detail is that the cell should be immediately below the last row and immediately to the right of the last column you want frozen. If you intend to freeze columns only, keep the selection in row 1 so that no rows above the active cell are included. If you intend to freeze rows only, keep it in column A.

Using the Preset Freeze Options

Excel provides shortcuts for two common layouts: Freeze Top Row and Freeze First Column. These are convenient when the worksheet has a single header row or when column A contains identifiers you need to see while moving horizontally. Find them under View > Freeze Panes.

These presets are not a way to freeze several columns. For example, Freeze First Column keeps column A visible, not columns A and B. To keep multiple columns visible, use the general Freeze Panes command and select the cell just beyond the desired columns. Likewise, Freeze Top Row freezes row 1; to freeze several heading rows, select a cell in the row immediately below them and use general Freeze Panes.

If you need the top row and first column together, select B2 and apply the general Freeze Panes command. This places the boundary after column A and after row 1. Applying a preset later may change the current frozen arrangement, so check the visible boundary again after using one.

Common Misconceptions and Troubleshooting

Freeze Panes is sometimes confused with Split, another command on the View tab. A split divides the worksheet window into independently scrollable panes. Freeze Panes instead keeps the area above and to the left of a boundary stationary as you scroll the main worksheet area. If the sheet has multiple scrollable sections or unexpected dividing lines, check whether Split is enabled.

It is also easy to mistake freezing for locking. Frozen columns remain editable, and users can still change their contents if the worksheet is not otherwise protected. To restrict editing, worksheet protection is a separate feature; Freeze Panes does not provide access control.

If the wrong columns remain fixed after you try to correct the view, check these points:

Confirm that you chose Unfreeze Panes before setting a new boundary.
Click a single cell, rather than relying on a highlighted range, and verify its column letter and row number.
Make sure the intended frozen columns are actually to the left of the selected cell.
Look for hidden columns or very narrow columns that may make the frozen section appear larger or smaller than it is.
Check whether the worksheet is split, or whether another workbook window has a different view.

A freeze setting affects the worksheet view, not the underlying order of the data. It does not move, delete, or hide columns. If you need to see distant columns side by side, freezing a larger group may not help; resizing columns, hiding unneeded fields, or arranging the data differently may be more suitable.

When Freezing Several Columns Makes Sense

Freezing more than one column can be useful when those columns provide context for the data currently on screen. A wide sales report, for instance, might have employee names in column A, region in B, and monthly figures extending across many columns. Freezing A and B lets a reader track whose figures and which region are visible while scrolling through later months.

By contrast, freezing six columns in a worksheet displayed in a small window can leave little room for the scrolling portion. The frozen area consumes part of the visible worksheet, so readers may have to scroll horizontally even to inspect the data columns they care about. Freeze only the labels or identifiers that are genuinely needed for orientation.

For a table with a single row of headers, Freeze Top Row may be enough. If row labels and column headers both need to stay visible, use a boundary cell that includes both dimensions. The best setting depends on how people read the sheet, not simply on how many columns are present.

Frequently Asked Questions

How do I freeze only the first two columns in Excel?
Choose View > Freeze Panes > Unfreeze Panes, select cell C1, then choose View > Freeze Panes > Freeze Panes. The general command freezes the columns to the left of the selected cell, which are columns A and B in this case.

Why does Freeze Panes freeze columns I did not select?
Excel does not freeze only the highlighted cells. It freezes every column to the left of the active cell and every row above it. Select a cell closer to the left edge, or in row 1 if you want to freeze columns without freezing rows.

Can I freeze columns without freezing rows?
Yes. To freeze columns A and B only, select C1 before using Freeze Panes. Because the selected cell is in row 1, there are no rows above it to freeze.

Can I freeze the top row and multiple columns at once?
Yes. Select a cell one row below the header and one column to the right of the last column you want fixed. For example, select C2 to freeze row 1 and columns A and B.

How do I remove Freeze Panes in Excel?
Go to View > Freeze Panes > Unfreeze Panes. This removes the fixed rows and columns from the current worksheet view; it does not alter the worksheet’s data.

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.