Excel Freeze Panes: Keep Rows and Columns Visible

To freeze panes 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. For example, select C4 to keep rows 1–3 and columns A–B on screen while you scroll through the worksheet.

What Freeze Panes does

Freeze Panes keeps selected rows, columns, or both in view as you scroll elsewhere in the same worksheet. It is especially useful when a worksheet is taller or wider than the visible window. You can continue moving through the data while its headings or identifying fields remain visible, which makes it easier to understand what each number or record represents.

Freezing changes the worksheet’s view, not its contents. It does not lock cells against editing, protect data, or prevent rows and columns from being changed. Those are separate tasks: use worksheet protection when you need to restrict editing, and use Freeze Panes when you want labels to stay visible during navigation.

The feature works with continuous rows starting at the top of the sheet and continuous columns starting at the left. You cannot use it to keep an isolated row in the middle visible while scrolling past it, or to pin a few unrelated columns while letting columns between them scroll.

How to freeze rows and columns

First decide what should stay on screen. Then select the cell where the scrolling area should begin. Excel freezes all rows above that cell and all columns to its left. The selected cell itself is not frozen.

Click the worksheet 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.
Open the View tab on the ribbon.
Choose Freeze Panes, then choose Freeze Panes again from the menu.
Scroll down or sideways to confirm that the intended rows and columns remain in place.

For example, selecting C4 freezes rows 1 through 3 and columns A and B. Selecting A2 freezes only row 1, while selecting B1 freezes only column A. A selection at B2 freezes both the top row and the first column.

Excel also offers preset options in View > Freeze Panes: Freeze Top Row and Freeze First Column. These are convenient when the only target is the worksheet’s first row or first column. If your headings begin lower down, or you need a combination such as three heading rows and one identifier column, use the general Freeze Panes command with a carefully chosen cell instead.

How to choose the right cell

The cell-selection rule is the key to getting a custom layout right: the boundary is immediately above and to the left of the selected cell. Count the rows and columns that should remain visible, then move one cell down and one cell right from the frozen area.

Keep one header row: Select A2, then choose View > Freeze Panes > Freeze Panes, or use Freeze Top Row.
Keep the first two rows: Select A3 and choose Freeze Panes.
Keep the first column: Select B1 and choose Freeze Panes, or use Freeze First Column.
Keep two columns and one row: Select C2 and choose Freeze Panes.
Keep several title and header rows plus an ID column: If rows 1–4 and column A should remain visible, select B5.

A frequent source of confusion is selecting the row or column that should stay visible rather than the cell beyond it. If you want rows 1–3 frozen, selecting A3 freezes only rows 1–2; select A4 instead. If the result is off by one, unfreeze and repeat with the boundary cell adjusted.

Practical examples for real worksheets

In a sales report, the first row might contain headings such as Date, Region, Product, and Revenue. Freezing row 1 lets you scroll through hundreds of transactions without losing the column labels. If rows 1 and 2 contain a report title and a second line of headings, select A3 to keep both rows visible.

In a wide inventory sheet, column A might contain a product code while later columns hold supplier, quantity, location, and monthly totals. Freeze column A so that the code remains beside each visible record as you scroll horizontally. If the product code and product name occupy columns A and B, select C1 to keep both in view.

For a worksheet with both long records and many fields, freeze a top heading row and one or more identifying columns together. For example, if row 1 has field names and columns A and B identify an employee, select C2. Scrolling down keeps the field names visible; scrolling right keeps the employee identifiers visible. This can make a large worksheet substantially easier to read without changing its layout or duplicating labels.

Before freezing, consider whether the frozen area will leave enough room for the data on screen. Freezing six rows and four columns may be appropriate on a large monitor but leave little space in a small window. A useful layout usually retains only the context needed to identify the visible cells.

What happens while you scroll

After panes are frozen, Excel separates the worksheet into a stationary area and a scrolling area. A horizontal divider marks the boundary below the frozen rows, and a vertical divider marks the boundary to the right of the frozen columns. The dividers may appear as thin gray lines. Scroll within the unfrozen area to move through the worksheet; the frozen section remains visible.

Freeze Panes applies to the active worksheet, not automatically to every sheet in the workbook. If several worksheets need the same view, set up each one separately. The freeze setting is a view arrangement saved with the workbook, so a person opening the file may see the same frozen layout, although their screen size and zoom level affect how much of the sheet is visible.

Freezing panes also does not change printing. A row kept on screen while scrolling is not automatically repeated at the top of printed pages. To repeat headings on printouts, use the separate Print Titles setting on the Page Layout tab. Similarly, freezing a table’s header is a view choice; it does not change the table’s filters, sorting, or data structure.

Freeze Panes versus Split

Freeze Panes and Split can look similar because each can display divider lines, but they serve different purposes. Freeze Panes anchors rows at the top and columns at the left while the rest of the worksheet scrolls. Split divides the window into sections that can be scrolled independently, which can help compare distant parts of the same sheet.

For example, freeze the top row when you want headings to remain in place while reviewing lower records. Use a split when you need two independently movable views of different areas, such as comparing the top and bottom of a long worksheet. Split is available from View > Split. It is not a way to pin arbitrary rows or columns, and it can be less straightforward for everyday data browsing.

If the worksheet shows dividers that behave unexpectedly, check whether Split rather than Freeze Panes is active. Turn off the split from View > Split, then apply the freeze arrangement you want. Avoid treating the two features as interchangeable: the choice depends on whether the goal is a fixed heading area or separately scrollable sections.

Unfreezing panes and fixing common problems

To remove a freeze, choose View > Freeze Panes > Unfreeze Panes. This returns the worksheet to ordinary scrolling; it does not delete or move any cells. You can then select a different boundary cell and freeze a new arrangement. Excel allows one freeze arrangement per worksheet at a time, so choosing a new one replaces the previous setup.

If Freeze Panes is unavailable or the command does not behave as expected, check these common causes:

You are editing a cell: Finish the edit with Enter or cancel it with Esc, then try the command again.
The wrong cell was selected: Remember that everything above and left of the selected cell is frozen. Use the cell one row down and one column right from the area to retain.
An existing freeze is active: Choose Unfreeze Panes first if you want to start over or switch to a different layout.
You used a preset unintentionally: Freeze Top Row means worksheet row 1, not the first visible row after scrolling. Use the custom command for other rows.
The divider is a split: Check View > Split and turn it off if the sections scroll independently.

It is also worth checking the worksheet’s zoom and the size of the Excel window. A freeze can be working correctly but still leave too little space to see useful data if too many rows or columns are anchored. Reduce the frozen area or adjust the window rather than expecting the frozen section to shrink automatically.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Mac, the same basic selection rule applies: select the cell below and to the right of the area to keep, then use View > Freeze Panes. The View tab includes options for freezing panes, the top row, or the first column. The ribbon’s appearance can differ from Windows, but the underlying worksheet behavior is the same.

In Excel for the web, open the workbook in a browser, select the appropriate cell, and use View > Freeze Panes. The available commands and exact presentation can vary as Microsoft updates the web app, but the custom selection follows the same boundary principle. If a command is missing in a particular view, open the workbook in the desktop app and set the freeze there.

There is no need to memorize a keyboard shortcut to use this feature: the reliable route is the View tab. Windows ribbon access-key sequences can depend on the version and ribbon state, so menu navigation is less error-prone when giving instructions to someone using a different setup. On Mac, use the View menu or ribbon rather than assuming Windows key combinations apply.

Frequently Asked Questions

Can I freeze more than one row or column in Excel?
Yes. Select the cell immediately below all the rows and immediately to the right of all the columns you want to retain, then choose View > Freeze Panes > Freeze Panes. For instance, select D4 to freeze rows 1–3 and columns A–C.

Why does Freeze Top Row keep the wrong row visible?
Freeze Top Row always freezes worksheet row 1, even if your actual headers are lower in the sheet. To keep rows 1 through 4 visible, select A5 and use the general Freeze Panes command instead.

Can I freeze a row in the middle of a worksheet?
Not independently. Freeze Panes keeps a continuous block from the top and/or left edge. It cannot pin row 20 while rows 1–19 scroll away. If you need to compare distant areas, consider View > Split or open another window of the workbook.

Does freezing panes protect cells from editing?
No. It only keeps a portion of the worksheet visible while scrolling. To limit editing, use Excel’s worksheet protection options; freezing panes alone does not stop anyone from changing values.

Will frozen headings repeat when I print?
No. Freeze Panes affects the on-screen view, not printed page layout. To repeat heading rows on printed pages, use Page Layout > Print Titles and configure the rows to repeat at the top.

How do I remove frozen panes?
Choose View > Freeze Panes > Unfreeze Panes. The sheet returns to regular scrolling, and all cell data remains unchanged. You can then apply a different freeze arrangement if needed.

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.