Freeze Numbers in Excel: Keep Formula Results Fixed

To freeze a number produced by a formula in Excel, copy the cell or range, then paste it back as values: select the cells, press Ctrl+C, and choose Home > Paste > Values. This replaces formulas with their current results, so those numbers no longer recalculate. If you mean keeping headings visible while scrolling, use Freeze Panes instead; that changes the view, not the numbers stored in cells.

What You’ll Need

An Excel workbook with the formulas or numbers you want to keep. These steps are for Microsoft Excel for Microsoft 365 on Windows.
Permission to edit the workbook. If a sheet is protected, you may need the password or permission to unprotect it before changing cells.
A copy of the workbook if the formulas are important. Replacing formulas with values is not easily reversible after you save, close the file, or make other edits.

Step-by-Step

Decide what you mean by freeze. If you want a calculation to stop changing, convert its formula to a fixed value using the steps below. For example, a cell calculating a monthly total from changing entries can be changed to the total it displays now. If you only want column headings or labels to remain on screen while you scroll, use View > Freeze Panes instead. That view setting does not stop formulas from recalculating.
Save a backup or make a duplicate of the sheet. Before replacing formulas, use File > Save As to save a separate workbook, or right-click the sheet tab and choose Move or Copy, then select Create a copy. A copied sheet is handy when you want to preserve the calculations for later reference. Remember that a sheet copy may also duplicate confidential or hidden data.
Check the results before converting them. Click a formula cell and look at the formula bar. A formula typically begins with an equals sign, while a number typed directly into a cell is already a fixed value. Check that the displayed result is current and correct. If a calculation is set to manual, use Formulas > Calculation Options > Automatic, or press F9 to recalculate before you freeze the results. Be aware that recalculating can update other formulas in the workbook too.
Select the cells to freeze. Drag across a continuous range, click its first cell and Shift-click its last cell, or select a whole column or row if every cell in it should become a value. To select separated areas, hold Ctrl while selecting each area. Avoid selecting entire columns or rows unnecessarily in a large workbook: convert only the cells you mean to change, and check that the selection does not include labels, inputs, or formulas you still need.
Copy the selected cells. Press Ctrl+C. A moving dotted border usually appears around the copied selection. Copying is important: do not use ordinary Paste, which would paste the formulas along with their results and leave them able to recalculate.
Paste the results as values into the same location. Keep the cells selected, open Home > Paste, and choose the Values option, usually shown with a clipboard and a 123 symbol. This writes the current displayed results over the copied formulas. Another Windows route is to press Ctrl+Alt+V, choose Values in the Paste Special dialog, and select OK. In some dialog layouts, pressing V selects Values; check the dialog before confirming rather than relying on the letter alone.
Confirm the conversion. Click one of the changed cells and inspect the formula bar. It should show the result as a number, date, or text value instead of a formula beginning with an equals sign. Change one of the original input cells as a test: the frozen result should stay the same. Undo immediately with Ctrl+Z if the wrong cells were selected or the result is not what you expected.
Save the finished workbook. Press Ctrl+S after checking the results. If the original formulas may be useful, keep the backup or copied sheet until you are certain the fixed values are all you need.

For example, imagine cells B2:B4 contain sales amounts and B5 contains a formula that adds them. If B5 currently displays 275, pasting B5 as a value replaces its formula with the number 275. Changing one of the sales amounts later will no longer change B5. The other cells are unaffected if only B5 was selected.

To freeze formulas in a separate output area instead of replacing the originals, copy the source range, select the destination’s top-left cell, and choose Home > Paste > Values. Check that the destination has enough room and will not overwrite existing content. This is useful for making a fixed snapshot while keeping the live calculations in their original cells.

Common Mistakes

Using Freeze Panes to lock a calculation. View > Freeze Panes keeps rows or columns visible as you scroll. It does not change formulas, lock cell contents, or prevent recalculation. Use Paste Values to make formula results static.
Choosing ordinary Paste. A normal paste copies formulas, formatting, and other cell contents. The formulas can still change when their references change. Choose the Values option specifically.
Replacing more cells than intended. Pasting values over a selected range permanently removes the formulas in that range. Check the highlighted selection before pasting, especially if you selected a full row, column, or multiple areas.
Assuming number formatting is the same as the stored value. A cell formatted as currency may display $275.00 while its underlying value is 275. Paste Values keeps the result, but formatting may behave differently depending on the paste option. If you need the currency appearance, check the number format after pasting.
Freezing a result before it is up to date. If calculation is manual or source data has not refreshed, the displayed result may be stale. Recalculate and review the result first. For linked or imported data, make sure the required refresh has completed before converting formulas.
Expecting the conversion to be reversible forever. Ctrl+Z can undo a recent paste, but it may not help after closing the workbook or carrying out many other actions. Keep a backup when the formulas are difficult to recreate.

Tips

Keep live and fixed data separate. Use a clearly labeled snapshot column or worksheet for frozen results, and leave the formula-driven report intact. Add a date such as Snapshot as of 3 November 2026 in a nearby cell so readers know when the values were captured.
Keep useful context with the numbers. If a frozen figure depends on assumptions, period dates, or source records, retain those details in the workbook. A static value does not explain how it was calculated.
Choose the right paste option. Values pastes results rather than formulas. If you also need the original cell formatting, inspect the Paste menu for Values & Number Formatting, when available, or apply the desired formatting after pasting. Paste options can differ slightly between Excel versions and platforms.
Use a destination range for reports. Copy formulas to a separate report area and paste values there when the source calculations should continue updating. This gives you a stable snapshot without sacrificing the live model.
Check dates, percentages, and errors. A date is stored as a serial number with a date format, and percentages are numeric values displayed with percentage formatting. Verify that these still look right after pasting. If a cell contains an error such as #VALUE!, Paste Values will preserve that error rather than fix it.
Account for platform differences. On Excel for Mac, copy with Command+C, then use Home > Paste and choose Values; ribbon labels and icons can vary by release. Excel for the web also offers Paste Values from the Home tab, though the menu layout may differ. If a keyboard shortcut for Paste Special differs on your version, use the ribbon menu to avoid guessing.

Troubleshooting

The result still changes. The formula may not have been replaced. Select the cell and check the formula bar; if it still begins with an equals sign, repeat the copy-and-paste-values process. Make sure you used Values rather than ordinary Paste, and that you pasted over the original cell if that was your intention.

The pasted value is wrong or shows an error. Undo promptly with Ctrl+Z, check the source formula and its inputs, and recalculate with F9 if appropriate. If the workbook uses manual calculation, check Formulas > Calculation Options. Do not freeze an error or outdated result unless preserving that exact state is intentional.

The Values option is unavailable or the paste fails. First copy the cells again; paste options may be disabled when there is no copied selection. If the sheet is protected, ask the workbook owner to grant editing access or unprotect the sheet. If you are editing in a browser and the command is missing, try Home > Paste > Paste Values or open the workbook in the desktop app.

The number changes appearance after pasting. The underlying value and its display format are separate. Select the cells and choose an appropriate number format from Home > Number, such as Date, Currency, or Percentage. If you need to preserve the source appearance, use Values & Number Formatting when that paste option is available.

You actually meant to keep headings visible while scrolling. 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 lock only the top row, use View > Freeze Panes > Freeze Top Row. To lock only the first column, use View > Freeze Panes > Freeze First Column. Choose View > Freeze Panes > Unfreeze Panes to remove the setting.

Frequently Asked Questions

What does freeze numbers mean in Excel?
Usually, it means replacing a formula with its current result so the number no longer changes when inputs change. Copy the cells and use Paste Values. Some people mean freezing rows or columns on screen, which is a separate Freeze Panes feature.

Can I freeze a formula result without deleting the original formula?
Yes. Copy the formula cell or range to a different destination and paste values there. The original formula remains in its source cells and continues to recalculate.

Will Paste Values keep the cell’s formatting?
It preserves the value or formula result, but not necessarily every aspect of the original formatting. Check the result after pasting and reapply formats such as currency, date, or percentage if needed. Use Values & Number Formatting if your version offers it and that is the result you want.

Can I freeze numbers in Excel for the web or on a Mac?
Yes. Both versions provide a Paste Values option in the Home tab. On a Mac, use Command+C to copy and select Values from the paste menu. In the web app, the ribbon layout may differ, but choose Paste Values rather than ordinary Paste.

How do I freeze the top row or first column instead?
Choose View > Freeze Panes, then select Freeze Top Row or Freeze First Column. These commands keep those areas visible while you scroll; they do not convert formulas into fixed values.

Can I update frozen numbers later?
Not by changing the original inputs: a pasted value has no formula connecting it to those inputs. Recalculate or copy the live formula again, then paste its new result as a value. Keep the original formulas or a backup if you expect to need updated snapshots.

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.