Excel Freeze Panes: Lock Rows and Columns Together

Yes. In Excel for Microsoft 365 on Windows, select the cell immediately below the rows and immediately 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 columns A and B on screen while you scroll through the rest of the worksheet.

What Freeze Panes Does

Freeze Panes keeps selected rows at the top of the worksheet and selected columns at the left edge while you scroll elsewhere. It is useful when a wide or long sheet has labels you need to refer to repeatedly: a header row, an identifying column, or both. The frozen area stays visible in the worksheet window; the rest of the sheet remains scrollable.

The feature does not lock cells against editing, protect data, or make headings repeat on printed pages. It changes how the worksheet is displayed on screen. If you need to prevent changes, use worksheet protection instead. If you need headings to appear on printed pages, configure print titles separately.

Freeze Panes can keep multiple rows and multiple columns visible, but the frozen sections must start at the top and left of the sheet. You cannot freeze an isolated middle row or a column in the middle while allowing earlier rows or columns to scroll. The active cell selection tells Excel where the frozen boundaries should be.

How to Freeze Rows and Columns at the Same Time

Use the custom Freeze Panes command rather than choosing the preset for just the top row or first column. In the Windows desktop version, follow these steps:

Open the worksheet you want to work with. If the sheet already has panes frozen, choose View > Freeze Panes > Unfreeze Panes first.
Identify how many top rows and leftmost columns should remain visible. For example, to keep two heading rows and the first column, plan to select cell B3.
Click the cell immediately below the last row to freeze and immediately to the right of the last column to freeze.
Choose View > Freeze Panes > Freeze Panes. Do not choose Freeze Top Row or Freeze First Column if you need both directions.
Scroll down and across to confirm that the intended rows and columns stay in view.

Excel freezes everything above and to the left of the selected cell, not the selected cell itself. So selecting C2 freezes row 1 and columns A:B. Selecting D4 freezes rows 1:3 and columns A:C. This simple rule is the key to setting the boundaries correctly.

How to Choose the Correct Cell

Think of the selected cell as the top-left corner of the part of the worksheet that should keep moving. The frozen area occupies the rows above it and the columns to its left. If you want only a header row and the first column to stay visible, select B2. If you want two header rows and the first two columns to stay visible, select C3.

Here are a few common layouts:

One header row and one identifier column: select B2 to freeze row 1 and column A.
One header row and two identifier columns: select C2 to freeze row 1 and columns A:B.
Three heading rows and one label column: select B4 to freeze rows 1:3 and column A.
Two heading rows and three identifying columns: select D3 to freeze rows 1:2 and columns A:C.

Before freezing, check that your selection is not one row or one column too far in either direction. Selecting B3 rather than B2, for instance, freezes two rows instead of one. If the result is wrong, unfreeze and repeat with the correct cell; dragging the divider is not the way to adjust a frozen boundary.

Practical Examples

Imagine a monthly sales sheet with dates across the top and employee names in column A. Select B2 and freeze panes. When you scroll down to later employees, the date headings remain visible; when you scroll right to later months, the names remain visible. At the intersection, both the top row and the first column stay put, making it easier to connect a number with its month and employee.

For a report with a title row, a column-heading row, and two columns identifying each record, select C3. Excel keeps rows 1 and 2 and columns A and B in view. This can be helpful when a worksheet contains several hundred records and the first columns hold an ID and department while later columns hold details.

Freeze only the rows or columns that genuinely help orient the reader. Keeping too many on screen reduces the area available for the data, especially on a small display. A good test is to scroll to a distant section and ask whether the labels still make the values easier to understand without crowding the worksheet.

What Happens When You Scroll

With panes frozen, the worksheet is divided into a fixed region and a scrolling region. Frozen rows remain at the top while vertical scrolling moves the unfrozen rows. Frozen columns remain at the left while horizontal scrolling moves the unfrozen columns. You can still select cells, enter data, use formulas, and apply formatting in either region.

The freeze boundary is tied to worksheet rows and columns, not to a particular table or a named range. If you insert or delete rows or columns, Excel may adjust the worksheet layout and the visible boundary can behave differently than you expected. After substantial structural edits, scroll around and verify the view. Freeze Panes is also a per-worksheet display setting: setting it on one tab does not automatically freeze the same area on every other tab.

Freezing does not change the underlying order of data or affect calculations, sorting, filtering, or the values in cells. It is a viewing aid, not a data-management command. It also does not make frozen headings repeat when you print; screen navigation and printed page layout are separate tasks.

Changing or Removing Frozen Panes

Excel does not let you reposition an existing freeze boundary simply by selecting a different cell and choosing Freeze Panes again. First remove the current setting with View > Freeze Panes > Unfreeze Panes. Then select the new boundary cell and choose View > Freeze Panes > Freeze Panes. This two-step reset prevents the old boundary from confusing the new selection.

The preset commands are convenient when you need only one simple area. Freeze Top Row freezes the first row, and Freeze First Column freezes column A. If you need both at once, or need more than one row or column, use the custom command with a carefully chosen cell. Applying a preset after a custom freeze replaces the current arrangement rather than adding another independent frozen section.

To remove the effect, choose Unfreeze Panes from the same menu. This restores ordinary scrolling; it does not delete rows, columns, content, or formatting. If you are uncertain which view is active, open the Freeze Panes menu and check whether Excel offers Unfreeze Panes.

Common Problems and Fixes

The wrong row or column stays visible: unfreeze, count the desired rows and columns from the top and left, and select the cell just beyond both boundaries. For one row and two columns, use C2.
Only one direction is frozen: you may have chosen Freeze Top Row or Freeze First Column. Unfreeze and use the main Freeze Panes command after selecting the correct cell.
The menu option is unavailable or does not behave as expected: make sure you are in the worksheet grid and check whether panes are already frozen. Unfreeze the existing panes before setting a different arrangement.
Frozen panes take up too much space: reduce the number of frozen rows or columns. A large frozen area can leave little room to view the scrolling section.
Headings disappear in a printout: Freeze Panes affects the on-screen view, not printed page headers. For repeating rows or columns on printouts in desktop Excel, use Page Layout > Print Titles.

A frequent misconception is that freezing the first row and then freezing the first column will combine the two settings. These are separate presets, and choosing one after the other does not build a larger frozen area. For a combined arrangement, reset the panes and create both boundaries at once using the cell-selection rule.

Freeze Panes Compared with Split

Freeze Panes and Split both divide the worksheet window, but they solve different navigation problems. Freeze Panes holds a designated top and left area in place as you scroll the main part of the sheet. Split creates separate panes that can be scrolled independently. Use Freeze Panes when you want headings or identifiers to remain anchored; consider Split when you want to inspect different parts of the same worksheet at once.

For example, a long list with one heading row generally calls for Freeze Panes. A comparison task that requires looking at two distant sections may be better suited to Split, because each pane can show a different part of the sheet. The two features are not interchangeable, and using a split does not mean the headings are permanently locked in the way frozen rows and columns are.

Excel on Mac and the Web

In Excel for Microsoft 365 on Mac, the Freeze Panes controls are available from the View tab; select the boundary cell and use the custom Freeze Panes command as you would on Windows. Ribbon layout and wording can differ slightly by platform or update, but the selection principle is the same: Excel freezes rows above and columns to the left of the active cell. The Windows ribbon path in this guide is View > Freeze Panes > Freeze Panes.

Excel for the web also provides Freeze Panes controls on the View tab. Choose the cell at the intended boundary before applying the custom option, and check the result by scrolling. If a control is not shown in the current window, the ribbon may be collapsed or the available interface may differ; expanding the ribbon or opening the workbook in the desktop app can help. A keyboard shortcut is not necessary for this task, and menu labels can vary with interface updates.

Frequently Asked Questions

Can I freeze rows and columns at the same time in Excel?

Yes. Select the cell below the rows and to the right of the columns to keep visible, then choose View > Freeze Panes > Freeze Panes. For example, C2 freezes row 1 and columns A:B.

Why does Excel freeze the wrong row or column?

The selected cell marks the start of the scrolling area. Excel freezes all rows above it and columns to its left, so check that you selected exactly one row below and one column to the right of the desired frozen area.

Can I freeze more than one row and column?

Yes. Select a cell below all the rows and to the right of all the columns you want frozen. Selecting D4 freezes rows 1:3 and columns A:C.

How do I unfreeze panes in Excel?

Choose View > Freeze Panes > Unfreeze Panes. You can then select a new boundary cell and apply Freeze Panes again.

Does Freeze Panes repeat headings when I print?

No. It keeps rows and columns visible while navigating on screen. To repeat headings on printed pages in desktop Excel, use Page Layout > Print Titles.

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.