Excel Freeze Panes: Keep Rows and Columns Visible

In Excel for Microsoft 365 on Windows, 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 columns to the left of that cell on screen while the rest of the worksheet scrolls.

What Freeze Panes does

Freeze Panes separates a worksheet into a fixed area and a scrollable area. The fixed area stays visible as you move down or across the sheet, so labels such as dates, product names, or employee IDs remain available for comparison. It changes how the sheet appears on screen; it does not rearrange, hide, or lock the underlying cells.

The selection you make determines the boundary. Excel freezes entire rows above the active cell and entire columns to its left—not just the individual cells in those positions. For example, select B2 and use Freeze Panes to keep row 1 and column A visible. The selected cell, B2, is part of the scrolling area, along with the cells below and to the right.

This is useful in long or wide worksheets where you would otherwise lose sight of headings. A sales report might have months across the top and regional names down the first column. Freezing the top row and first column lets you scroll through the figures while retaining both labels.

How to choose the rows and columns to freeze

Choose the cell at the intersection of the first row and column you want to scroll. Excel freezes everything above and to the left of that cell. The rule is easier to apply with a few examples:

Keep the first row visible: Choose View > Freeze Panes > Freeze Top Row. This is the quickest option for a single header row.
Keep the first column visible: Choose View > Freeze Panes > Freeze First Column. This is useful when identifying each record by a name or ID in column A.
Keep the first two rows visible: Select A3, then choose View > Freeze Panes > Freeze Panes.
Keep columns A and B visible: Select C1, then choose View > Freeze Panes > Freeze Panes.
Keep rows 1 and 2 and columns A and B visible: Select C3, then choose View > Freeze Panes > Freeze Panes.

Use the general Freeze Panes command when you need more than the built-in top-row or first-column choice. The selection does not need to contain data: it marks the boundary. Selecting A1 freezes no rows or columns because nothing lies above or to its left.

Steps to freeze and unfreeze a worksheet

Before freezing, scroll to the top-left of the worksheet if you want to inspect the intended boundary. Then click the appropriate cell and use the View tab. On Windows, the full path for a custom arrangement is View > Freeze Panes > Freeze Panes. The Freeze Panes menu also provides Freeze Top Row, Freeze First Column, and Unfreeze Panes.

Click the cell below and to the right of the area you want to keep visible.
Open View > Freeze Panes and select Freeze Panes, Freeze Top Row, or Freeze First Column.
Scroll down or sideways to confirm the correct rows and columns remain in place.
To remove the arrangement, choose View > Freeze Panes > Unfreeze Panes.

Only one freeze arrangement can be active on a worksheet at a time. Choosing a different freeze option replaces the current arrangement rather than adding a second, independent set of frozen areas. Unfreeze Panes returns the sheet to normal scrolling; it does not delete or change cell contents. The freeze setting is saved with the workbook, so it remains in place when the workbook is saved and reopened.

What scrolling looks like with frozen panes

Frozen areas stay fixed at the edge of the worksheet while the unfrozen portion moves. With the first row frozen, scrolling downward moves the data beneath it while the row headings and column letters remain part of the normal Excel interface. With column A frozen, scrolling to the right keeps that column visible. If you freeze both rows and columns, Excel maintains the upper-left fixed area and scrolls the other regions as you navigate.

Freeze boundaries are based on worksheet row and column positions, not on whichever rows happen to be visible. If row 1 is hidden, Freeze Top Row still refers to row 1; it does not freeze the first visible row instead. Similarly, Freeze First Column means column A, even if you have scrolled horizontally and another column is currently at the left edge of the window.

Frozen panes also do not keep a particular record visible while you scroll. They hold fixed the rows above and columns to the left of the selected boundary. Excel cannot use Freeze Panes to pin an arbitrary row in the middle of a list while the rows above it scroll away.

How to choose a useful freeze layout

For a simple list with one heading row, Freeze Top Row is usually enough. For a broad worksheet where each row is identified by a label in column A, Freeze First Column can make horizontal scrolling easier. When a report has several heading rows—for example, a title, a date range, and then column labels—select the first data row and freeze the rows above it instead.

Consider which labels need to stay visible during the task, rather than freezing as much as possible. A large fixed area takes up screen space and leaves less room to inspect data. If you freeze the first six rows and four columns on a small display, the remaining scrollable area may become cramped. A practical layout might keep two header rows and one identifying column visible, while leaving detailed notes and secondary labels in the scrollable region.

Freeze Panes works on the active worksheet. If a workbook has several tabs, set the view separately on each sheet where it is useful. It is a viewing aid rather than a data-management feature: sorting, filtering, formulas, and cell values continue to work according to their usual rules.

Common problems and misconceptions

The wrong rows or columns stay fixed: Unfreeze Panes, select the correct boundary cell, and apply Freeze Panes again. Remember that the selected cell marks the first scrolling row and column.
Only one row stays visible: Freeze Top Row is designed for row 1 only. To freeze several rows, select a cell in the first row below them and choose the general Freeze Panes command.
The header is not in row 1: Freeze Top Row will still freeze worksheet row 1. If your headings begin in row 4, select A5 to freeze rows 1 through 4, or use another boundary that matches the layout.
The command seems to do nothing: Check whether the selection is A1, which has no rows above or columns to the left to freeze. Also check that you selected the intended worksheet tab and that the frozen boundary is not outside the currently visible area.
The screen has several movable sections: You may have used Split rather than Freeze Panes. Split divides the window into separately scrollable panes; it does not keep the top rows or left columns fixed in the same way.

Freeze Panes is not the same as protecting a worksheet. It does not prevent someone from editing, deleting, or moving data. To restrict editing, use worksheet protection settings; to keep labels visible during printing, use print titles instead. These are separate tasks with separate controls.

Freeze Panes, Split, and print titles compared

Freeze Panes is for keeping selected top rows and left columns visible while navigating a worksheet on screen. It is usually the right choice for a large table whose headings or identifying fields would otherwise scroll out of view.

Split, available from View > Split, divides the worksheet window into sections that can be scrolled independently. It can help compare distant parts of a sheet, such as a summary near the top and detail rows farther down. Unlike Freeze Panes, the purpose is to create multiple viewing areas, not simply to keep header rows and leading columns fixed. Use the Split command again to remove a split.

Print Titles repeats specified rows or columns on each printed page. A frozen heading can remain visible while you scroll on screen, but that does not automatically make it repeat on paper or in a PDF. For repeated printed headings, use Page Layout > Print Titles and set the rows to repeat at the top or columns to repeat at the left. Check Print Preview to confirm the result.

Excel for Mac and Excel for the web

In Excel for Mac, the same basic selection rule applies: select the cell below and to the right of the area to keep visible, then use View > Freeze Panes. The Freeze Top Row, Freeze First Column, and Unfreeze Panes choices are also available in current Excel for Mac versions, though the ribbon appearance can differ from Windows. If the menu is not visible, check the View tab or the app’s View menu.

Excel for the web also includes Freeze Panes on the View tab. Select the boundary cell first, then use the freeze command; the same above-and-left rule applies. Some interface details can vary as Microsoft updates the web app, and options may be arranged differently from desktop Excel. If a workbook opens in a browser and a command is unavailable in that view, open it in the desktop app for the full ribbon experience.

On Windows, the ribbon key sequence Alt+W, F, F opens the Freeze Panes command through the View tab in many current desktop builds; follow the displayed KeyTips if they differ. There is no single default Mac keyboard shortcut that is equivalent across Mac keyboards and Excel versions, so the View menu is the dependable route there.

Frequently Asked Questions

Can I freeze more than one row and one column?

Yes. Select the cell below all the rows and to the right of all the columns you want fixed, then choose View > Freeze Panes > Freeze Panes. For example, select D4 to freeze rows 1 through 3 and columns A through C.

Why does Freeze Top Row freeze the wrong row?

Freeze Top Row always targets worksheet row 1, not the first visible row or the row containing your headings. To freeze headings farther down the sheet, select the row immediately beneath them and use the general Freeze Panes command.

Can I freeze a row in the middle of a worksheet?

You can freeze rows above the selected boundary, but you cannot pin an arbitrary middle row while allowing rows above it to scroll independently using Freeze Panes. Use Split if you need separate scrollable sections, or consider moving the key labels to the top of the worksheet.

Does freezing panes affect printing or editing?

No. Freeze Panes changes the on-screen view; it does not protect cells or repeat headings on printed pages. Use worksheet protection to limit editing and Page Layout > Print Titles to repeat rows or columns in printouts.

How do I remove frozen panes?

Choose View > Freeze Panes > Unfreeze Panes. This removes the fixed screen area without changing worksheet data. You can then select a new boundary and apply a different freeze arrangement.

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.