Freeze Function in Excel: Freeze Panes or Formulas

To keep headings visible while you scroll, select the cell just below and to the right of the rows and columns you want to keep, then choose View > Freeze Panes > Freeze Panes. Excel does not have a built-in function called Freeze; the phrase usually means freezing worksheet panes, locking a formula reference, or replacing a formula with its current value. The steps below explain each option so you can choose the one you need.

What You’ll Need

Excel for Microsoft 365 on Windows, with the workbook open. The ribbon names below are for this version.
A clear idea of what you want to stay fixed: headings on screen, a cell reference in a copied formula, or the result of a formula.
If you plan to replace formulas with values, save a separate copy first. That change removes the formulas and cannot be undone after you close the workbook.

Excel for Mac has the same basic freeze-pane options under the View tab, although the ribbon layout can differ slightly. Excel for the web also offers Freeze Panes from its View tab, but some menus may look different from the Windows desktop app.

Step-by-Step

Decide what “freeze” means for your task. Use Freeze Panes if you want row or column labels to remain visible while you scroll. Use an absolute reference, marked with dollar signs, if you want part of a formula to keep referring to the same cell when you copy the formula. Use Paste Special as values if you want to keep a formula’s current result but stop it from recalculating. These are separate actions; freezing a pane does not change a formula, and locking a cell reference does not keep a heading on screen.
Freeze the top row. Click anywhere in the worksheet, then select View > Freeze Panes > Freeze Top Row. Scroll down to check that row 1 remains visible. This is useful for column headings such as Date, Product, or Total when the data table extends below the screen. It freezes the worksheet’s first row, not the top row of a table if that table begins lower down.
Freeze the first column. Select View > Freeze Panes > Freeze First Column. Scroll horizontally to confirm that column A stays visible. This option is handy when the first column contains names or item IDs and the rest of the sheet has many columns. It freezes column A specifically, so it will not freeze a label column that begins in column B or later.
Freeze more than one row or column. Click the cell immediately below the last row and immediately to the right of the last column you want to keep visible. Then choose View > Freeze Panes > Freeze Panes. For example, to keep rows 1 and 2 and column A visible, select cell B3 first. Excel freezes everything above the selected cell and everything to its left. To keep only rows 1 through 3 visible, select A4. To keep columns A and B visible, select C1.
Check the frozen area. Look for a thin dividing line across the sheet or down it, then scroll in the unfrozen area. The rows above the horizontal line and columns to the left of the vertical line should stay in place. If the wrong area is fixed, choose View > Freeze Panes > Unfreeze Panes, select the correct cell, and apply Freeze Panes again. You can adjust the selection only after unfreezing.
Lock a cell reference in a formula, if that is what you meant. A dollar sign makes a reference absolute when you copy a formula. With a value of 12 in B2 and 1.1 in F1, enter =B2*$F$1 in C2; the result is 13.2. When you copy the formula down, B2 changes to B3, B4, and so on, while $F$1 continues to point to F1. In the formula bar, you can also select a cell reference and press F4 on Windows to cycle through relative, absolute, and mixed references. On a Mac, Command+T commonly cycles the reference type; keyboard mappings can vary by Excel version and keyboard.
Keep a formula’s current result instead of its calculation. First consider making a backup copy of the workbook. Select the formula cells, copy them, then use Home > Paste > Paste Values. In some Excel layouts, the Paste Values button is also available from the Paste drop-down. The cells now contain the displayed results rather than formulas, so later changes to source cells will not update them. Check a few cells in the formula bar to confirm that the formulas have been replaced as intended.
Save and test the workbook. Save the file, then scroll up, down, and sideways to check the pane behavior. If you converted formulas to values, change a source cell only in a backup or a test copy and confirm that the fixed values do not change. Remember that freezing panes affects the on-screen view; it does not repeat headings on printed pages.

Common Mistakes

Selecting the wrong cell before freezing. The selected cell determines the boundary. If you want rows 1 and 2 plus column A frozen, B3 is the correct selection. Selecting A3 freezes the two rows but no columns; selecting B2 freezes row 1 and column A. If the result looks unexpected, unfreeze first and try again rather than repeatedly selecting different cells while panes remain frozen.

Assuming Freeze Top Row means the first visible row. It means worksheet row 1. If your headings are in row 5, use a cell below row 5 and apply Freeze Panes instead. A filter or formatted table does not change which worksheet row the command targets.

Confusing an absolute reference with a fixed result. Dollar signs keep a reference in the same location when a formula is copied, but that formula still recalculates if the referenced value changes. To preserve the result itself, paste values. Conversely, pasting values removes the calculation, so do not use it if the workbook must update automatically.

Expecting frozen headings to print on every page. Freeze Panes is a viewing feature. For printed worksheets, use Page Layout > Print Titles and set rows to repeat at top or columns to repeat at left. Print settings are separate from the worksheet’s frozen screen area.

Tips

Freeze only the rows and columns you genuinely need. A large frozen area leaves less room to view and scroll through the rest of the sheet.
For a worksheet with headings in row 1 and IDs in column A, selecting B2 and choosing Freeze Panes is a quick way to keep both visible.
Use Freeze Panes rather than Split when you want a fixed header. Split creates independently scrollable sections; it does not behave like one anchored header area.
Use mixed references when only one part of a formula should stay fixed. For instance, $F1 locks the column but allows the row to change, while F$1 locks the row but allows the column to change.
If you need to freeze the result of volatile or frequently changing calculations for a report, keep an untouched working copy and convert values only in the report copy. This preserves the formulas for later updates.
On a small screen, check the frozen lines after zooming or resizing the window. A correct freeze can appear to take up too much space if the frozen rows are unusually tall.

Troubleshooting

The wrong rows or columns stay visible: Choose View > Freeze Panes > Unfreeze Panes. Then click the cell below and to the right of the intended frozen area and apply Freeze Panes again. For example, if row 1 and columns A and B should remain visible, select C2.

The Freeze Panes options are unavailable or the sheet will not scroll as expected: Check whether the worksheet is protected or whether the workbook is in a restricted editing mode. If you can edit the sheet, try View > Freeze Panes > Unfreeze Panes, then reapply the setting. If you are in a split view, choose View > Split to turn the split off before setting panes. A protected sheet may require the owner to allow the necessary changes.

Your formula changes when copied: Check its cell references. If a reference must remain fixed, add dollar signs to both its column and row, such as $F$1. If only the row or column should stay fixed, use a mixed reference. Remember that a fixed reference is not the same as a fixed value; the formula will still recalculate.

Paste Values is missing or the formula remains: Select the copied cells and use the Paste drop-down on the Home tab, then choose the values option, usually shown as 123. Make sure you copied the formula cells before opening the paste options. If you need to retain formatting as well, check the resulting cells because Paste Values may not carry over the original formatting.

The headings disappear in print preview: Set them separately with Page Layout > Print Titles. In the Page Setup dialog, specify the row or column range to repeat. Freeze Panes alone will not change printed page headers.

Frequently Asked Questions

Is there a Freeze function in Excel?
No. Freeze Panes is a View command, not a worksheet function. People may also use “freeze” to mean fixing a formula reference or replacing a formula with its current value.

How do I freeze both the top row and first column?
Select cell B2, then choose View > Freeze Panes > Freeze Panes. The row above and the column to the left remain visible while you scroll.

Can I freeze two or more rows?
Yes. Select a cell in column A immediately below the rows you want to keep, then choose Freeze Panes. For example, select A4 to freeze rows 1 through 3.

How do I unfreeze panes?
Choose View > Freeze Panes > Unfreeze Panes. You can then select a new boundary and freeze a different set of rows or columns.

Does freezing a pane stop formulas from recalculating?
No. It only keeps selected rows or columns visible while scrolling. To stop a formula from updating, replace it with its current value using Paste Values; to keep a reference fixed when copying, use dollar signs.

Will frozen panes remain when I reopen the workbook?
Usually, yes. The view setting is saved with the workbook. If you open the file in another spreadsheet program or a different viewing mode, the display may look different, so check the saved file in Excel.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.