Freeze Panes in Excel: Keep Rows and Columns Visible

To freeze rows or columns in Excel for Microsoft 365 on Windows, select the cell below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes. To remove the setting, choose View > Freeze Panes > Unfreeze Panes. The frozen area stays on screen while you scroll through the rest of that worksheet.

What Freeze Panes Does

Freeze Panes keeps selected rows at the top of the worksheet, selected columns at the left, or both in view as you move elsewhere in the sheet. It is useful when a worksheet is wider or longer than the screen and you need its labels for context. For example, a sales sheet might have hundreds of rows of transactions but use row 1 for headings such as Date, Region, and Sales. Freezing the top row keeps those headings visible while you scroll down.

Freezing changes how the worksheet is displayed; it does not rearrange, lock, or protect cells. You can still edit frozen cells if the sheet allows editing. It also does not repeat headings on printed pages. For that, use the separate print setting called Print Titles.

Freeze the Top Row or First Column

Excel has quick commands for the most common cases. In the Windows desktop app, open the View tab, select Freeze Panes, and choose one of these options:

Freeze Top Row keeps row 1 visible while you scroll vertically.
Freeze First Column keeps column A visible while you scroll horizontally.

These options are convenient when the labels really are in the first row or first column. If your headings start lower down—for instance, because the worksheet has a title and a blank row above them—Freeze Top Row will keep the wrong row visible. Use the custom Freeze Panes command instead, selecting the appropriate cell first.

A worksheet has one freeze configuration at a time. If you want the top row and first column frozen together, do not apply the two quick commands one after the other and assume they will combine. Set both at once with a selected cell, as described below.

Freeze Several Rows, Columns, or Both

The selected cell determines which rows and columns Excel freezes. It freezes every row above the selection and every column to its left. The selected cell itself is not part of the frozen area. To set a custom freeze:

Click the worksheet cell immediately below the rows you want to keep visible and immediately to the right of the columns you want to keep visible.
Choose View > Freeze Panes > Freeze Panes.
Scroll down or across to confirm that the intended labels remain visible.

For example, select A4 to freeze rows 1 through 3, with no columns frozen. Select C1 to freeze columns A and B, with no rows frozen. Select C4 to freeze rows 1 through 3 and columns A and B together. This makes C4 a useful example when a report has three heading rows and two identifying columns.

Excel freezes rows from the top of the worksheet and columns from the left. You cannot use Freeze Panes to keep an arbitrary middle row or middle column visible while scrolling in both directions. Choose the selection based on the continuous top rows and left columns that should remain in view.

Unfreeze Panes and Change the Setup

To remove a freeze, choose View > Freeze Panes > Unfreeze Panes. The worksheet returns to ordinary scrolling. To create a different arrangement, unfreeze the current panes, select the new cell, and choose Freeze Panes again. This is a reliable way to reset the layout before making a change, especially if you are unsure what has already been frozen.

For example, suppose a worksheet currently freezes the first row, but you now want its first two rows and first column to stay visible. Unfreeze the existing setup, select B3, and choose Freeze Panes. Rows 1 and 2 and column A will then stay in view. If the result is not what you intended, unfreeze and check the selected cell: the row above and column to the left are the parts Excel freezes.

Freezing is a worksheet view setting rather than a permanent change to the data. It does not delete content, change formulas, or affect the order of records. You can unfreeze it at any time without altering the worksheet’s values.

Freeze Panes in Excel for Mac and the Web

In Excel for Mac, use the View tab and its Freeze Panes controls to freeze the top row, first column, or panes based on the selected cell. The selection rule is the same: choose the cell below and to the right of the area to keep visible. To remove the freeze, use the Unfreeze Panes command in the same controls. Ribbon layout and wording can differ slightly between Excel releases, so look under View if the control is not immediately visible.

In Excel for the web, open the View tab and use Freeze Panes. Depending on the current layout and available commands, you can freeze the top row, first column, or panes around the selected cell, and use the unfreeze command to clear the setting. The browser version may present the controls differently from the Windows desktop ribbon, but the basic selection logic is unchanged.

Freeze Panes is not a Windows-only shortcut feature; use the ribbon or View controls to avoid relying on a key sequence that may vary by platform or ribbon configuration. If you are working in a shared workbook, check the worksheet after changing the view so that the freeze arrangement is useful to people who open it on a different screen size.

Freeze Panes Compared with Split and Hide

Freeze Panes is often confused with Split, but they solve different viewing problems. Freeze Panes keeps specified top rows and left columns in place while the rest of the worksheet scrolls. Split divides the worksheet window into separate panes that can be scrolled independently. A split can help compare distant areas of a large sheet, but it does not simply pin the labels in the way a frozen header does. If you accidentally create separate scrolling areas, check View for the Split control and turn it off, or use Unfreeze Panes if the sheet has a freeze setting.

Hiding rows or columns is different again. Hidden cells are not displayed until you unhide them; frozen cells remain visible and can still be selected. Use hiding to temporarily remove details from view, not as a substitute for keeping useful labels on screen. Likewise, sheet protection controls what users can change; freezing panes does not prevent edits.

Common Problems and Practical Checks

If the wrong area stays visible, the most common cause is selecting the wrong cell before choosing Freeze Panes. Unfreeze, identify the last row and column that should remain visible, then select the cell just below and to the right of them. For example, to keep rows 1–5 and columns A–C in view, select D6 before freezing.

The header disappears while scrolling: Confirm that the intended row is actually at the top of the frozen area. If the header is on row 4, select a cell in row 5 rather than using Freeze Top Row.
Only the row or column stays fixed: A quick command may have been used. Unfreeze, then select a cell that defines both the desired rows and columns.
The worksheet looks divided: Check whether Split is enabled. Split creates independently scrollable sections and is not the same as a freeze.
The freeze line is hard to interpret: Look for the thin boundary separating frozen cells from the scrolling area. Scroll vertically and horizontally to verify what is fixed.
Printed pages still lack headings: Freeze Panes affects on-screen scrolling only. Set repeating print rows or columns through Page Layout > Print Titles instead.

Consider screen space when freezing multiple rows and columns. A very tall frozen header or several wide frozen columns leave less room for the records you are trying to inspect. Freeze only the labels that readers need for orientation, and test the result at a typical window size.

When Freeze Panes Is Most Useful

Freeze panes are most valuable in worksheets where labels would otherwise scroll away from the data they describe. Common examples include inventory lists with product names in column A, schedules with dates across the top, and reports with both column headings and identifiers at the left. In a wide table, freezing the first one or two columns can make it easier to tell which record each number belongs to. In a long table, freezing a header row helps distinguish fields such as Quantity from Price.

For structured data, keep the worksheet layout simple and place column headings in one clear row when possible. Excel tables also provide built-in filtering and structured formatting, but they do not make Freeze Panes unnecessary in every large worksheet. The best choice depends on whether you need labels to remain visible during scrolling, filters to narrow records, or both.

For a paper or PDF report, use print titles rather than relying on a frozen view. For comparing distant sections on screen, consider Split. For making a worksheet easier to navigate, you can also use the Name Box to jump to a cell or use Find to locate text. These features complement freezing but do not pin headings while you scroll.

Frequently Asked Questions

Can I freeze the top two rows in Excel?
Yes. Select a cell in row 3, such as A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible because they are above the selected cell.

How do I freeze the top row and first column at the same time?
Select B2, then choose View > Freeze Panes > Freeze Panes. The row above and column to the left—row 1 and column A—will stay visible. Unfreeze any existing setup first if you need to replace it.

Why is Freeze Panes greyed out?
Check that you are in a worksheet view where the command is available, and that you have selected a worksheet cell rather than an object such as a chart. If the workbook or sheet has restrictions, check whether its current state limits changes. Switching to the Normal worksheet view and reopening View can also help identify a view-related issue.

Does freezing panes affect printing?
No. It changes the on-screen worksheet view, not printed page layout. To repeat headings on printed pages, set Print Titles from the Page Layout tab.

Can I freeze a row in the middle of a worksheet?
Not as a standalone row while the rows above it scroll away. Freeze Panes keeps continuous rows from the top and continuous columns from the left. To keep a particular record visible, consider splitting the window or arranging the data differently.

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.