Freeze Panes in Excel: 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 a quick option, choose View > Freeze Panes > Freeze Top Row or Freeze First Column.

What Freeze Panes Does

Freeze Panes keeps selected rows, columns, or both in view while you scroll through the rest of a worksheet. The frozen area stays at the top or left edge of the worksheet, while the unfrozen cells move. It is especially useful when a long table has column labels at the top or identifying details, such as names or product codes, in the first columns.

For example, if row 1 contains headings such as Date, Customer, and Amount, freezing the top row keeps those headings visible as you move down the records. If columns A and B contain an employee name and ID, freezing those columns makes it easier to identify each row while scrolling sideways.

Freeze Panes changes how the sheet is displayed; it does not change the data, formulas, or print layout. You can still edit cells in a frozen area, and the setting applies to the current worksheet rather than automatically to every sheet in the workbook.

Before You Freeze Rows or Columns

Decide which labels you need to see while navigating, and check where they are located. Excel freezes rows from the top of the sheet down and columns from the left edge across. You cannot use the feature to keep an isolated row in the middle of a sheet fixed while scrolling past earlier rows; the frozen rows must form a continuous block starting at row 1. The same principle applies to columns starting with column A.

Also make sure the active cell is in the right place before using the custom Freeze Panes command. Excel uses that cell as a boundary: rows above it and columns to its left are frozen. Selecting a cell that is too high or too far left can freeze fewer rows or columns than intended. The cell itself is not frozen as a separate pane; it marks where the movable area begins.

Steps to Freeze the Top Row

Open the worksheet you want to work with.
Select the View tab on the ribbon.
Open the Freeze Panes menu in the Window group.
Choose Freeze Top Row.

Excel keeps row 1 visible as you scroll vertically. This option is convenient when the headings are in the first row, but it always targets row 1. If your headings start on row 3 because the first two rows contain a report title and date, use the custom method instead: select a cell in row 4, then choose Freeze Panes > Freeze Panes to keep rows 1 through 3 visible.

Steps to Freeze the First Column

On the worksheet, select View.
Open Freeze Panes.
Choose Freeze First Column.

Column A remains visible while you scroll horizontally. This is a good fit when the first column contains row labels, names, or IDs. Like Freeze Top Row, this preset only freezes one column. To freeze columns A and B, select a cell in column C and use the main Freeze Panes command rather than Freeze First Column.

Freeze Multiple Rows and Columns Together

Use the active-cell boundary when you want a custom combination of rows and columns. Select the cell immediately below the last row to freeze and immediately to the right of the last column to freeze. Then choose View > Freeze Panes > Freeze Panes. Excel freezes all the worksheet rows above and columns to the left of that cell.

For example, suppose a sales table has headings in row 1 and uses columns A and B for region and salesperson. Select cell C2, then choose Freeze Panes > Freeze Panes. Row 1 and columns A:B stay in place, while the cells starting in column C and row 2 can scroll. To keep the first three rows and first two columns visible, select C4 before using the command.

Take a moment to check the result by scrolling down and to the right. A boundary line in the sheet marks the edge of the frozen area. If the wrong area remains fixed, unfreeze it and repeat the selection with the correct boundary cell.

Change or Remove Frozen Panes

Excel does not add another frozen boundary on top of the existing one when you choose a different Freeze Panes option. First remove the current setting, then create the new one:

Choose View > Freeze Panes > Unfreeze Panes.
Select the boundary cell for the rows and columns you now want to keep visible.
Choose View > Freeze Panes > Freeze Panes.

Unfreeze Panes restores normal scrolling; it does not delete or move cells. If the menu shows Unfreeze Panes as an available command, a freeze setting is active on that worksheet. After changing it, save the workbook if you want the display arrangement to be retained for later use.

Common Problems and How to Fix Them

The wrong rows or columns are frozen. Select Unfreeze Panes, then select the correct cell before applying the custom command. Remember that the cell above and to the left of your selection determines the frozen area.
Freeze Top Row keeps the wrong row. That preset always freezes worksheet row 1, not the row containing the headings you happen to be viewing. Use a custom selection below your actual heading rows.
The whole worksheet seems unable to scroll. Check whether the active cell or scroll position is already inside the frozen section, and try scrolling from the unfrozen area. If the result is still confusing, choose Unfreeze Panes and set it again.
The boundary is hard to notice. Look for the dividing line between the fixed area and the scrolling area. Try moving the vertical or horizontal scrollbar so the effect is visible; frozen rows and columns remain anchored at the top or left.
Only one worksheet has the setting. Freeze Panes is applied per worksheet. Repeat the operation on each sheet where you need it; do not assume that freezing a pane on one tab changes every tab.

A common misconception is that freezing panes locks cells against editing. It does not. Worksheet protection is a separate feature used to restrict editing, while Freeze Panes is only a navigation aid.

Freeze Panes, Split, and Print Titles

Freeze Panes and Split both divide the worksheet view, but they serve different purposes. Freeze Panes keeps a defined top section, left section, or both in place as the rest of the sheet scrolls. Split divides the window into independently scrollable sections, which can help compare distant parts of one worksheet. If you only need headings to stay visible, Freeze Panes is usually the simpler choice. Remove a freeze before using a different viewing arrangement if the existing boundaries interfere with what you want to do.

Neither feature controls what appears on printed pages. If you want heading rows or columns repeated on every printed page, use the separate Print Titles settings on the Page Layout tab. A row frozen for on-screen scrolling is not automatically repeated in print, and changing print titles does not freeze anything on the screen.

Excel for the Web and Mac

In Excel for the web, open the workbook, select the View tab, and use the Freeze Panes menu to choose a freeze option. The same selection principle applies for a custom freeze: select the cell below and to the right of the area to retain, then apply Freeze Panes. The browser interface can differ slightly in appearance from the Windows desktop ribbon, but the row-and-column boundary logic is the same.

In Excel for Mac, use the View tab and its Freeze Panes commands; the exact ribbon layout may look different from Excel for Windows. On either platform, use Unfreeze Panes before replacing an existing freeze. If you are working with a workbook shared between desktop and web versions, check the sheet after switching platforms to confirm the intended area remains visible.

Frequently Asked Questions

Can I freeze more than one row 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. For example, select A4 to freeze rows 1 through 3.

How do I freeze the top two rows and first column?
Select cell B3, then choose View > Freeze Panes > Freeze Panes. Rows 1 and 2 are above B3, and column A is to its left, so those areas remain visible as you scroll.

Can I freeze a row that is not at the top?
Not by itself. Frozen rows always start at row 1 and continue down to the selected boundary. If you select a cell in row 6, Excel freezes rows 1 through 5, not only row 5.

Why is Freeze Panes grayed out?
Check that you are in a worksheet view that supports the command, such as Normal view, and that you have selected a worksheet cell. If the workbook or sheet has restrictions, the available commands can vary. Switching back to Normal view or checking the workbook’s editing restrictions may help.

Does Freeze Panes affect printing?
No. It only changes on-screen scrolling. To repeat headings on printed pages, set Print Titles separately from the Page Layout tab.

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.