Excel Freeze Panes Button: Where It Is and How to Use It

In Excel for Microsoft 365 on Windows, find the Freeze Panes button on the View tab, in the Window group. Select a cell below the rows and to the right of the columns you want to keep visible, then choose View > Freeze Panes > Freeze Panes; Excel keeps the rows above and columns to the left of that cell on screen while you scroll.

Where to Find the Freeze Panes Button

Open the worksheet and select the View tab on the ribbon. In the Window group, choose Freeze Panes. The button opens a menu with three main choices: Freeze Panes, Freeze Top Row, and Freeze First Column. Depending on the window size or ribbon layout, the group may be compressed, so the button can appear as a smaller icon or inside a compact group.

The first menu choice, Freeze Panes, uses the active cell to determine the boundaries. The other two are quick options for common cases: keeping row 1 visible or keeping column A visible. These options affect the current worksheet, not every sheet in the workbook at once. To set up another sheet, activate it and configure its panes separately.

In Excel for Mac, look on the View tab for Freeze Panes; the exact ribbon arrangement can vary with the window and version. Excel for the web also provides freeze options from the View tab. If the ribbon looks different, check that the workbook is open in Excel rather than a preview or another spreadsheet application.

What Freeze Panes Does

Freeze Panes keeps selected worksheet rows or columns in view as you move through the rest of the grid. It does not pin information to the edge of the computer screen independently of the worksheet, and it does not stop the sheet from scrolling. Instead, Excel divides the worksheet into scrollable and stationary areas. This is especially useful when labels or headings are far from the cells being reviewed.

For example, imagine a sales sheet with months across row 1, product names in column A, and hundreds of records below. Freezing the top row keeps the month headings visible while you scroll down. Freezing the first column keeps product names visible while you move across many months. A custom freeze can preserve both a set of heading rows and one or more identifier columns.

Freezing is a viewing aid, not a protection feature. It does not lock cells against editing, prevent someone from changing values, or restrict scrolling through the unfrozen part of the sheet. Those are separate tasks: worksheet protection controls editing permissions, while Freeze Panes controls what remains visible during navigation.

How to Freeze Custom Rows and Columns

To freeze a custom combination, 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. The selected cell itself is not frozen; the boundary is above it and to its left.

To keep rows 1 and 2 visible, select a cell in row 3.
To keep column A visible as well, select B3.
Choose View > Freeze Panes > Freeze Panes.
Scroll down and across to confirm that the intended headings and identifiers remain in place.

This boundary rule makes it possible to freeze multiple rows and multiple columns. For instance, to keep rows 1 through 4 and columns A through C visible, select D5 before using Freeze Panes. If the wrong area stays visible, the usual cause is selecting the wrong row or column boundary—not a failure of the feature.

Choosing Between the Three Options

Choose the option that matches the structure of the worksheet rather than freezing panes automatically. The top row is a common location for field names, but a report may have a title and several header rows above its data. In that case, Freeze Top Row preserves only row 1; use the custom option to keep all relevant heading rows visible.

Freeze Top Row: Use this when row 1 contains the headings you need while scrolling vertically.
Freeze First Column: Use this when column A contains names, dates, product codes, or other identifiers you need while scrolling horizontally.
Freeze Panes: Use this for a chosen boundary, including combinations of several rows and columns.

Consider a worksheet where rows 1 and 2 contain a report title and column labels, while column A lists employee names. If you only use Freeze Top Row, the column labels in row 2 will scroll away. Selecting B3 and choosing Freeze Panes preserves both rows 1 and 2 and column A. If the title row is tall or not useful during data entry, you might instead choose a boundary that preserves only the labels and identifiers you actually need.

How to Unfreeze or Change the Panes

To remove a freeze, go to View > Freeze Panes > Unfreeze Panes. The worksheet returns to normal scrolling. Unfreeze first if you want to replace one arrangement with another; then select the new boundary cell and apply Freeze Panes again. You can also switch to Freeze Top Row or Freeze First Column after removing the existing freeze.

If the Unfreeze Panes command is available in the menu, a freeze is currently applied to that sheet. Once unfrozen, the menu may offer the freeze choices again. Changing a freeze does not delete data or alter formulas; it changes how the worksheet is divided for viewing. Save the workbook if you want the updated layout retained with your work.

When a worksheet contains several frozen rows or columns, Excel marks the division with a line in the grid. Look for that boundary if you are unsure what is currently frozen. The line can be subtle, particularly with certain display settings or when the frozen area is narrow.

Common Problems and Their Fixes

If the wrong rows or columns are frozen, unfreeze the panes and select the correct boundary. Remember that Excel freezes everything above and to the left of the active cell, not the active cell itself. For example, selecting A3 freezes rows 1 and 2 but no columns; selecting C1 freezes columns A and B but no rows.

If the button is missing, first check the View tab and look for a collapsed Window group. A narrow Excel window can hide text labels, and a customized ribbon may place commands differently. Maximizing the window or expanding the group can make the command easier to find. Also confirm that you are working in a worksheet: freeze panes are for worksheet grids, not chart sheets.

If the freeze seems to stop working, check whether you are scrolling in the unfrozen area or have switched to another worksheet. Each sheet can have its own pane arrangement. If the visible area is not the one you expected, inspect the selection boundary and unfreeze before setting it again. In Excel for the web or Mac, menu placement can differ slightly, but the same principle applies: choose the cell boundary first, then apply the freeze command.

A related misconception is that freezing the top row keeps it visible in a printed copy. Freeze Panes changes the on-screen view; it does not set print titles. To repeat headings on printed pages, use the separate print settings for repeating rows or columns. Likewise, freezing panes does not create a filter, sort records, or keep headings visible in every exported format.

Freeze Panes Compared with Split

Split is a nearby View feature, but it serves a different purpose. A split divides the worksheet window into independently scrollable sections, allowing you to view different parts of the same sheet at once. Freeze Panes instead keeps specified rows or columns stationary while the remaining area scrolls. Use a split when comparing distant sections simultaneously; use a freeze when you want headings or identifiers to remain visible as you navigate.

For a large table, a split is usually not a substitute for a useful freeze: the separate panes may require their own scrolling and can make the layout harder to follow. For reviewing a formula near the bottom while keeping an unrelated reference area in view, a split may be more suitable. You can remove a split from the View tab, just as you can remove a freeze, but the two commands should not be confused.

Frequently Asked Questions

Where is Freeze Panes in Excel?
On Windows, open the View tab and look in the Window group for Freeze Panes. The menu includes options to freeze the top row, the first column, or a custom area based on the selected cell.

How do I freeze the top two rows in Excel?
Select any cell in row 3, such as A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible. The dedicated Freeze Top Row command freezes only row 1.

How do I freeze the first row and first column together?
Select cell B2, then choose View > Freeze Panes > Freeze Panes. Row 1 is above the selection and column A is to its left, so both remain visible while you scroll.

Why is Freeze Panes greyed out?
Check that you are in a worksheet and not editing a cell or viewing a chart sheet. Also check the workbook or sheet state and whether the ribbon is available in the current view. In a shared or restricted file, some commands may be unavailable; if so, try an editable worksheet copy or consult the workbook owner.

Does Freeze Panes work in Excel for Mac and the web?
Yes. Both offer freeze options, generally from the View tab, though the ribbon layout and exact placement can vary. The selection rule is the same: choose a cell below and to the right of the rows and columns to keep visible, then apply Freeze Panes.

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.