Excel 2016: How to Freeze Panes and Keep Headers Visible

In Excel 2016, 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. To freeze only the top row or first column, choose the matching command from that same menu.

What Freeze Panes Does

Freeze Panes keeps selected worksheet rows or columns in view while you scroll through the rest of the sheet. It is useful when a long table has headings at the top or identifying information at the left. For example, a sales worksheet might have product names in column A and field names in row 1. Freezing both makes it easier to see which product and which field belong to a value far down or across the sheet.

The frozen area does not move as the worksheet scrolls, but the rest of the worksheet remains available. Freeze Panes changes the on-screen view; it does not lock cells against editing, protect data, or repeat headings on printed pages. Those are separate tasks. It also does not change the contents or order of the rows and columns.

Freeze Panes Step by Step

Open the worksheet and select the cell where the scrolling area should begin.
On the ribbon, select View > Freeze Panes.
Choose Freeze Panes from the menu. Excel freezes the rows above the selected cell and the columns to its left.
Scroll down or across to check that the intended headings or labels stay visible.

For example, selecting cell B2 freezes row 1 and column A. Selecting A2 freezes only row 1, while selecting B1 freezes only column A. The selected cell itself is not frozen as an isolated cell: Excel freezes whole rows above it and whole columns to its left. This selection rule is the key to getting the result you want.

In Excel 2016 for Windows, you can also use the ribbon KeyTip sequence Alt, W, F, F to apply Freeze Panes. Press the keys in sequence rather than holding them all down. If your ribbon or keyboard settings produce different KeyTips, use the visible menu commands instead.

How to Choose the Right Cell

Think of the selected cell as the upper-left corner of the part of the worksheet that should continue scrolling. Everything above it and to its left becomes the fixed area. This gives you control over freezing more than one row or column, not just the first row or first column.

Keep row 1 visible: select A2, then choose Freeze Panes.
Keep column A visible: select B1, then choose Freeze Panes.
Keep rows 1 and 2 visible: select A3, then choose Freeze Panes.
Keep columns A and B visible: select C1, then choose Freeze Panes.
Keep rows 1 and 2 plus columns A and B visible: select C3, then choose Freeze Panes.

Before choosing the command, check the row and column labels around the selected cell. If you select C3, for instance, the dividing lines should be placed after row 2 and column B. If you accidentally select C2, Excel will freeze only row 1 along with columns A and B. A quick check of the selection can prevent that common off-by-one mistake.

Freeze the Top Row or First Column

The Freeze Panes menu also has commands for the most common one-part cases. Choose View > Freeze Panes > Freeze Top Row when you need row 1 to remain visible as you scroll vertically. Choose View > Freeze Panes > Freeze First Column when column A should remain visible as you scroll horizontally. These commands are convenient when the heading or label is in the first row or column.

These built-in commands do not mean “freeze whichever row or column is currently selected.” Freeze Top Row targets row 1, and Freeze First Column targets column A. If the heading is on row 3, or the identifying field is in column C, use the general Freeze Panes command with a carefully chosen cell instead. If a worksheet has title rows above the actual column headings, you may need to freeze several rows using that general method.

Change or Remove a Freeze

Excel can maintain one freeze arrangement for a worksheet at a time. To change it, first remove the existing arrangement: choose View > Freeze Panes > Unfreeze Panes. Then select a new cell and apply Freeze Panes again, or choose Freeze Top Row or Freeze First Column. Selecting a different cell while the old freeze is still active does not simply replace the old boundary.

Unfreezing affects only the view arrangement. It does not delete data, alter formulas, or remove worksheet formatting. If you need to scroll normally to inspect a different area, unfreeze the panes and restore the desired arrangement afterward. When the command menu shows Unfreeze Panes, that is an indication that a freeze is currently applied to the active worksheet.

Freeze Panes Compared with Split

Split is a related View-tab feature, but it serves a different purpose. A split divides the worksheet window into separate panes that can be scrolled independently. Freeze Panes instead keeps the chosen top rows and left columns stationary while the remaining area scrolls. For a table where headings should stay in place, freezing is usually the simpler choice. Splitting can help when you want to compare two distant parts of the same worksheet at once.

These features are not the same as hiding rows or columns. Hidden data is not displayed until it is unhidden, whereas frozen data stays visible while other parts of the sheet move. Nor is freezing a substitute for sorting or filtering: it helps you keep context while navigating, but it does not rearrange or narrow the data.

Common Problems and Fixes

The wrong rows or columns are fixed: unfreeze, select the cell one row below and one column to the right of the intended frozen area, then apply Freeze Panes again.
Only row 1 or column A is freezing: you may have chosen Freeze Top Row or Freeze First Column. Use the general Freeze Panes command to freeze a different or larger area.
The command is unavailable or behaves unexpectedly: finish editing the current cell by pressing Enter or Esc, and switch to View > Normal if the worksheet is in another view. Then try the command again.
The frozen boundary is hard to notice: look for the thin line separating the stationary area from the scrolling area. Scroll a little to confirm which region remains in place.
You are looking at the wrong worksheet: freeze settings apply to the active worksheet. Check that the intended sheet tab is selected before changing the view.

Also consider whether the sheet contains enough visible space to make the frozen area useful. Freezing many rows and columns can leave only a small part of the worksheet available for scrolling, especially in a window with a low screen resolution or a large zoom setting. If the working area feels cramped, unfreeze and keep only the essential labels fixed.

Excel 2016 on Mac and Printing

In Excel 2016 for Mac, use the View tab or menu and its Freeze Panes options; the Windows Alt-based KeyTip sequence is not the Mac equivalent. The exact ribbon presentation can differ by Mac release and interface settings, so use the displayed command names. The selection rule is the same: select the cell below and to the right of the rows and columns to keep visible before applying Freeze Panes.

For printed output, freezing panes alone will not repeat headings on every page. In Excel 2016 for Windows, use Page Layout > Print Titles to set rows to repeat at the top or columns to repeat at the left on printed pages. This is a separate print-layout setting. A worksheet may use both frozen panes for on-screen navigation and print titles for paper or PDF output.

Frequently Asked Questions

How do I freeze the first two rows in Excel 2016?
Select cell A3, then choose View > Freeze Panes > Freeze Panes. Excel keeps rows 1 and 2 visible while the rows below scroll.

Can I freeze the top row and first column at the same time?
Yes. Select cell B2 and choose Freeze Panes. This freezes row 1 and column A. For more than one row or column, select the cell immediately below and to the right of the area to keep fixed.

Why does Freeze Panes freeze the wrong area?
The selection determines the boundary. Excel freezes every row above the active cell and every column to its left. Unfreeze the current setting, select the correct boundary cell, and apply the command again.

How do I unfreeze panes without deleting anything?
Choose View > Freeze Panes > Unfreeze Panes. This removes the scrolling boundary only; worksheet values and formatting remain unchanged.

Will frozen headings appear on printed pages?
No. Freeze Panes is for navigating the worksheet on screen. Set repeating print headings through Page Layout > Print Titles when you want rows or columns repeated on printed pages.

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.