Adjust Freeze Panes in Excel: Steps and Fixes

To adjust freeze panes in Excel for Microsoft 365 on Windows, select View > Freeze Panes > Unfreeze Panes, then select the cell below the rows and to the right of the columns you want to keep visible. Choose View > Freeze Panes > Freeze Panes again; Excel freezes the rows above and columns to the left of your selected cell.

What Freeze Panes Does

Freeze Panes keeps chosen worksheet rows, columns, or both visible while you scroll through the rest of the sheet. It is useful when labels or identifiers would otherwise disappear from view. For example, freezing a header row helps you tell which field a number belongs to, while freezing a column of employee names keeps those names beside data farther across the worksheet.

The setting applies to the worksheet view, not to the data itself. It does not move, copy, protect, or repeat information; it simply holds the selected top rows and left columns in place as you navigate. You can still edit cells in frozen or scrolling areas, subject to the workbook’s normal editing permissions.

Excel offers three common choices from the Freeze Panes menu: Freeze Panes, Freeze Top Row, and Freeze First Column. The first option uses your current cell selection to determine the boundary. The other two are quick commands for a single row or column.

How to Set the Freeze Boundary

Excel freezes everything above and to the left of the active cell—not the active cell itself. Use this rule to choose the right starting point:

To keep row 1 visible, select a cell in row 2, such as A2.
To keep column A visible, select a cell in column B, such as B1.
To keep row 1 and column A visible together, select B2.
To keep rows 1–3 and columns A–B visible, select C4.

After selecting the cell, choose View > Freeze Panes > Freeze Panes. Scroll down or right to confirm that the intended labels remain visible. If the wrong area is fixed, unfreeze and repeat the process with a corrected selection. You do not need to select the entire row or column; selecting the cell at the boundary is enough.

How to Adjust Existing Frozen Rows or Columns

In Excel for Windows, you generally cannot drag a freeze boundary to a new position. Replace the current arrangement instead. First click anywhere in the worksheet, then select View > Freeze Panes > Unfreeze Panes. Next, select the cell that represents the new boundary and choose View > Freeze Panes > Freeze Panes.

For instance, suppose a sheet currently freezes only its top row, but you now want the top two rows and the first column to stay visible. Unfreeze the current panes, select B3, and apply Freeze Panes. Excel will hold rows 1 and 2 and column A in place. If you want just the top row, use Freeze Top Row; if you want just column A, use Freeze First Column.

Changing the selection without first unfreezing does not relocate an existing boundary. If the Freeze Panes menu shows Unfreeze Panes, a freeze setting is already active. Clear it before setting a different one.

Choosing Which Rows and Columns to Keep Visible

Freeze only the information that helps you interpret the part of the worksheet you are viewing. A wide frozen area leaves less room for the scrollable data, especially on a laptop display. Before applying the setting, consider what a reader needs to identify each record and each field.

Long lists: Freeze the header row so column names remain in view while scrolling down.
Wide reports: Freeze a key identifier column, such as a product name or account number, while scrolling horizontally.
Multirow headings: If headings occupy rows 1–3, select a cell in row 4 to keep all three rows visible.
Cross-referenced data: Freeze both a heading area and a label column when readers need to compare row names with column labels.

A practical test is to scroll to the far right and down to the last populated rows. If the frozen area occupies too much of the window or hides useful data, reset the boundary to include fewer rows or columns. Freeze Panes can hold contiguous rows from the top and contiguous columns from the left; it cannot keep a middle row or a nonadjacent column fixed by itself.

Windows, Mac, and Excel for the Web

In Excel for Microsoft 365 on Windows, the commands are on the View tab in the Freeze Panes menu. The usual sequence is to unfreeze, select the boundary cell, and freeze again. The same basic selection rule applies in Excel for Mac: use View > Freeze Panes, then choose the available freeze or unfreeze command. Menu wording and placement can vary slightly between releases.

In Excel for the web, open the workbook in the browser and use the View tab’s Freeze Panes options. Select the boundary cell before applying the general Freeze Panes command, just as you would in the desktop app. If a command is unavailable or the ribbon is condensed, expand the ribbon or check that the workbook is open for editing and that a cell—not a text-editing cursor—is active.

There is no need to use a different boundary rule on another platform. The main difference is the location or presentation of the ribbon controls, not what Excel freezes. If you switch between desktop and web versions, verify the result by scrolling after applying the setting.

Common Problems and How to Fix Them

The wrong rows or columns stay visible: Unfreeze, then choose the cell one row below and one column to the right of the area you mean to keep. Remember that the selected cell itself is not frozen.
Only the top row or first column is frozen: You may have selected the quick command for that single area. Unfreeze, choose the boundary cell, and use the general Freeze Panes command.
The menu appears unavailable: Finish editing the current cell by pressing Enter or Esc, then try again. Also confirm that you are on the worksheet you intend to change.
A large section of the sheet seems stuck: The selected boundary may have been farther down or farther right than intended. Unfreeze and recreate the setting with a cell closer to A1.
You expect frozen panes to affect a printout: Freeze Panes is a screen-view feature. It does not make headings repeat on printed pages; use Print Titles for that purpose.

Hidden rows or columns can also make a boundary less obvious. If the frozen area does not match what you expect, inspect the row numbers and column letters around the divider, unhide anything relevant, and then set the panes again. When working in a shared workbook, tell collaborators which rows and columns are intended to remain visible so they can understand the layout.

Freeze Panes Compared with Split and Print Titles

Freeze Panes and Split are related viewing tools, but they solve different problems. Freeze Panes holds rows at the top and columns at the left while the remaining worksheet scrolls. Split divides the worksheet window into independently scrollable sections, which can help compare distant parts of a sheet at once. A split is not simply a movable freeze boundary, and it may be cleared or changed separately using the controls on the View tab.

Printing has its own setting. To repeat headings on printed pages in desktop Excel for Windows, open Page Layout > Print Titles. In the Page Setup dialog, use the Sheet tab’s Rows to repeat at top or Columns to repeat at left fields. This is useful for a report that spans several printed pages. It does not keep those headings visible while scrolling on screen, so use Freeze Panes for the worksheet view and Print Titles for paper or print-to-PDF output.

A Simple Check Before Sharing a Worksheet

Freeze settings are most helpful when they support the way someone reads the data. Before sharing a workbook, check that the frozen labels are meaningful, the frozen area is not excessively large, and the active cell is positioned where the reader will begin. Scroll both vertically and horizontally to confirm the boundary behaves as intended.

If a worksheet has several header rows, consider whether all of them are necessary to interpret the data. Freezing a decorative title or blank spacer row can consume screen space without adding context. Likewise, a column that is useful at the left edge of the sheet may be less helpful if readers spend most of their time in a separate section. A small adjustment to the boundary can make a long worksheet much easier to navigate.

Frequently Asked Questions

How do I freeze the top two rows in Excel?
Click a cell in row 3, such as A3, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above the selected cell, so rows 1 and 2 remain visible.

Can I freeze the first two columns and the top row?
Yes. Select cell C2, then choose View > Freeze Panes > Freeze Panes. This freezes column A and column B, plus row 1.

How do I remove freeze panes in Excel?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current frozen rows and columns; you can then create a different arrangement if needed.

Can I freeze a row in the middle of a worksheet?
Not with Freeze Panes alone. Excel freezes contiguous rows starting at the top and contiguous columns starting at the left. To compare separate regions, consider using Split or opening another window for the workbook.

Do freeze panes repeat headings when I print?
No. Freeze Panes affects on-screen scrolling only. Set repeating print headings through Page Layout > Print Titles in desktop Excel.

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.