Multiple Freeze Panes in Excel: What You Can and Can’t Do

Multiple Freeze Panes in Excel: What You Can and Can't Do

You can freeze multiple rows and columns in Excel at the same time, but you cannot create several separate Freeze Panes areas on one worksheet. Select a cell below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Excel holds the rows above and columns to the left in place as you scroll.

What “multiple freeze panes” can mean

The phrase can describe two different things. If you mean keeping more than one row or column visible, yes: a single Freeze Panes setup can lock several adjacent rows, several adjacent columns, or both together. For example, you can keep a three-row heading and the first two columns visible at the same time.

If you mean making several separate frozen blocks in different parts of a worksheet, no. Excel provides one Freeze Panes configuration per worksheet. It always holds the rows at the top and columns on the left of the scrolling area; it cannot freeze a row near the bottom, a middle column while allowing columns to its left to scroll, or several nonadjacent regions. Each worksheet can have its own freeze setting, however, so different sheets in the same workbook can use different arrangements.

This distinction matters in large workbooks. The feature is designed to keep the labels that orient you—such as column headings, dates, or customer names—visible while you inspect the rest of the sheet, not to pin arbitrary cells wherever they happen to be.

How to freeze rows and columns together

To freeze both rows and columns, select the cell immediately below the last row and immediately to the right of the last column you want to keep visible. The selected cell itself remains in the scrolling area. In Excel for Microsoft 365 on Windows, follow these steps:

Open the worksheet and decide which top rows and left columns should stay on screen.
Select the cell at the boundary between the frozen area and the area you want to scroll. To freeze rows 1 through 3 and columns A and B, select C4.
Choose View > Freeze Panes > Freeze Panes.
Scroll down and right to check that the headings and identifying columns remain visible.

Excel freezes every row above the selected cell and every column to its left. So selecting C4 freezes rows 1–3 and columns A–B. Selecting B2 freezes only row 1 and column A. The rule is based on the selected cell’s position, not on the cells you have highlighted or the active data range.

To change the arrangement, first choose View > Freeze Panes > Unfreeze Panes. Then select a new boundary cell and apply Freeze Panes again. You cannot add another independent freeze area to the existing one; replace the setup instead.

Choosing the right boundary cell

Before freezing, look at the sheet’s layout and identify what readers need for context. In a sales table, for example, the first row might contain field names and column A might contain product names. Selecting B2 freezes both. If the table has two heading rows and the first two columns contain a region and a product, select C3 to hold those rows and columns visible.

Be deliberate about how much you lock. A large frozen area leaves less room for scrolling data, especially on a laptop display or when Excel’s ribbon and formula bar are open. Freeze only the rows and columns that provide useful labels. If a heading takes up several rows because of merged cells or a title banner, consider whether all of those rows really need to remain on screen.

Excel also offers two convenient presets under View > Freeze Panes: Freeze Top Row and Freeze First Column. These are useful when the only requirement is to keep row 1 or column A visible. They are not cumulative shortcuts: choosing Freeze Top Row and then Freeze First Column does not create a combined freeze. To freeze both, unfreeze the current setting, select B2, and choose Freeze Panes.

What Excel panes do while you scroll

A frozen row or column stays visible while the unfrozen part of the worksheet moves. When you freeze rows and columns together, Excel divides the view at the selected boundary. The top section continues to show the frozen rows, the left section continues to show the frozen columns, and the main area scrolls through the remaining cells.

Freeze Panes changes how the worksheet is displayed; it does not reorganize the data, create a new table, or prevent edits to frozen cells. You can still select and edit a frozen cell. The boundary is a viewing aid, not a protection setting. To restrict editing, you would need worksheet protection or another appropriate workbook control.

Freezing also does not make headings repeat on printed pages. The on-screen view and the printed layout are separate features. A worksheet may have frozen headings for scrolling but still print without repeating them on each page unless you set print titles.

When Split is a better fit

If you want to compare different parts of the same worksheet, Excel’s Split command may suit you better than Freeze Panes. Split divides the worksheet window into independently scrollable sections. Depending on where you place the split, you can view two sections or divide the window into as many as four areas. For instance, you might keep one section near the top of a long list while scrolling another section farther down.

To use it in Excel for Microsoft 365 on Windows, select a cell where you want the split to start and choose View > Split. The split bars separate the areas, and you can adjust their positions. Choose View > Split again to remove the split. Split is useful for comparing distant rows or columns, but it is not a way to freeze several disconnected regions. Excel does not let you use Freeze Panes and Split as simultaneous view modes on the same worksheet.

The practical choice is straightforward: use Freeze Panes when labels should remain fixed while one main area scrolls; use Split when you need to look at different parts of a sheet at once. A split can make a worksheet feel crowded, so close it when the comparison is finished.

Other ways to keep headings useful

Not every workbook needs frozen panes. If you want headings to appear at the top of every printed page, use print titles instead. In Excel for Windows, open Page Layout > Print Titles. On the Sheet tab of Page Setup, specify rows to repeat at top or columns to repeat at left, then check the result in Print Preview. Print titles affect printed pages; they do not keep headings visible as you scroll on screen.

Excel tables offer another helpful option. When a range is formatted as a table, its header labels can appear in place of the worksheet column letters as you scroll within the table. Tables also support sorting and filtering from their header row. This is not the same as freezing a row: it works in the context of the table and does not keep arbitrary title rows or left-side identifier columns fixed.

For a wide dataset, you might also rearrange columns so the most important identifiers sit on the left, or create a summary sheet with the key fields together. Hiding or grouping rows and columns can reduce clutter, but it does not keep labels in view while the remaining worksheet scrolls. Choose the tool according to the job: browsing, comparing, printing, or simplifying the layout.

Common Freeze Panes problems

The wrong rows or columns stay visible: Unfreeze and reselect the boundary cell. Remember that Excel freezes everything above and to the left of that cell, not everything including it.
Freeze Top Row did not also freeze a column: That preset holds only the top row. Use a boundary cell such as B2 to freeze row 1 and column A together.
The frozen area takes up too much space: Unfreeze and choose a boundary closer to the upper-left corner. Several frozen rows and columns can leave a very small scrolling area.
You cannot see the frozen boundary clearly: Look for the divider line between the fixed area and the scrolling area. If the view is confusing, unfreeze and apply the setting again after checking the active cell.
The headings disappear in printouts: Set repeating print titles under Page Layout > Print Titles. Freeze Panes is for the worksheet view, not printed page repetition.

One more point can prevent frustration: frozen panes apply to the worksheet view, not to a particular selected range. Sorting or filtering a table does not create additional freeze boundaries. If the worksheet’s structure changes substantially, revisit the boundary and confirm that the frozen labels still match the data people are viewing.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Windows, the ribbon path for freezing is View > Freeze Panes. Excel for Mac also has Freeze Panes options on the View tab, though the ribbon layout can look different. The core rule is the same: select the boundary cell to freeze rows above and columns to its left, or use the available top-row and first-column presets.

Excel for the web has freeze options too, but commands and available controls can vary with the web interface and updates. If you cannot find the exact combined option or need to adjust a complicated view, open the workbook in the desktop app and use the View tab. A workbook’s frozen view is a display setting, so check the sheet after opening it in another Excel version to confirm it behaves as intended.

Frequently Asked Questions

Can I freeze the top row and first column at the same time?
Yes. Select cell B2, then choose View > Freeze Panes > Freeze Panes. Excel keeps row 1 and column A visible together.

How many rows and columns can I freeze?
You can freeze multiple adjacent rows and columns by choosing a cell below and to the right of them. The limitation is that they must form the top and left edges of one frozen area; you cannot freeze separate, nonadjacent sections.

Can I freeze panes in two different worksheets?
Yes. Each worksheet can have its own Freeze Panes setting. Set the view on one sheet, switch to another, and configure that sheet separately if needed.

Why is Freeze Panes grayed out?
Check whether the worksheet is in a view or state that limits the command, such as having Split active, and whether the workbook or sheet has restrictions affecting available commands. Try removing Split from View > Split, then check the Freeze Panes menu again. If the workbook is protected, review its protection settings.

Does freezing panes protect cells from changes?
No. It only keeps rows or columns visible while scrolling. Frozen cells remain editable unless separate worksheet protection or permissions are applied.

Can frozen headings repeat on every printed page?
Not by themselves. Use Page Layout > Print Titles to set rows or columns to repeat in printouts. Freeze Panes controls the on-screen worksheet view, while print titles control page output.

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.