Excel Make Formula Results Permanent

Updated 5 November 2026 · Standard formula, shown below

Yes. To make formula results permanent in Excel, copy the formula cells and paste them back as values; this replaces each formula with its current displayed result. The values will no longer recalculate when their source cells change, although you can still edit them manually.

What “Permanent” Means in Excel

A formula is an instruction Excel recalculates, such as =A1+B1. Its result depends on the cells it refers to and may change when those inputs change. A value is the stored content itself, such as the number 25 or the text Complete, with no formula behind it.

Converting formulas to values freezes their results at the time of pasting. It does not lock the cells against editing, protect the workbook, or make the data impossible to change. If you need protection from accidental edits, use worksheet protection separately; that serves a different purpose.

Convert Formulas to Values

The standard method works in desktop Excel and is suitable for a range, a whole worksheet, or selected cells:

Select the cells containing formulas. To convert an entire sheet, click the triangle at the top-left of the worksheet grid, where the row and column headings meet. Be aware that converting a whole sheet also replaces any formulas you intended to keep.
Copy the selection with Ctrl+C on Windows or Command+C on Mac.
Keep the same cells selected, then choose Paste Special and select Values. Depending on your Excel version, you can find Paste Special on the Home tab under Paste, or by right-clicking the selection.
Check a few cells in the formula bar. A formula cell should now show its result as a value rather than begin with =.

The key is to use a values-only paste. A regular paste copies formulas too, so it does not make them permanent. The wording and location of the command can vary slightly among Excel versions and platforms.

Keyboard Shortcuts and Other Ways

In many Windows desktop versions, you can press Ctrl+C, then Ctrl+Alt+V to open Paste Special and choose Values. Some versions also support a sequence of ribbon-key shortcuts, but key sequences can differ by release and settings. If a shortcut does not work, use the visible Paste Special menu rather than guessing.

You may also see a small Paste Options icon after copying. Choose the option marked Values or shown with a values symbol. In Excel for the web, use the available paste options in the Home ribbon or context menu; available shortcuts and menu details can differ from desktop Excel.

For one cell, another option is to select it, copy it, and paste values over the same cell. For a large range, first confirm the selection carefully. A mistaken paste can replace formulas you meant to preserve.

What Happens to Formatting and References?

Values-only paste replaces cell contents with calculated results, but it generally leaves the destination cells’ existing formatting in place. If the destination cells have different number formats, the same stored number may look different. For example, a value of 0.25 might display as 25% in a percentage-formatted cell or as 0.25 in a general-format cell.

When a formula is converted, its references and logic are discarded. A formula such as =A1*B1 becomes the result it produced at the time of conversion. Later edits to A1 or B1 will not affect that result. If formulas refer to volatile functions or external data, check that the workbook has the results you intend to keep before replacing them.

Copying formulas can also carry relative references that adjust to the new location. Pasting values avoids that issue because it transfers results, not formulas. However, if a result is an error such as #DIV/0! or #N/A, values-only paste freezes that error too. Resolve errors first if you do not want them retained.

When to Keep Formulas and When to Freeze Results

Keep formulas when the workbook should update as inputs change: budgets, schedules, inventory totals, and analysis sheets often depend on recalculation. Convert formulas when the result should be a snapshot, such as a finalized report, a completed calculation, or data being prepared for an application that needs plain values.

Keep formulas if readers need to inspect the calculation or update its inputs later.
Convert a copy if you need a fixed snapshot but also want to retain an editable formula version.
Convert selected cells if only a few results should stop changing.
Keep a backup before replacing many formulas, especially in a workbook with linked sheets or complex calculations.

A useful compromise is to duplicate the worksheet, then convert formulas to values on the duplicate. Name the sheets clearly—for example, “Working” and “Snapshot”—so it is obvious which one recalculates.

Common Problems and How to Avoid Them

The formulas remain after pasting: A normal paste was likely used. Undo if needed, then open Paste Special and select Values.

The result changes appearance: The value may be the same, but the destination’s number format is different. Check the formula bar and the Number Format options before concluding the value changed.

Only some cells converted: Check whether the selection included the full intended range. Filters, hidden rows, or selecting a partial area can make the result less obvious. Review the range before repeating the operation.

You need the original formula back: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, provided you have not performed intervening actions that prevent the desired undo. Otherwise, recover from a saved backup or an earlier workbook version if one exists. Once formulas are replaced and the action can no longer be undone, Excel cannot reconstruct their logic from the values alone.

Do not confuse freezing formulas with Excel’s calculation settings. Turning calculation to manual can stop formulas updating temporarily, but the formulas remain in the cells and may recalculate later. It is not a substitute for values-only paste when you want to remove the formulas.

Frequently Asked Questions

Can I make Excel formula results permanent without copying?
To replace formulas with their current results, Excel’s usual workflow is copy followed by Paste Special > Values. For a lasting snapshot, keep the values in the workbook rather than relying on a temporary calculation setting.

Will pasting values keep my cell formatting?
Values-only paste is intended to paste contents without replacing the destination’s formatting. The result’s display still depends on the number format already applied to those cells.

Can I convert formulas to values in the whole workbook?
Excel does not provide a safe single command to convert every formula in every sheet while preserving all intended content. Work sheet by sheet or select ranges deliberately, and make a backup first.

Can I reverse the conversion later?
Undo may restore formulas if the conversion is still the most recent relevant action. Otherwise, use a backup or version history if available; pasted values do not retain the original formula.

Why did my formula result turn into an error value?
If the formula already displayed an error when copied, Paste Special > Values preserves that error as the cell content. Fix the source formula or its inputs before converting if you want a usable result.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.