Copy Numbers, Not Formulas in Excel: Step-by-Step Guide

Formulas & functions · Updated November 20, 2026

To copy a formula’s current result without copying the formula in Excel, copy the cells, then use Paste Special and choose Values. The pasted results become fixed entries, so they will not recalculate when the cells they originally depended on change. You can paste the values over the original cells or into a different location.

This guide is for Excel for Microsoft 365 on Windows. The same Paste Values option is available in Excel for Mac and Excel for the web, though the menus and keyboard shortcuts differ slightly. Save a copy first if you need to keep the formulas for later.

What You’ll Need

  • An Excel workbook with the cells you want to copy.
  • A destination range with the same dimensions as the copied range, if you are pasting somewhere else.
  • Permission to edit the destination cells. Protected sheets or locked cells can prevent pasting.

Step-by-Step

  1. Check what is in the cells. Click a cell you want to copy and look at the formula bar above the worksheet. If the bar shows a formula beginning with an equals sign, such as a calculation, Excel will normally copy that formula. Paste Values is the step that replaces the formula with its current result. If the formula has not recalculated recently and its result matters, calculate the workbook before copying. With automatic calculation turned off, results may be out of date.

  2. Select the source cells. Drag across the range, or click its first cell, hold Shift, and click its last cell. To select a whole column or row, click its column letter or row number. You can also hold Ctrl while selecting separate ranges, but non-adjacent selections can be awkward to paste and may not work as expected in every destination. For a straightforward result, copy one rectangular range at a time.

  3. Copy the range rather than cutting it. Press Ctrl+C on Windows, or choose Home > Clipboard > Copy. A moving dashed outline usually appears around the selection. Copying leaves the source formulas in place until you paste over them. Do not use Ctrl+X if your goal is to make a separate copy: Cut is intended to move cells and can affect references and the original location.

  4. Choose where the values should go. To replace the formulas in their current cells, leave the copied range selected. To create a separate set of fixed results, click the top-left cell of a blank destination range. Check that there is enough room for the copied rows and columns and that you are not about to overwrite information you need. When working in another worksheet or workbook, click its destination cell after copying.

  5. Open Paste Special. On Windows, press Ctrl+Alt+V to open the Paste Special dialog. Alternatively, right-click the destination and choose Paste Special. You can also use the Home tab, open the Paste menu, and select Values, shown with a 123-style icon in many Excel builds. If you are pasting into the original range, make sure the source is still copied before opening the menu.

  6. Choose Values and confirm. In the Paste Special dialog, select Values and click OK. With the dialog open, you can also press V and then Enter on Windows to select Values. The cells now contain the results from the time of pasting rather than the original formulas. Click one of the pasted cells and check the formula bar: it should show a constant, such as a number, instead of a formula.

  7. Check the pasted result and finish. Compare a few cells with the source to confirm the figures are correct. Press Esc to remove the moving copy outline when you are done. If you pasted into a new area, the formulas in the original range remain unchanged; if you pasted values onto the source range, those formulas have been replaced and will not return unless you undo immediately or restore them from a saved copy.

On Mac, use the ribbon or context menu and choose Paste Values; the Paste Special dialog can also be opened with Control+Command+V in many Excel for Mac setups. Keyboard behavior can depend on the keyboard and Excel version, so use the menu if that shortcut does not open the dialog. In Excel for the web, copy the cells, select the destination, then use Home > Paste > Paste Values or the right-click paste menu. The Windows Ctrl+Alt+V dialog shortcut is not the dependable route in a browser.

Common Mistakes

  • Choosing regular Paste. Ctrl+V normally pastes formulas along with other cell content. If the pasted formula changes when moved to a new location, undo with Ctrl+Z and repeat using Paste Special > Values.

  • Expecting formatting to come along. Values pastes cell results, not the source fonts, fills, borders, or complete formatting. A percentage may appear as 0.25 instead of 25%, and a date may appear as a serial number if the destination is formatted as General. Apply the desired number format separately, or choose Values & Number Formatting if you want the source number formats too.

  • Assuming every pasted cell will be numeric. Paste Values copies the results in the selected cells, which can include text, blanks, or error results as well as numbers. It does not filter out non-numeric results. Review the range first if you need to transfer numeric results only.

  • Overwriting the only copy of important formulas. Pasting values onto the source cells replaces those formulas. If you may need to edit or audit them later, paste into a separate range or save a duplicate workbook first.

  • Selecting a mismatched destination. When moving results elsewhere, start at the destination’s top-left cell and ensure the range has room for every copied row and column. Pasting over existing content can replace it.

Tips

  • Use a separate results column when you need a safety check. Paste values beside the formulas, compare several rows, and only replace the original formulas after confirming the copied results. This is useful for reports that will be shared as a snapshot.

  • Preserve the display of dates, percentages, and currency. If the result needs to look exactly like the source, use the Paste menu’s Values & Number Formatting option when available. This copies values and number formats, but it does not copy every visual property. You may still need to apply borders, fills, or alignment separately.

  • Remember that values are snapshots. A pasted value will not update when its inputs change. This is useful for archiving, sending a static report, or preventing a recipient from seeing formulas, but it is unsuitable when the destination should remain linked to changing data.

  • Paste one continuous block at a time. A single rectangular range is easier to match to its destination than several separated selections. For a large table, include the full intended data area and verify that headers or totals are included only if you want them.

  • Use Undo only while it is available. If you accidentally replace formulas, press Ctrl+Z on Windows or Command+Z on Mac before doing more work. Once you close the workbook or perform actions that clear the undo history, restoring the formulas may require reopening a saved version.

Troubleshooting

The cells still show formulas after pasting. The regular Paste command may have been used, or the selected Paste Special option may not have been Values. Undo, copy the source again, open Paste Special, explicitly select Values, and confirm. Click a pasted cell and inspect the formula bar to verify what is stored; a cell can display a number while still containing a formula.

The pasted date or percentage looks wrong. The underlying value may be correct while the destination uses a different number format. Select the affected cells and apply the appropriate format from Home > Number, such as Short Date, Percentage, or Currency. If you want to carry over the source number format during the paste, repeat the operation using Values & Number Formatting. A date showing as a large number is often a date serial displayed with General formatting, not a failed paste.

Excel will not let you paste. Confirm that the copied outline is still visible and that you have selected one starting cell rather than an incompatible, differently sized destination range. If the sheet is protected, ask for edit access or unprotect it if you are authorized. Merged cells, filtered lists, and multi-area selections can also complicate pasting; try a single unmerged rectangular range in a blank area to identify the cause.

The pasted numbers do not match what you expected. Paste Values records the calculated results Excel had at the time of the paste. If the workbook uses manual calculation, or the source depends on changing data, the displayed result may be stale. Recalculate the workbook, confirm the source figures, then repeat the copy. If formulas refer to external data, check that the workbook has refreshed that data before taking the snapshot.

You need numbers only, but some cells became text or errors. Values preserves the result of every selected cell; it does not pick only numeric results. Undo if necessary, then select only the cells you intend to transfer. If the range includes mixed result types, review it first or use a suitable filter or selection process to isolate the numeric entries before copying. Do not assume that Paste Values will discard unwanted text or error cells.

Frequently Asked Questions

Does Paste Values remove the formula permanently?

It replaces the formula in the destination cells with its current result. The formula is gone from those cells unless you undo immediately, restore a saved version, or copy it from another location. Pasting into a different range leaves the original formulas intact.

Can I paste values over the same cells?

Yes. Select and copy the formula cells, then use Paste Special > Values with that range as the destination. This converts the formulas to fixed results in place. Save a copy first if you might need the formulas later.

Will Paste Values keep the cell formatting?

Not all formatting. The basic Values option pastes cell contents, not fonts, fills, or borders, and the destination’s existing number format can affect how a result looks. Choose Values & Number Formatting when you also need the source number formats.

Can I use this method between worksheets or workbooks?

Yes. Copy the source cells, open the destination worksheet or workbook, select the top-left destination cell, and choose Paste Values. Make sure the destination is editable and large enough. The pasted results are static and do not retain formula links to the source cells.

Does Paste Values copy only numbers?

No. It pastes the results of all selected cells, including text and errors if those are the formula results. Select only the numeric-result cells before copying if non-numeric entries must be excluded.

What is the quickest Windows shortcut?

Copy with Ctrl+C, press Ctrl+Alt+V, choose Values with V, then press Enter. If your Excel version or keyboard handles the dialog differently, use Home > Paste > Values instead.

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.