Freeze and Unfreeze Panes in Excel: A Step-by-Step Guide

To keep headings or identifying columns visible while you scroll in Excel, select the cell just below the rows and just to the right of the columns you want to keep on screen, then choose View > Freeze Panes > Freeze Panes. To remove the freeze, choose View > Freeze Panes > Unfreeze Panes. Freezing changes how the sheet displays as you move around; it does not change, lock, or protect your data.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365 on Windows. The steps are similar in recent desktop versions of Excel.
A clear idea of which header rows or identifying columns you need to see while scrolling. Excel freezes rows from the top and columns from the left, so decide how many of each you want to keep visible.
Access to the worksheet you want to adjust. Freeze settings apply to the active worksheet, not every sheet in the workbook.

Step-by-Step

Open the worksheet and check its layout. Click the sheet tab that contains the data. If the sheet has a title row, column headings, or names at the left, decide which of those should stay visible. For example, if row 1 contains a report title and row 2 contains column headings, you may want to keep both rows visible. If column A contains employee names, you may want to keep that column visible as well.
Choose the right starting cell for a custom freeze. Click 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. Excel will freeze all rows above the selected cell and all columns to its left. The cell itself is not frozen as part of either group. For example, to keep rows 1 and 2 and column A visible, select B3. To keep the top three rows only, select A4. To keep columns A and B only, select C1.
Open the Freeze Panes menu. On the Windows ribbon, select the View tab, then choose Freeze Panes in the Window group. If the Excel window is narrow, the command may appear in a compact group or menu, but it remains on the View tab. Make sure you are on the intended worksheet before applying the command.
Apply a custom freeze, or use a preset. To freeze the rows and columns determined by your selected cell, choose Freeze Panes from the menu. To keep just the first row visible, choose Freeze Top Row instead. To keep just the first column visible, choose Freeze First Column. The presets are convenient when your headings are in row 1 or your identifiers are in column A; they are not the right choice when you need to freeze multiple rows or columns.
Check the result by scrolling. Scroll down to see whether the chosen rows stay at the top, then scroll right to check the chosen columns. A thin line on the worksheet marks the boundary between frozen and scrolling areas. If you froze both rows and columns, the top-left section remains in place while the rest of the sheet moves. Use the scroll bars or your mouse wheel to check both directions.
Adjust the freeze if the wrong area stays visible. Excel does not let you drag the boundary to change a freeze. Select View > Freeze Panes > Unfreeze Panes, then click the correct starting cell and apply Freeze Panes again. This reset-and-reapply approach is usually faster than trying different commands without clearing the existing setting first.
Unfreeze panes when you no longer need them. On the worksheet with the frozen area, open View > Freeze Panes and choose Unfreeze Panes. The worksheet returns to normal scrolling. Your cell values, formulas, formatting, and saved data remain unchanged. If other worksheets have freezes, repeat the command on each one separately.

Common Mistakes

Selecting the row or column you want to freeze instead of the cell after it. For a custom freeze, Excel uses the active cell as a boundary. Selecting B3 freezes rows 1 and 2 and column A; it does not freeze row 3 or column B. If the wrong number of rows or columns stays put, unfreeze and choose a cell one row lower or one column farther right as needed.

Using a preset when the headings are not in the first row or column. Freeze Top Row always freezes row 1, even if your actual table headings are in row 4. Freeze First Column always freezes column A. For headings lower down or identifiers farther right, select the appropriate cell and use Freeze Panes.

Expecting to freeze a non-contiguous area. A single freeze can keep a continuous block of top rows and left columns visible. It cannot freeze, for example, row 1 and row 4 while letting rows 2 and 3 scroll, or freeze column A and column D while B and C scroll. Reorganize the sheet if a continuous frozen area cannot meet your needs.

Confusing Freeze Panes with Split. Split divides the worksheet into independently scrolling sections. It is a different View feature and can make the screen seem to have multiple movable panels. If the sheet scrolls in unexpected sections, check View for Split and turn it off, then set the freeze again if needed. Freeze panes is intended to keep the selected top rows and left columns in place as the rest of the sheet scrolls.

Assuming the setting applies to the whole workbook. Freeze settings are per worksheet. Applying a freeze on a summary sheet does not automatically freeze the detail sheets. Likewise, unfreezing one sheet will not remove freezes on the others.

Tips

Freeze both headings and labels for wide lists. In a data table with headings in row 1 and names in column A, select B2 and choose Freeze Panes. You can then scroll down through records while keeping the headings at the top, or scroll right through fields while retaining the names. If you have two header rows, select B3 instead.

Use the simplest option that fits. If only the top row needs to remain visible, Freeze Top Row is less error-prone than calculating a custom selection. If only the first column matters, use Freeze First Column. Use the custom option when you need multiple rows, multiple columns, or both.

Keep the frozen block small. Freezing many rows or columns leaves less room for the portion of the worksheet that scrolls. On a small laptop display, keeping just the column headings and one identifying column is often easier to work with than freezing a large title block.

Freeze before navigating far into the data. You can usually apply a freeze from any active cell, but choosing the intended boundary deliberately makes the result easier to predict. If the top-left portion of your sheet is unusual or includes blank rows, check the selection and the on-screen boundary before continuing your work.

Know where the commands are on other platforms. In Excel for Mac, use the View tab and its Freeze Panes controls; the labels are similar, though the ribbon layout can differ. In Excel for the web, open View and use Freeze Panes. The available choices and exact menu presentation can vary with the browser window and updates, so check the on-screen choices. The key rule remains the same: for a custom freeze, select the cell below and to the right of the area to hold in place.

Save normally after arranging the view. Freezing panes is a worksheet view setting, not an edit to the underlying values. Save the workbook if you want to retain your changes, and verify the result after reopening or sharing it if the frozen layout matters to other people using the sheet.

Troubleshooting

The wrong rows or columns are frozen. First select View > Freeze Panes > Unfreeze Panes. Then calculate the boundary again: to freeze through row 5, select a cell in row 6; to freeze through column C, select a cell in column D. For both, select a cell below and to the right of the desired frozen area, such as D6 to freeze rows 1–5 and columns A–C. Choose Freeze Panes, not one of the presets.

The Freeze Panes command is unavailable or behaves unexpectedly. Confirm that you are in a worksheet rather than another workbook view, and that the correct sheet is active. If the workbook is in a special view or the ribbon is collapsed, switch to the standard worksheet view and expand the View controls. Some protected or shared-workbook situations can restrict changes; if you cannot change the view, ask the workbook owner or check the workbook’s protection and collaboration settings.

The sheet appears to have multiple scrolling areas. Look for a split line or separate scroll bars. Choose View > Split to turn off a split if it is active, then use Unfreeze Panes and set the desired freeze again. The two features can produce similar-looking dividing lines, but a split allows panes to scroll independently.

The headings disappear when scrolling. Check whether the headings are actually in row 1. If they begin lower down, the Freeze Top Row preset will not hold them in place. Unfreeze, select the cell directly beneath the last heading row, and choose Freeze Panes. If the selected cell was in the wrong column, correct that too so the appropriate left-hand columns stay visible.

You cannot find Unfreeze Panes. Open the View tab on the same worksheet where the panes were frozen. The Freeze Panes menu may display Unfreeze Panes as an available command only when that sheet has a freeze applied. If you do not see it, the current sheet may not have frozen panes, or you may be looking at a different worksheet.

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. To keep rows 1 through 3 visible, select a cell in row 4 first.

Can I freeze a row and a column at the same time?
Yes. Select the cell below the rows and to the right of the columns you want to keep visible. For example, select C2 to freeze row 1 and columns A and B, then choose Freeze Panes.

How do I unfreeze only the top row but keep a frozen column?
Excel’s Unfreeze Panes command removes the current freeze rather than removing just one part of it. Unfreeze the sheet, then set a new custom freeze for the column or rows you still want to keep visible.

Does freezing panes lock cells or stop people editing them?
No. Freezing only keeps part of a worksheet visible while scrolling. To restrict editing, use worksheet protection; that is separate from the Freeze Panes command.

Will frozen panes print on every page?
No. Freezing panes affects the on-screen worksheet view, not printed page headings. To repeat headings on printed pages, use the print-title settings on the Page Layout tab rather than Freeze Panes.

Can I use Freeze Panes in Excel for the web or on a Mac?
Yes. Excel for the web and recent Excel for Mac versions include Freeze Panes controls on the View tab. The interface may differ slightly from Windows, but the custom selection rule is the same. If a command is not visible, check the View tab or the ribbon’s overflow controls.

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.