Excel Freeze Panes: Freeze More Than Just the Top Row

No—Excel’s Freeze Panes command is not limited to the top row. In Excel for Microsoft 365 on Windows, select a cell and choose View > Freeze Panes > Freeze Panes to keep every row above that cell and every column to its left visible while you scroll.

What Freeze Panes does

Freeze Panes keeps selected worksheet rows or columns in view as you move through the rest of a sheet. The frozen area stays at the top, left, or both edges of the worksheet, while the unfrozen area scrolls. This is useful when a table is wider or longer than the screen and you need to keep its headings or identifying fields visible.

The key is that the general Freeze Panes command uses the active cell as a boundary. Excel freezes the rows above the selected cell and the columns to its left. The selected cell itself is not frozen. For example, selecting B2 freezes row 1 and column A. Selecting D5 freezes rows 1 through 4 and columns A through C.

Freeze Panes changes how the worksheet is displayed; it does not change the data, formulas, or worksheet layout. It also does not lock cells against editing. If you want to prevent people from changing cells, that is a different task involving worksheet protection.

Freeze more than the top row

To keep several heading rows visible, select the first cell below the rows you want to freeze, then use the general Freeze Panes command:

Click the worksheet cell directly below the last row you want to keep visible.
Choose View > Freeze Panes > Freeze Panes.
Scroll down to confirm that the selected rows stay in view.

For instance, if rows 1 and 2 contain a report title and column headings, select A3 before choosing Freeze Panes. Rows 1 and 2 remain visible when you scroll down. If you select A2 instead, only row 1 is above the boundary, so only row 1 freezes.

This differs from the dedicated Freeze Top Row option. That option freezes only the worksheet’s first row, regardless of which cell is selected. It is convenient for a simple table with headings in row 1, but it cannot be used to specify several top rows. To freeze a custom number of rows, use the general Freeze Panes command and choose the boundary cell carefully.

Freeze rows and columns together

You can freeze both a set of top rows and a set of left-hand columns at the same time. Select the cell one row below the final row to freeze and one column to the right of the final column to freeze. Then choose View > Freeze Panes > Freeze Panes.

Suppose a worksheet has headings in row 1 and employee names in column A. Select B2 to freeze row 1 and column A. When you scroll downward, the headings stay visible; when you scroll to the right, the employee names remain visible. For a sheet with two heading rows and two identifying columns, select C3. That freezes rows 1 and 2 and columns A and B.

Think of the selection as the upper-left corner of the area that will continue to scroll. Everything above it and to its left becomes the frozen section. If the result is not what you intended, unfreeze the panes and make a new selection rather than repeatedly clicking the dedicated top-row or first-column options.

Choose the right freeze option

The Freeze Panes menu offers quick options as well as the selection-based option. Choose based on how the worksheet is organized:

Freeze Top Row: Keeps row 1 visible while you scroll vertically. Use it when the column headings are in the first row and you do not need to keep any columns fixed.
Freeze First Column: Keeps column A visible while you scroll horizontally. It is useful when that column contains names, dates, or other row identifiers.
Freeze Panes: Freezes rows above and columns to the left of your selected cell. Use this for multiple heading rows, multiple identifier columns, or a combination of both.
Unfreeze Panes: Removes the current freeze so you can set a different boundary or return to ordinary scrolling.

A practical choice is to keep only the information you need for orientation. Freezing a large block can leave too little space for the scrolling area, especially on a small display. For a typical data table, one header row and one identifier column may be enough; a report with stacked headings may need more.

Why Freeze Panes may seem limited to one row

The most common source of confusion is selecting Freeze Top Row instead of Freeze Panes. The dedicated option does exactly what its name says: it fixes row 1, not a custom number of rows. If you need rows 1 through 3, select a cell in row 4 and use the general Freeze Panes command.

Another common issue is making a selection in the wrong position. If you want to freeze rows 1 through 3 and column A, select B4. Selecting A4 freezes the rows above row 4 but no columns, because there are no columns to the left of column A. Selecting B3 freezes only rows 1 and 2 plus column A.

If the menu shows Unfreeze Panes, a freeze is already active on the current worksheet. Excel does not layer a new freeze on top of the old one. Choose Unfreeze Panes first, then select the new boundary cell and apply Freeze Panes again. This is the normal way to replace an existing arrangement.

Also check that you are scrolling in the unfrozen part of the sheet. Frozen rows or columns do not move, so a small scroll may appear to do nothing if the pointer or scroll action is over a frozen section. Try scrolling in the main worksheet area. If the worksheet is divided into separate scrolling regions, you may be using Split rather than Freeze Panes.

Freeze Panes versus Split

Freeze Panes and Split both divide the worksheet display, but they serve different purposes. Freeze Panes anchors a chosen top section, left section, or both, while the rest of the sheet scrolls. Split creates separate worksheet panes that can be scrolled independently. It is useful when you want to compare distant parts of a sheet at once, rather than keep headings fixed as a reference.

For example, freeze the heading row when you need to read records farther down a table and still see what each column means. Use a split when you want to inspect an upper section and a lower section at the same time, with each view positioned independently. If a worksheet appears to have a movable divider or multiple independently scrolling areas, check View for the Split command and turn it off if that is not what you intended.

Neither feature changes the underlying cells. They affect the on-screen view, not the print layout. A frozen heading is not automatically repeated on every printed page; printing repeated headings requires the separate print-title settings.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Windows, use the View tab and its Freeze Panes menu. Excel for Mac also provides Freeze Panes from the View controls, although the exact placement can vary with the ribbon layout and application version. The selection rule is the same: the command freezes rows above and columns to the left of the active cell. If you have customized or simplified the ribbon, look under View for the freeze controls.

Excel for the web includes freeze controls on the View tab as well. Its available options and menu presentation can differ slightly from the desktop app, but you can use the same general approach: select the boundary cell, then apply Freeze Panes. If a particular control is missing or behaves differently in your current browser interface, opening the workbook in the desktop app is a useful way to access the full desktop ribbon and confirm the setting.

Freeze settings apply to the worksheet view, so check the relevant sheet when working in a workbook with several tabs. Freezing panes on one worksheet does not mean that every other worksheet will use the same boundary. It is also worth saving the workbook after arranging views you want to retain.

When freezing is not the right solution

Freeze Panes is best for keeping context visible while navigating a large worksheet. If the problem is that the headings should appear on printed pages, use the print-title feature instead: on Windows, open Page Layout > Print Titles and set rows to repeat at the top or columns to repeat at the left. Print titles affect printed output; Freeze Panes affects the worksheet view.

If you need to keep a table’s headings visible while filtering or analyzing records, consider converting the data range into an Excel table using Insert > Table. A table provides structured features such as filter controls and can keep its header row available as you work in the table, but it does not replace custom Freeze Panes for multiple rows or left-side columns. Choose the feature that fits the task: navigating, printing, or managing a data table.

Frequently Asked Questions

Can I freeze two or more rows in Excel?
Yes. Select a cell in the row immediately below the last row you want to keep visible, then choose View > Freeze Panes > Freeze Panes. Selecting A3, for example, freezes rows 1 and 2.

How do I freeze the top two rows and the first column?
Select B3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 are above the selection, and column A is to its left, so all three remain visible.

Why is Freeze Panes greyed out or not doing anything?
First check whether the sheet is already frozen and use Unfreeze Panes before setting a new boundary. Then select a cell in the worksheet and apply the general Freeze Panes command. If you see separate scrolling regions, check whether Split is active.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. This removes the current frozen boundary on that worksheet; it does not delete or move any worksheet data.

Does freezing the top row make it repeat when I print?
No. Freeze Panes controls the on-screen worksheet view. To repeat headings on printed pages, use Page Layout > Print Titles and configure the rows or columns to repeat.

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.