Switch Excel Formulas to Values: Methods and Tips

Formulas & functions · Updated November 18, 2026

To switch formulas to fixed values in Excel for Microsoft 365 on Windows, select the formula cells, press Ctrl+C, then press Ctrl+Alt+V, V, and Enter. This Paste Special command replaces each formula with its current result; the displayed result stays in the cell, but it no longer updates when its inputs change.

What switching formulas to values means

An Excel formula is an instruction that calculates a result, such as adding two cells or looking up a matching record. A value is the content stored as the result itself: it might be a number, date, text, TRUE or FALSE, or an error value. When you replace formulas with values, Excel keeps the results that are currently calculated and removes the instructions that produced them.

For example, a sales total might depend on quantity and unit price. With product names in A2:A10, quantities in B2:B10, prices in C2:C10, and a formula in D2, the formula in D2 is =B2*C2. If B2 is 3 and C2 is 10, the result in D2 is 30. Converting D2 to a value keeps 30, but changing the quantity or price later will not recalculate that total.

This is useful when a calculation is finished, when you need a fixed snapshot, or when a workbook must be shared without formulas. It is not the same as hiding formulas or protecting a worksheet: the formulas are removed from the converted cells.

Convert formulas with Paste Special

Paste Special is the standard method because it lets you replace formulas while keeping the cells in place. In Excel for Microsoft 365 on Windows, use these steps:

  1. Select the cells containing the formulas you want to freeze. You can select a single cell, a continuous range, or multiple nonadjacent ranges with Ctrl-click.
  2. Press Ctrl+C to copy the selection. A moving dashed border appears around it.
  3. Press Ctrl+Alt+V to open the Paste Special dialog.
  4. Choose Values, then select OK. Alternatively, press V and then Enter while the dialog is open.

The formulas in the selected cells are replaced by their calculated results. The cells keep their existing number formats, such as currency or date formatting, because the Values option pastes content rather than source formatting. If you want to paste both results and formatting, choose a different Paste Special option; do not assume Values will copy a source cell’s appearance.

You can also use the ribbon: select and copy the formula cells, then choose Home > Paste > Values. Depending on the ribbon layout, Values may appear as a clipboard icon with 123. The same general Paste Special choices are available in Excel for the web, although the precise keyboard behavior can differ by browser and operating system. In Excel for Mac, use the Home tab’s Paste menu and choose Values, or open Paste Special from the ribbon; keyboard shortcuts differ from Windows, so the menu is the dependable route if your shortcut is unfamiliar.

Quick ways to paste values

For a one-time conversion, the Windows keyboard sequence is usually quickest: Ctrl+C, then Ctrl+Alt+V, V, Enter. Another option is to copy the range, right-click the destination, and choose the Values paste option. You can paste over the original cells to replace the formulas, or paste into a different location to keep the formulas and make a separate static copy.

On Windows, Excel also provides the ribbon key tips: after copying, press Alt, H, V, V to invoke Paste Values in many Microsoft 365 ribbon configurations. Key-tip sequences can vary with interface changes and localized versions of Office, so use the visible Home > Paste menu if those letters do not match your installation. On Mac, use the ribbon or Paste Special menu rather than relying on a Windows shortcut.

When replacing a formula range in place, copy it before choosing the paste command. A regular paste would simply copy the formulas, and pressing Delete would remove the cell contents rather than preserve their results. If you want an untouched original, first paste values into another range or duplicate the worksheet.

What is retained and what changes

Paste Values changes the cell contents, not the whole worksheet. The formula is removed, and its current calculated result becomes the cell content. Existing formatting in the destination normally remains, including number formats, font, fill, borders, and alignment. Row heights, column widths, data validation, and other worksheet settings are not generally altered by a values-only paste.

Several details can matter when the result is used elsewhere:

  • A date or time is stored by Excel as a number. The date-like appearance usually remains because the cell’s date format remains, but an unformatted destination may show a serial number instead.
  • A formula that returns text becomes fixed text. A number stored as text can remain text, which may affect later calculations or sorting.
  • If a formula currently returns an error, such as #N/A or #DIV/0!, the error result is what gets retained. Fix or review errors before converting if you do not want to make them permanent.
  • A formula that depends on other cells will no longer update after conversion. The cells it depended on remain unchanged, but the relationship between them is gone.

Values are not necessarily plain text. For instance, a result displayed as $30.00 may be the numeric value 30 with a currency format. The display and the underlying value are related but not identical, so inspect both when preparing data for another system.

When to freeze formulas

Converting formulas is appropriate when you deliberately want a snapshot rather than a live calculation. Common examples include a report that must show the figures as of a particular date, a completed calculation that should not shift when source data changes, and a workbook being sent to a recipient who needs results but not the calculation logic.

It can also help when you are archiving an output or handing a data extract to a system that expects fixed entries. For example, a monthly report may use formulas to summarize transactions while it is being prepared. After checking the totals, you could save a separate copy and convert the report figures in that copy. Keeping the original formula workbook preserves a route back to the calculation process.

Consider the consequences before freezing a cell that participates in further calculations. Downstream formulas may continue to work using the fixed number, but they will not receive updated results from the converted cells. If the workbook is intended to remain interactive, keep the formulas and document their purpose instead. If the goal is merely to stop someone seeing formulas, use an appropriate protection workflow rather than replacing them with values.

Check calculation settings before conversion

Paste Special stores the result currently calculated in each formula cell. If the workbook uses manual calculation, or if a calculation has not refreshed, that result may be out of date. Before converting, review the workbook’s calculation behavior and recalculate when appropriate. On Windows, press F9 to calculate open workbooks; Shift+F9 calculates the active worksheet. On Mac, the corresponding recalculation shortcuts can vary by keyboard and Excel version, so use Formulas > Calculate Now or the relevant Calculate Sheet command on the ribbon if needed.

This matters especially for formulas that depend on recent edits, linked workbooks, or functions that recalculate frequently. A formula such as one using the current date or time will become the date or time produced at conversion, not a live clock. If the result must represent a specific reporting moment, make sure the inputs and calculation state are correct first, and record the date of the snapshot separately if that context matters.

Common problems and how to avoid them

  • The formulas did not change: Check that you selected the intended cells and chose Values rather than the ordinary Paste command. If the cells are protected, you may not have permission to edit them.
  • The result looks different: The destination format may differ from the source format, or a date may be displaying as its underlying serial number. Apply the appropriate number format after pasting, or choose a paste option that includes formatting if that is intended.
  • The pasted values are errors: Paste Special preserves current results, including errors. Diagnose the formulas before conversion if an error is not an acceptable final result.
  • Only part of a dynamic array is selected: A formula that spills results into neighboring cells is controlled by its anchor cell. Treat the spilled result as a group; Excel may prevent editing only part of the spill range. Copy and convert the full result range when a static copy is needed.
  • A table formula returns after conversion: Excel tables can use calculated columns that fill formulas down the column. Check whether you converted the intended table cells and whether the table is automatically propagating a formula. If the column must remain static, review the column’s contents after pasting.

For important workbooks, make a copy before a large conversion. Undo may reverse a normal paste operation immediately, but relying on a long undo history is risky, especially after additional edits or closing the file. A separate backup makes it easier to recover the original calculations.

Values versus other paste options

Excel’s paste choices serve different purposes. Ordinary Paste copies formulas, formatting, and other cell content, so relative references may adjust to the destination. Paste Values copies the results only. Paste Formulas copies the formulas without the original formatting, while options that include number formats or source formatting are useful when the appearance needs to travel with the content.

Copying and pasting as values is also different from exporting a worksheet to CSV. A CSV file stores text-based data and does not preserve Excel formulas, worksheet formatting, or multiple sheets in the same way as an Excel workbook. Paste Values changes selected cells inside the workbook and leaves its other sheets and features in place. Choose the method based on whether you need a fixed range, a static copy, or a separate data file.

Likewise, hiding formulas or protecting a sheet does not make formulas into values. Those approaches can limit visibility or editing, depending on how the sheet is configured, but the calculations remain in the workbook. If the requirement is that results never change when source cells change, conversion is the relevant operation.

Frequently Asked Questions

Can I convert formulas to values without using the mouse?
Yes. On Windows, select the cells, press Ctrl+C, then Ctrl+Alt+V, V, Enter. This opens Paste Special and applies the Values option. On Mac, keyboard shortcuts differ, so the Home > Paste menu is a reliable alternative.

Will converting formulas to values keep my formatting?
Usually, yes, when you paste values back into the same cells: the destination’s existing formatting remains. The Values option does not copy the source formatting. If you paste into a differently formatted range, the results may therefore look different.

Can I convert only some formulas in a worksheet?
Yes. Select just the cells or range you want to freeze before using Paste Special > Values. Other formulas remain intact. For a nonadjacent selection, use Ctrl-click on Windows to add separate ranges, but be careful to verify the selection before pasting.

Can I undo a formula-to-value conversion?
Immediately after converting, Ctrl+Z on Windows normally undoes the paste; on Mac, use Command+Z. If you have made more changes, closed the workbook, or exceeded the undo history, recovery may not be possible. Save a separate copy before a large conversion.

Why does a converted date show as a number?
Excel stores dates as numbers and relies on number formatting to display them as dates. If the destination does not have a date format, the underlying serial number may appear. Apply a date format from Home > Number Format to show it as a date again.

Does Paste Values remove formulas from a whole dynamic-array result?
It can create a static result, but Excel treats a spilled array as a connected output from its anchor formula. Select and copy the complete spill range rather than trying to overwrite only one cell in the middle. If Excel blocks the operation, check the spill range and convert the full output.

Related

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.