Copy Values Without Formulas in Excel: Step-by-Step

Formulas & functions · Updated November 20, 2026

To copy formula results without copying the formulas in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+C, choose the destination, then press Ctrl+Alt+V, choose Values, and press Enter. You can also use Home > Paste > Values. This puts fixed results in the destination while leaving the original formulas alone, unless you paste over the source cells.

What You’ll Need

  • An Excel workbook with cells you want to copy. They can contain formulas, typed values, or a mix of both.
  • A destination range that is the same size and shape as the copied range, or one starting cell where Excel can place the copied block.
  • If you plan to replace formulas in their original cells, save a separate copy of the workbook first. Pasting values over formulas is permanent unless you undo it immediately.

You do not need a special add-in or a new formula. Paste Special is built into Excel. The method works for formula results such as totals and lookup results, and also for ordinary text and numbers.

Step-by-Step

  1. Check what you are copying. Select the cells and look at the formula bar. If a cell contains a formula, the bar will show an expression beginning with an equals sign, while the grid displays the formula’s current result. Decide whether you want to copy one cell, a whole range, or a complete spilled result from a dynamic array formula. If the result depends on recent edits, let Excel recalculate before copying; press F9 to recalculate the workbook if needed.
  2. Select the source range. Drag across the cells, or click the first cell and Shift-click the last one. For a large range, click its first cell, hold Shift, and click its last cell. Check that the selection includes every row and column you need. If you copy only part of a table, formulas that refer to omitted cells will not be included, although their displayed results can still be pasted.
  3. Copy the selection. Press Ctrl+C on Windows. A moving dashed border usually appears around the copied cells. You can also choose Home > Copy. Do not cut the cells: Ctrl+X moves formulas and content rather than making a separate values-only copy.
  4. Choose the destination. Click the top-left cell where the pasted results should begin. To replace formulas in the original range, leave that range selected after copying it. Before pasting a block, verify that the destination has enough room and that you will not overwrite unrelated data. If you select a destination range, make it the same dimensions as the copied range.
  5. Open Paste Special. On Windows, press Ctrl+Alt+V. In the Paste Special dialog, choose the Values option. In versions where the dialog responds to its keyboard access key, press V to select Values. If you prefer the ribbon, open Home > Paste using the arrow, then choose Values; the command may be shown with a 123 icon. The dialog is useful when you want to confirm the paste type before applying it.
  6. Apply the paste and check the result. In the dialog, click OK or press Enter. The destination should show the same displayed results as the source at the time of copying. Click one of the destination cells and look at the formula bar: a pasted formula result should appear as a number, date, text, or error value, not as a formula beginning with an equals sign. The original source remains unchanged unless the destination was the source itself.
  7. Use the Mac or web option if needed. In Excel for Mac, copy with Command+C, then use Edit > Paste Special and select Values; the shortcut Control+Command+V may also open the Paste Special dialog. In Excel for the web, use the Home tab’s Paste menu and choose Paste Values. Keyboard shortcuts can vary with browser and Mac settings, so the menu is a reliable alternative. Check the pasted cells afterward just as you would on Windows.

For example, suppose B2 contains a formula that currently displays 125 and you copy it to D2 using Values. D2 contains the fixed number 125, not a copy of B2’s formula. If B2 later recalculates to 140, D2 remains 125. If instead you paste Values directly over B2, its formula is replaced by the fixed number 125, so it will no longer update when its inputs change.

Common Mistakes

  • Using ordinary Paste instead of Values. Ctrl+V normally copies formulas as well as their contents, so references may adjust in the destination. Use the Values command or select Values in Paste Special when you need static results.
  • Replacing the source by accident. Pasting Values over the cells you copied removes their formulas. If you only meant to make a separate copy, click a different destination before pasting. Use Ctrl+Z immediately if you overwrite formulas by mistake; after more actions, recovery may not be straightforward.
  • Expecting formatting to come along. Values pastes the cell contents, not the source’s formatting. The destination may keep its own font, fill, borders, and number format. If you need the source’s number formats too, choose Values & Number Formats in Paste Special when that option is available, or copy formatting separately.
  • Copying a range that does not match the destination. A mismatched selection can cause an error or put results in an unintended area. Start with the destination’s top-left cell, or select a range with matching rows and columns.
  • Assuming a displayed date or number will look identical. Excel stores dates as numbers and applies a number format to display them. A values-only paste may retain the destination’s existing format, making the same underlying value look like a serial number or a differently formatted date.

Tips

  • Use the ribbon for a visible, repeatable workflow. Home > Paste > Values is easy to spot and avoids uncertainty about keyboard shortcuts. In some ribbon layouts, open the Paste arrow to see the Values option.
  • Keep the original formulas when creating a snapshot. Paste results into another sheet or workbook rather than over the source. This is useful for sending a report, freezing figures for a review, or creating a point-in-time copy that will not change with later inputs.
  • Check number formats separately. If values appear as dates, currency, percentages, or plain serial numbers unexpectedly, select the destination and use Home > Number Format to choose a suitable display. Changing a format changes how a value appears; it does not restore a formula.
  • Paste a full dynamic-array result when you need every item. A formula that spills results into nearby cells can be copied as a block. Select the entire displayed spill range before copying if you want all its results as fixed values, rather than copying only the formula cell.
  • Review errors and blanks before sharing. Values-only pasting preserves a formula’s current error result, such as #N/A, rather than correcting it. It also carries blank cells in the copied range, which can replace existing destination contents. Inspect the source and destination if those details matter.

Troubleshooting

The destination still has formulas. Click a pasted cell and inspect the formula bar. If it begins with an equals sign, ordinary Paste may have been used. Undo if appropriate, copy the source again, and choose Home > Paste > Values or select Values in the Paste Special dialog. Also confirm that you did not click a different paste option, such as Formulas.

The pasted number or date looks wrong. First check the formula bar to see whether the underlying value is correct. If it is, apply the appropriate number format from Home > Number Format. For example, a date serial displayed as a large integer may simply need a date format. If the value is text rather than a number, changing its format may not convert it; values-only pasting preserves the result’s type rather than interpreting it as a new calculation.

Excel says the copy area and paste area are different sizes. Click only the top-left destination cell and paste the copied block, or select a destination range with the same number of rows and columns. If the source selection contains multiple separate areas, copy and paste each contiguous area separately; non-adjacent selections can be restricted by Excel’s paste rules.

The Values command is missing or the shortcut does nothing. Open the Paste drop-down on the Home tab and look for Values. In the desktop dialog, use the Values radio option rather than guessing at a shortcut if your keyboard layout differs. On Mac, use Edit > Paste Special; in the web version, use the Home tab’s Paste menu. Browser shortcuts or custom keyboard settings can intercept key combinations.

The result is outdated or contains an error. A values-only paste captures whatever the formula returned at copy time; it does not recalculate the destination. Recalculate the workbook with F9, resolve any source error if possible, then copy and paste the corrected result again. If you need the destination to keep updating, do not paste values—use a formula or ordinary paste instead.

Frequently Asked Questions

Does Paste Values delete the original formula?
Only if you paste over the cell that contains it. When you paste into a different range or sheet, the source formula stays in place and the destination receives its current result as a fixed value.

Can I copy values without formulas in one keyboard shortcut?
On Windows, the common sequence is Ctrl+C, then Ctrl+Alt+V, choose Values, and press Enter. This is a sequence of actions rather than a single key combination. If the dialog or shortcut behaves differently on your setup, use Home > Paste > Values.

Will the copied values update when the source changes?
No. A pasted result is a snapshot, not a link to the source formula. If the source changes later, paste the values again to refresh the snapshot. To keep a live connection, use a formula or ordinary Paste instead.

Does Paste Values copy colors, borders, or column widths?
No. It pastes cell contents only. Choose a values-and-number-formats option if you need the number display format, and apply other formatting separately. Column widths are not included in a values-only paste.

Can I use this to turn formulas into fixed numbers in the same cells?
Yes. Copy the formula cells, then paste Values over the same selection. The formulas are replaced by their current results and will not update afterward. Save a copy first if you may need the formulas later.

What happens if a formula currently displays an error?
The error is pasted as a fixed error value, such as #VALUE! or #N/A. Values-only pasting does not fix the cause. Correct the formula or its inputs first, let Excel recalculate, and then copy the result again.

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.