Freeze Panes in Excel: How to Keep Rows and Columns Visible

In Excel for Microsoft 365 on Windows, use View > Freeze Panes to keep rows or columns visible while you scroll. Choose Freeze Top Row or Freeze First Column for a single edge, or select a cell and choose Freeze Panes to hold every row above it and every column to its left.

What Freeze Panes does

Freeze Panes keeps selected worksheet rows or columns in view as you move through the rest of the sheet. It is especially useful when a list is taller or wider than the visible worksheet area. For example, a sales report may have product names in column A and month names across row 1. Without freezing, scrolling down can hide the month headings, while scrolling right can hide the product names. Freezing the appropriate row and column keeps those labels available for reference.

The feature changes how the worksheet displays while you scroll; it does not change the cells, their values, or their position. A frozen row is not protected from editing, and Freeze Panes does not make a heading repeat on printed pages. It is a navigation aid, not a way to lock data or format a printout.

How Excel decides what stays visible

Excel uses the active cell when you choose the general Freeze Panes command. It freezes all worksheet rows above that cell and all columns to its left. The selected cell itself, and the rows below and columns to its right, remain in the scrollable area. A boundary line marks the edge of the frozen area.

For example, selecting cell C5 and choosing View > Freeze Panes > Freeze Panes keeps rows 1 through 4 and columns A and B visible. This is handy when a report has several heading rows and two identifying columns. If you select A2 instead, only row 1 is frozen, because there are no columns to the left of column A.

Excel can freeze a horizontal area, a vertical area, or both at once. It does not let you create separate, disconnected frozen regions with this command. A single freeze boundary divides the sheet into a fixed top-and-left area and a scrollable bottom-and-right area.

Freeze the top row or first column

For a simple layout, use one of the preset commands on the View tab. These options are faster than selecting a cell when you need to keep just one heading row or one label column visible.

Freeze Top Row: Choose View > Freeze Panes > Freeze Top Row. Row 1 remains visible as you scroll down.
Freeze First Column: Choose View > Freeze Panes > Freeze First Column. Column A remains visible as you scroll to the right.

The presets refer to the worksheet’s first row and first column, not whichever row or column currently contains your selected cell. If your actual headers begin on row 3, the Freeze Top Row command will still freeze row 1. To keep rows 1 through 3 visible, select a cell in row 4 and use the general Freeze Panes command instead.

Freeze multiple rows and columns

To freeze more than one row or column, first identify the boundary you want between the fixed area and the scrolling area. Select the cell immediately below the last row you want to keep visible and immediately to the right of the last column you want to keep visible. Then choose View > Freeze Panes > Freeze Panes.

Decide which rows should remain visible at the top and which columns should remain visible at the left.
Click the cell one row below and one column to the right of those areas.
On the ribbon, select View > Freeze Panes > Freeze Panes.
Scroll down or right to confirm that the intended headings and labels stay in view.

Suppose a worksheet has a title in row 1, column headings in row 2, and customer names in column A. To keep rows 1 and 2 and column A visible, select B3 before applying Freeze Panes. To keep only row 2 and column A, the same basic boundary rule applies: select a cell in row 3 and column B, but remember Excel freezes all rows above the selection, including row 1. You cannot skip row 1 while freezing row 2 with this command. If the layout makes that distinction important, consider moving or reorganizing the headings.

Choosing the right freeze boundary

Freeze only what readers need to identify the data. A wide frozen area takes up space that would otherwise show the scrollable worksheet, which can be frustrating on a small screen. For a long contact list, freezing the header row is often enough. For a large comparison table, keeping both the header row and the name or category column may help. A dashboard with several title and note rows may not need all of them frozen if they occupy a substantial part of the screen.

A useful way to decide is to ask what information would become confusing if it disappeared during scrolling. Common candidates include column labels, record names, dates, units, and category identifiers. Freeze the smallest contiguous set of rows and columns that preserves that context. Then test the result by scrolling in both directions; a setting that works at the top of a sheet may feel cramped when viewing many columns.

Unfreeze panes and change the selection

Excel applies one freeze configuration at a time on a worksheet. If you want to change which rows or columns stay put, first remove the current configuration. Choose View > Freeze Panes > Unfreeze Panes, select the new boundary cell, and apply Freeze Panes again. To switch from freezing the top row to freezing the first column, unfreeze the existing setting before choosing the other preset.

Unfreezing does not remove worksheet data or alter cell formatting. It simply restores normal scrolling. You can repeat the process whenever the worksheet’s layout or your task changes. Freeze settings apply to the active worksheet rather than automatically freezing the same locations on every sheet in a workbook, so check other tabs separately if they also need frozen headings.

Common problems and misconceptions

The wrong rows or columns froze: The selected cell may have been in the wrong position. Unfreeze, select the cell just below and to the right of the desired frozen area, then apply the command again.
Freeze Top Row froze row 1, not my headings: That preset always targets the worksheet’s first row. Use the general command with a cell below the actual heading rows.
I cannot see much of the worksheet: Too many rows or columns may be frozen. Unfreeze and choose a smaller area so the scrollable region has enough room.
The headings disappear on printed pages: Freeze Panes affects on-screen scrolling, not page printing. For repeated print headings, use the separate print settings, such as Page Layout > Print Titles, and set rows or columns to repeat on printed pages.
I expected cells to be protected: Freezing does not prevent editing. Worksheet protection is a separate feature with separate settings.

Also distinguish freezing from simply selecting a cell or turning on filters. A filter can help show particular records, but it does not keep labels visible as you scroll. Likewise, Freeze Panes does not automatically make a worksheet easier to read if the column labels are unclear; it only keeps the chosen area on screen.

Freeze Panes compared with Split

Split is a related View feature, but it serves a different purpose. It divides the worksheet window into independently scrollable panes, allowing you to look at different parts of the same sheet at once. Freeze Panes instead keeps a top section, a left section, or both stationary while the remaining area scrolls. For a standard table where headers should remain visible, Freeze Panes is usually the more direct choice. Use Split when independent views of distant areas are useful.

These options are not the same as opening another window of the workbook, either. A second window can show another part of a workbook separately, while Freeze Panes changes the scrolling behavior of the current worksheet view. Consider the task: keeping labels attached to a scrolling list calls for freezing; comparing distant sections at the same time may call for split panes or another window.

Frequently Asked Questions

Where is Freeze Panes in Excel?
In Excel for Microsoft 365 on Windows, open the View tab and choose Freeze Panes in the Window group. The menu includes Freeze Panes, Freeze Top Row, Freeze First Column, and, when a freeze is active, Unfreeze Panes.

How do I freeze the first two rows in Excel?
Select cell A3, then choose View > Freeze Panes > Freeze Panes. Excel freezes every row above the selected cell, so rows 1 and 2 stay visible. If you also need a column frozen, select a cell below and to the right of the desired frozen area.

Can I freeze the top row and first column at the same time?
Yes. Select cell B2 and choose View > Freeze Panes > Freeze Panes. The selection is below row 1 and to the right of column A, so both remain visible while you scroll down or right.

Why is Freeze Panes greyed out?
Check that you are viewing a worksheet and are not currently editing the contents of a cell. Press Enter or Esc to finish editing, then try the View menu again. If the workbook or worksheet has restrictions, those may also affect which commands are available.

Does Freeze Panes work in Excel for Mac or Excel for the web?
Freeze options are also available in Excel for Mac and Excel for the web, although the ribbon layout and menu presentation can differ from Windows. Look on the View tab for Freeze Panes. The core selection rule remains the same: Excel freezes rows above and columns to the left of the selected cell.

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.