Excel Freeze Panes: How to Lock Rows and Columns in Place

Yes. In Excel for Microsoft 365 on Windows, you can freeze rows and columns at the same time: 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. Excel keeps the rows above and the columns to the left of that cell on screen as you scroll.

How the freeze boundary works

Freeze Panes divides a worksheet into scrolling and stationary areas. The selected cell sets the boundary: rows above it stay visible while you scroll down, and columns to its left stay visible while you scroll right. The selected cell itself is not a special frozen cell; it marks where the fixed area ends and the scrolling area begins.

For example, selecting C3 before applying Freeze Panes keeps rows 1 and 2, plus columns A and B, visible. The rest of the sheet can scroll in either direction. This makes the feature useful for large lists where a few header rows identify records and the first columns identify each record.

To freeze the first row and first column together, select B2.
To freeze the first two rows and column A, select B3.
To freeze rows 1 through 3 and columns A through C, select D4.

These examples assume the worksheet starts at cell A1 and that you want to keep a continuous block beginning at the top and left edges fixed. Freeze Panes cannot pin an arbitrary row in the middle of the sheet or an isolated column while allowing the rows or columns before it to scroll.

Steps to freeze rows and columns together

Open the worksheet you want to work with. Freeze settings apply to the active worksheet, so check that you are on the intended sheet.
Identify the last row and last column that should remain visible. Click the cell immediately below and to the right of that fixed area. For example, click C3 to retain the first two rows and first two columns.
On the ribbon, select View > Freeze Panes > Freeze Panes. Choose the final Freeze Panes command, not Freeze Top Row or Freeze First Column.
Scroll down and across to confirm that the intended headers and identifying columns remain in place.

It is important to select the boundary cell before opening the command. If you select A1, there are no rows above or columns to the left to freeze. If you click the wrong cell, choose Unfreeze Panes, select the correct cell, and apply Freeze Panes again.

In Excel for Mac, the same selection principle applies; use the View tab and its Freeze Panes command. In Excel for the web, open the View tab and choose Freeze Panes. Ribbon labels and available choices can vary slightly between builds, but the key is to select the boundary cell first. Excel for the web supports freezing panes, though some desktop controls and workflows may differ.

Choosing the right rows and columns

Freeze only what readers need to understand the values that move past them. In a sales report, that might mean the title and field-name rows at the top, along with columns for customer name and account number. In a schedule, it might be a row of dates and a column of employee names. Too much frozen space leaves less room for the data that needs to scroll, especially on a small display.

Before freezing, check whether the worksheet has a title or blank rows above its actual headers. Excel counts from the top of the worksheet, not from the first row that looks like a table header. If row 1 is a report title and row 2 contains headings, selecting A3 keeps both rows visible. If only row 2 should stay visible, Freeze Panes cannot skip row 1 and freeze row 2 by itself. You may need to rearrange the sheet or use another view approach.

Likewise, the first column means column A, not the first populated column. If your table begins in column C, freezing column C while columns A and B scroll is not a standard Freeze Panes arrangement. The feature fixes a contiguous region from the worksheet’s upper-left corner.

Freeze Panes versus the preset options

The Freeze Panes menu includes presets for Freeze Top Row and Freeze First Column, as well as the general Freeze Panes command. The two presets each freeze one edge of the sheet, regardless of the active cell. They are convenient when you need only the top row or only column A.

Those presets are not cumulative. Choosing Freeze Top Row and then Freeze First Column does not reliably build a combined frozen area; applying a different freeze command can replace the existing freeze arrangement. To keep both a row and a column fixed, select the appropriate boundary cell and use the general Freeze Panes command. For the first row plus column A, select B2.

The general command also handles multiple rows or columns. To keep the first four rows and columns A and B in view, select C5. This is more flexible than the presets, but it still follows the same top-left, continuous-block rule.

Unfreezing, changing, and checking panes

To remove the current frozen boundaries, select View > Freeze Panes > Unfreeze Panes. If you want a different boundary, unfreeze first, select a new cell, and apply Freeze Panes again. You cannot drag the boundary to a new location; changing it means replacing the existing setting.

A worksheet with frozen panes may show a thin line marking the edge of the stationary area. Scroll bars still move the unfrozen part of the worksheet. If you are uncertain which rows or columns are fixed, scroll horizontally and vertically: stationary headings indicate a freeze, while all content moving together indicates there is no active freeze.

Each worksheet can have its own freeze arrangement. A workbook may therefore have a frozen heading row on one sheet and no frozen panes on another. If several sheets are selected as a group, be careful when making view changes, because grouped-sheet editing can affect multiple sheets. Select one sheet tab before changing its view if you intend to alter only that sheet.

Common problems and misconceptions

The wrong amount is frozen: The active cell was probably not at the intended boundary. Unfreeze, select the cell one row below and one column to the right of the desired fixed area, and try again.
Only a row or only a column is frozen: A preset was used. Use the general Freeze Panes command with a boundary cell to freeze both directions.
The headings disappear anyway: Check that the headings are above the selected boundary and that you are scrolling within the same worksheet. A heading below the boundary is part of the scrolling region.
Freeze Panes appears unavailable: Check whether the worksheet is protected or whether Excel is in a view or editing state that limits ribbon commands. Exit cell editing, return to a normal worksheet view if needed, and check the View tab again.
The divider looks like a split: Freeze Panes and Split both divide the view, but they are different features. A split creates independently scrollable sections; frozen panes hold selected top and left areas in place.

A common misconception is that freezing a row or column changes the worksheet data or printout. It does not rearrange, lock, hide, or protect cell values. It changes how the sheet appears while navigating on screen. To repeat column headings on printed pages, use a print setting such as Print Titles rather than relying on Freeze Panes.

Freeze Panes, Split, and print settings

Freeze Panes is designed to keep reference information visible while the rest of one worksheet scrolls. Split is useful when you want to inspect distant parts of the same sheet at once: it divides the window into sections that can scroll separately. If your goal is to compare two distant areas, a split or a second window may suit the task better than freezing the top and left edges.

For printed worksheets, frozen rows do not automatically repeat at the top of every page. In Excel for Windows, set repeated print headings through Page Layout > Print Titles, then specify rows to repeat at top or columns to repeat at left in Page Setup. This is separate from the on-screen freeze arrangement. Review Print Preview because page breaks and print scaling can affect the final layout.

Freeze Panes is also not the same as protecting a worksheet. A frozen column remains visible but its cells are not protected from editing. Use worksheet protection when you need to restrict edits, and treat freeze settings as a navigation convenience only.

When freezing panes helps most

The feature is especially useful when a dataset is taller or wider than the visible window. Keeping column labels in view helps prevent confusing values from different fields; keeping a key such as product ID or employee name visible helps identify the row as you move across many columns.

For a wide financial or operational report, for instance, you might keep two header rows and the first column of account names fixed. Selecting B3 does that if column A contains the account names and rows 1 and 2 contain the headings. If the report has an extra title in row 1 and field names in row 2, retaining both can be sensible, but check that the fixed area does not crowd out the scrolling data.

For a simple list with one header row and no important left-side identifier, Freeze Top Row may be faster and clearer. For a wide list where the row labels matter but the headers do not, Freeze First Column may be enough. The best choice is the smallest fixed area that preserves context while leaving the largest practical workspace for scrolling.

Frequently Asked Questions

Can I freeze the top row and first column at the same time?
Yes. Select B2, then choose View > Freeze Panes > Freeze Panes. The Freeze Top Row and Freeze First Column presets are separate; the boundary-cell method combines them.

Which cell do I select to freeze two rows and three columns?
Select D3. Rows 1 and 2 are above the cell, and columns A through C are to its left, so those areas remain visible.

Can I freeze a row that is not at the top?
Not by itself with Freeze Panes. Excel freezes rows above the selected cell, starting at row 1. You can keep the rows above a boundary visible, but you cannot freeze only a standalone middle row while earlier rows scroll.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. The worksheet returns to ordinary scrolling; the cell contents are unchanged.

Why do frozen panes not repeat when I print?
Freeze Panes affects on-screen navigation, not printed page headers. Set repeated rows or columns using Page Layout > Print Titles, then check Print Preview.

Does freezing a column prevent other people from editing it?
No. It only keeps the column visible while scrolling. Use worksheet protection and appropriate permissions if you need to limit editing.

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.