Excel Freeze Panes: Keep Rows and Columns While Scrolling

Yes. In Excel for Microsoft 365 on Windows, select the cell just below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Excel freezes the rows above and columns to the left of that cell, so both can remain visible while you scroll.

How Freeze Panes Works

Freeze Panes divides the worksheet window into a scrolling area and one or two stationary areas. The frozen rows stay at the top; frozen columns stay at the left. The rest of the sheet can move vertically, horizontally, or both, while those selected rows and columns remain on screen. A fine line in the worksheet marks the boundary.

The active cell determines that boundary. Excel freezes every row above the selected cell and every column to its left. It does not freeze the active cell itself. For example, selecting C4 and choosing Freeze Panes locks rows 1 through 3 and columns A and B. The cells from C4 onward remain in the scrolling portion of the sheet.

This makes the feature useful when a data table has labels at the top and identifying information at the left. You can move down through hundreds of records without losing the column headings, or move right across a wide report while keeping names or dates in view.

Freeze Rows and Columns Together

Use this sequence when you want a custom combination of rows and columns to stay visible:

Open the worksheet and decide how many top rows and left columns should remain on screen.
Select the cell immediately below the last row to freeze and immediately to the right of the last column to freeze.
Open the View tab on the ribbon.
Choose Freeze Panes, then choose Freeze Panes again from the menu.
Scroll down and across to check that the intended headings and identifiers remain visible.

For example, suppose row 1 contains a report title, row 2 has column headings, and column A contains employee names. To keep both rows and the names visible, select B3 before choosing Freeze Panes. Excel then freezes rows 1 and 2 and column A. If the sheet has two identifier columns, A and B, select C3 instead.

The selection must be at the intersection just outside the area you want to lock. If you select A3, Excel freezes rows 1 and 2 but no columns, because there are no columns to the left of A. If you select C1, it freezes columns A and B but no rows.

Choosing the Right Cell: Examples

Translate the desired frozen area into the next row and next column before making the selection. These examples use ordinary worksheet coordinates:

Top row only: Choose View > Freeze Panes > Freeze Top Row. You do not need to select a cell first.
First column only: Choose View > Freeze Panes > Freeze First Column.
Rows 1 and 2 plus column A: Select B3, then choose Freeze Panes > Freeze Panes.
Rows 1 through 4 plus columns A through C: Select D5, then choose Freeze Panes > Freeze Panes.
Columns A and B only, with no frozen rows: Select C1 and choose Freeze Panes > Freeze Panes.

The dedicated Top Row and First Column commands are convenient for simple cases. To freeze a custom number of rows and columns together, use the main Freeze Panes command with the correct active cell. Excel does not provide separate commands for every possible combination.

Unfreezing or Changing the Pane

A worksheet can have one freeze-pane arrangement at a time. To replace it, first select View > Freeze Panes > Unfreeze Panes. Then select the new boundary cell and apply Freeze Panes again. For example, if the sheet currently freezes only the top row but you want the top two rows and first column, unfreeze the existing view, select B3, and freeze again.

Unfreezing changes how the sheet is displayed; it does not delete, rearrange, or alter cell data. It also does not remove headings or filters. If the menu offers Unfreeze Panes, a freeze arrangement is already active. If it offers Freeze Panes instead, there is no current frozen arrangement on that sheet.

Freeze settings apply to individual worksheets rather than automatically carrying over to every tab in a workbook. If a workbook has several data sheets, set up each one as needed. The view configuration is saved with the workbook, so it can appear again when the file is reopened, subject to how and where the workbook is opened.

Freeze Panes, Split, and Other View Options

Freeze Panes and Split can both divide the worksheet window, but they serve different purposes. Freeze Panes keeps selected rows or columns stationary while the other area scrolls. Split creates separately scrollable sections, which can help compare distant parts of one worksheet without locking a header in place. For routine tables where labels should remain visible, Freeze Panes is usually the more direct choice.

Freeze Panes also differs from hiding rows or columns. Hidden content is not displayed until it is unhidden; frozen content remains visible and continues to occupy its normal space. The feature does not protect cells from editing, restrict scrolling to a range, or make a heading repeat on printed pages. Those are separate tasks, handled by worksheet protection, navigation choices, or print settings.

For a table with a single header row, freezing the top row often does the job. If the worksheet contains title rows above the actual headings, use a custom freeze boundary instead. A title row may look like part of the header, but freezing only the top row will not keep lower heading rows visible as you scroll.

Scrolling and Working with Frozen Areas

After freezing panes, use the vertical scrollbar to move through rows and the horizontal scrollbar to move through columns. The frozen portion stays in place while the unfrozen area moves. This is especially helpful on a laptop screen, where scrolling can quickly move headings out of view. You can still select and edit cells in frozen rows or columns; freezing affects the view, not whether cells are editable.

Frozen rows and columns take up screen space. Locking many of them may leave too little room for the data you need to inspect. If the first four rows contain notes, a title, filters, and headings, consider whether all four truly need to remain visible during analysis. A compact frozen area makes the scrolling region easier to use.

When you need to inspect a different part of the sheet, remember that freezing does not stop navigation. You can go to a cell or scroll through the unfrozen region, while the locked labels remain available for context. If the frozen boundary seems to obscure the layout, adjust the selection by unfreezing and applying a new boundary rather than trying to drag the frozen line.

Excel for Mac and Excel for the Web

In current Excel for Mac, use the View tab and its Freeze Panes menu to freeze a custom selection, the top row, or the first column. The principle is the same: select the cell below and to the right of the area to keep, then apply Freeze Panes. The precise ribbon layout can vary with the Mac window size, but the command is on the View tab. Excel for Mac also has a View menu in the macOS menu bar; use the Freeze Panes command there if it is available in your version.

In Excel for the web, open the View tab and use Freeze Panes. The browser version supports freezing rows and columns, though some surrounding workbook-view controls may differ from the desktop app. If the command is not visible, check that the workbook is open for editing and that the browser window is wide enough to show the ribbon controls. For menus or behavior that differ in a particular build, the desktop app provides the full Windows instructions described above.

When collaborating, remember that frozen panes are a view setting, not a change to the worksheet’s data structure. Still, collaborators may see a saved view or have their own view behavior depending on the Excel environment and sharing setup. If a particular layout matters, tell colleagues which rows and columns the sheet is designed to keep visible.

Common Problems and Fixes

The wrong rows or columns are frozen: Unfreeze, then select the cell one row below and one column to the right of the intended frozen area. Reapply Freeze Panes.
Only the top row or first column is frozen: The dedicated Top Row or First Column option was used. Unfreeze, select a boundary cell such as B3, and use the general Freeze Panes command.
The headings still scroll away: Check whether the real headings are below a title or blank row. The selected boundary may need to be lower to include all required header rows.
There is too little room to see the data: Reduce the number of frozen rows or columns, especially if the worksheet is displayed at high zoom or in a small window.
The Freeze Panes menu says Unfreeze Panes: A freeze arrangement is already active. Choose Unfreeze Panes before setting a different boundary.

One common misconception is that selecting the last row or column you want to freeze is enough. It is not: Excel freezes the rows above and columns to the left of the active cell. For rows 1 and 2 with column A, selecting A2 would not do what you intend; select B3 so the desired area lies above and left of the boundary.

Frequently Asked Questions

Can I freeze the top two rows and the first column?

Yes. Select cell B3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 and column A remain visible as you scroll.

Can I freeze rows and columns at the same time?

Yes. Choose the cell immediately below the rows and immediately to the right of the columns you want to lock, then use the general Freeze Panes command. The Top Row and First Column commands are for simpler, separate cases.

Why is Freeze Panes greyed out?

Check whether the workbook is in a mode or state that prevents editing, and make sure a worksheet cell is selected. In Excel for the web, confirm that you have editing access. If the workbook is protected or opened read-only, switch to an editable copy or ask for the required access.

Does Freeze Panes affect printing?

No. It controls the on-screen worksheet view, not printed page layout. To repeat headings on printed pages, use the separate print setting for rows to repeat at the top in the Page Setup options.

Can I freeze more than one separate block?

Not with Freeze Panes. It creates one contiguous frozen area at the top and left of the worksheet. If you need separately scrollable sections, consider Split instead, or reorganize the data so related labels sit together.

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.