Freeze 2 Panes in Excel: What Works and What Doesn’t

Freeze 2 Panes in Excel: What Works and What Doesn't

To freeze two parts of a worksheet at once in Excel, 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. For example, select C2 to keep row 1 and column A visible while you scroll; select C3 to keep the top two rows and first two columns visible.

What Freeze Panes Does

Freeze Panes keeps selected rows at the top of the worksheet and selected columns on the left while you scroll through the rest of the sheet. It is useful when a list is too large to fit on screen and you need to keep its headings, identifiers, or both in view. The frozen area stays in place on screen; the rest of the worksheet can scroll independently beneath or beside it.

Excel does not treat this as choosing any two unrelated panes. Instead, it freezes a continuous block that starts at the worksheet’s top-left corner. The dividing line is determined by the active cell when you apply the command:

Rows above the selected cell are frozen.
Columns to the left of the selected cell are frozen.
The selected cell and the cells below and to its right remain in the scrolling area.

That means you can freeze rows and columns together, but you cannot freeze a row near the bottom of the sheet while leaving the rows above it free to scroll. Nor can you freeze only column A and column C while leaving column B unfrozen. The frozen rows and columns must form one connected block at the top and left.

How to Freeze Rows and Columns Together

In Excel for Microsoft 365 on Windows, use these steps to freeze a combination of rows and columns:

Open the worksheet you want to work with. Freeze settings apply to the active worksheet, so select the correct sheet tab first.
Click the cell immediately below the last row you want frozen and immediately to the right of the last column you want frozen.
Choose View > Freeze Panes > Freeze Panes. Be sure to choose the first Freeze Panes command, not Freeze Top Row or Freeze First Column.
Scroll down or to the right to confirm that the intended rows and columns remain visible.

For instance, if a report has two header rows and you want its first two columns—perhaps an ID and a customer name—to remain visible, select C3 before applying the command. Rows 1 and 2 are above C3, and columns A and B are to its left, so all four remain fixed. The cell you select is not itself frozen; it marks the upper-left corner of the scrolling area.

On Windows, Excel’s ribbon KeyTips can also open the command: press Alt, then W, F, and F in sequence. KeyTips can vary with ribbon configuration or Excel version, so use the View tab if that sequence does not match what appears on your screen. On a Mac, use the View tab and its Freeze Panes menu; there is no need to rely on a Windows Alt-key sequence. Excel for the web also provides Freeze Panes on the View tab, though the available ribbon layout can differ slightly.

Choosing the Right Cell: Practical Examples

The easiest way to decide what to select is to count the rows and columns you want to keep visible, then move one cell down and one cell right from that frozen block. Here are common setups:

Keep only the first row: Choose View > Freeze Panes > Freeze Top Row. Alternatively, select A2 and choose Freeze Panes.
Keep only the first column: Choose View > Freeze Panes > Freeze First Column. Alternatively, select B1 and choose Freeze Panes.
Keep the first row and first column: Select B2 and choose Freeze Panes.
Keep the top three rows and first column: Select B4 and choose Freeze Panes.
Keep the first two rows and first four columns: Select E3 and choose Freeze Panes.

The named commands for the top row and first column are quick options for those individual cases. If you need a combination, use the cell-selection method and the general Freeze Panes command. Selecting a cell too far down or too far to the right freezes more of the sheet than intended, so check its row number and column letter before applying the setting.

Can You Freeze Two Separate Rows or Columns?

A common meaning of “freeze 2 panes” is to keep two separate areas fixed—for example, row 1 and row 5, or columns A and D. Freeze Panes cannot do that. It freezes a contiguous section from the top edge, the left edge, or both. To keep row 5 visible, you must also freeze rows 1 through 4; to keep column D fixed, columns A through C must be fixed too.

If the goal is to keep two pieces of information visible, consider changing the worksheet layout so they are together in a row or column that can be frozen. You could also repeat key labels in the data, use a filter or table to make records easier to identify, or create a separate summary view. Those approaches do not create extra frozen areas, but they may solve the underlying navigation problem without locking a large block of the sheet.

How to Change or Remove Frozen Panes

You cannot adjust the boundary by dragging it after freezing. To change which rows or columns stay visible, first remove the current setting, then apply a new one:

Choose View > Freeze Panes > Unfreeze Panes.
Select the cell that defines the new boundary. For example, select D2 to freeze row 1 and columns A through C.
Choose View > Freeze Panes > Freeze Panes.

Unfreezing changes the worksheet’s scrolling view; it does not delete data, alter formulas, or remove rows and columns. The option shown in the menu changes with the current state: when panes are frozen, Unfreeze Panes is available. On Windows, the ribbon KeyTips sequence for unfreezing is commonly Alt, W, F, P, pressed in order; use the ribbon if your KeyTips differ. On a Mac or in Excel for the web, use the View tab’s menu.

Common Problems and Fixes

If Excel seems to freeze the wrong rows or columns, the selected cell is the first thing to check. For example, selecting C3 freezes the first two rows and first two columns—not the first two rows and three columns. The selected cell’s row and column are the boundaries: everything strictly above and to the left is frozen.

The top row is frozen, but a column is not: A previous Freeze Top Row command may be active. Choose Unfreeze Panes, select the correct boundary cell, and apply Freeze Panes once for the combination.
Freeze Panes is unavailable or behaves unexpectedly: Check whether the worksheet is in a view or state that limits the command, and make sure you are working in the intended worksheet window. If the sheet is protected or shared in a particular way, available editing actions may also be restricted.
The dividing line appears in the wrong place: Unfreeze, select a cell at the correct boundary, and apply the command again. You cannot fix the boundary by dragging the line.
Only part of a long heading stays visible: Excel freezes whole rows and columns, not a portion of a row or a cell. Adjust the layout or row height if the heading itself is split or clipped.

Also check whether the worksheet is split rather than frozen. A split creates separate scrolling areas and may show movable divider bars. Freeze Panes instead keeps the designated top and left sections fixed as the remaining area scrolls. The two features can look similar at first, but their controls and behavior are different.

Freeze Panes Compared with Split

Use Freeze Panes when headings or identification columns should remain fixed while you browse one large worksheet. For example, a monthly sales sheet could keep its column labels and the salesperson names visible as you move through many records. It is designed for a stable reference area, not for viewing two arbitrary portions of a sheet at once.

Use View > Split when you want separate worksheet areas that can be scrolled independently. A split is more flexible for comparing distant sections, but it does not mean that those areas are frozen in the same way. To return to one ordinary scrolling area, use View > Split again or remove the split using the available control in your Excel version. If your aim is simply to keep headings visible, Freeze Panes is usually the more direct choice.

Where the Setting Applies

Freeze Panes is a viewing aid for the active worksheet. It does not change the workbook’s data, and it does not lock cells against editing. It also does not freeze the same rows and columns across every sheet automatically: configure each worksheet where you need the behavior. When another person opens the workbook, the saved worksheet view may be useful to them, but they can change their own view by unfreezing or resetting the panes.

On Excel for Mac and Excel for the web, the central idea is the same: select the boundary cell and use the Freeze Panes command on the View tab. The precise ribbon arrangement can differ from Windows, and some web features may be presented in a more compact interface. If the command is not where expected, look under View rather than trying to use the Windows KeyTips sequence.

Frequently Asked Questions

Can I freeze two rows and two columns at the same time?
Yes. Select C3, then choose View > Freeze Panes > Freeze Panes. This freezes rows 1 and 2 and columns A and B.

Why does Freeze Top Row undo my frozen column?
The named options set a single preset view; applying one after another replaces the earlier freeze configuration. Unfreeze Panes, select a boundary cell such as B2, and use the general Freeze Panes command to freeze the top row and first column together.

Can I freeze the first and third columns but not the second?
No. Excel freezes a continuous block from the left edge, so freezing column C also freezes columns A and B. Consider rearranging the data or adding a separate summary area if both columns must stay visible without the middle column.

How do I freeze more than one row?
Select the cell in the row immediately below the last row you want to keep visible, then choose View > Freeze Panes > Freeze Panes. To freeze rows 1 through 4, select a cell in row 5; the column you choose determines whether any columns are frozen too.

Does Freeze Panes protect cells from changes?
No. It only controls what stays visible while scrolling. To restrict editing, use worksheet protection or another appropriate permission setting; freezing panes alone does not prevent a user from changing 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.