Copy Values in Excel: Keep Results, Not Formulas

To copy only the displayed results of cells in Excel, copy the source range, select the destination’s top-left cell, then choose Home > Paste > Values. This replaces formulas with their current results and leaves the original cells unchanged. You can use the same method for fixed numbers or text, and it works in Excel for Microsoft 365 on Windows; Mac and web options are noted below.

What You’ll Need

An Excel workbook with the cells you want to copy. The source may contain formulas, numbers, text, or a mix.
A destination range that is large enough for the copied cells. If you are pasting into another sheet or workbook, open it before copying.
For formula cells, check that the results are up to date before copying. In most workbooks Excel recalculates automatically; if calculation is set to Manual, press F9 to calculate before you copy.

You do not need to change the original formulas or switch off calculation. Copying and pasting values creates a separate snapshot at the destination; it does not convert the source formulas.

Step-by-Step

Select the cells to copy. Click and 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 letter or number heading. If you only want the result of one formula, select that single cell.
Copy the selection. On Windows, press Ctrl+C, or choose Home > Copy. A moving dashed border around the cells indicates that Excel has copied them. Do not cut the range: cutting removes the original contents when you paste.
Choose the destination. Click the top-left cell where the copied results should begin. Excel will fill a destination area matching the copied range’s shape. For example, copying a 3-row by 2-column block beginning at A2 and selecting D2 will paste into D2:E4. If you are putting the results on another worksheet, click that sheet’s tab and select the destination cell while the copied range remains ready to paste.
Open the Paste Values option. On the ribbon, select Home, then open the arrow beneath Paste in the Clipboard group. Choose the Values option, usually shown with a 123 icon. Do not choose the regular Paste button if you want to remove formulas: regular paste copies formulas and formatting as well.
Check the pasted cells. Click a destination cell that came from a formula. Look at the formula bar: it should show a fixed result, such as a number or text, rather than a formula beginning with an equals sign. The source cells should still contain their original formulas.
Finish the copy operation. Press Esc if the moving border is still visible. Save the workbook if you want to keep the new fixed values. If the destination already had content, verify that the intended cells were replaced and no neighboring data was overwritten.

Keyboard method on Windows: copy with Ctrl+C, select the destination, press Ctrl+Alt+V to open Paste Special, choose Values, and press Enter. In many desktop versions, pressing V after the dialog opens selects Values, so Ctrl+Alt+V, V, Enter is a quick sequence. If that letter does not select the option in your installation, use the dialog’s Values choice and confirm. The dialog is useful when you want a keyboard-driven workflow or need a different paste option.

On Mac: copy with Command+C, select the destination, and use the Paste Values option from Home > Paste. Menu wording and ribbon layout can vary slightly by Excel for Mac release. If using Paste Special, open it from the ribbon or the Edit menu and select Values in the dialog; do not assume the Windows Ctrl+Alt+V shortcut works on a Mac. The Mac Command key replaces Ctrl for ordinary copy, but Paste Special shortcuts differ.

In Excel for the web: select and copy the range, choose the destination, then use Home > Paste and select the Values option if it is shown. The browser interface and available clipboard choices can vary. If the web app does not offer the option you need, open the workbook in the desktop version of Excel and paste values there.

Common Mistakes

Using regular Paste instead of Values. Regular paste can bring formulas across, often adjusting their cell references for the new location. Choose the 123 Values option specifically when you need fixed results.
Expecting the source formulas to disappear. Copying values affects only the destination. To replace formulas in the original cells themselves, copy the range and paste values back over the same range. Because that action removes the formulas, consider keeping a backup or a separate copy first.
Expecting the original appearance to come along. Values paste does not generally copy the source cell’s font, fill, borders, or number format. A pasted date may appear as a serial number, or a decimal may display differently, because the destination’s existing format remains in place. If you need the result plus its number format, choose Values & Number Formatting when that separate option is available.
Selecting a destination range that does not fit. For a rectangular source, select only the destination’s top-left cell and let Excel fill the matching area. If you select an awkwardly sized range or include cells you meant to preserve, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then repeat with the correct starting cell.
Thinking a copied error will turn into a normal number. If a formula currently returns #N/A, #VALUE!, or another error, paste values carries that current error result. Fix the source formula or data, recalculate, and copy again if you need a valid result.

Tips

Use values to freeze a result. If a calculation should not change when inputs change, paste its result into a new area or workbook. This is useful for a report snapshot, a final list for sharing, or a one-time export to a system that does not accept formulas.
Keep a formula copy when it may be needed later. Paste the fixed results into another sheet or a new workbook, and leave the original calculation intact. Add a label such as Snapshot date so it is clear that the copied numbers represent a point in time.
Remember that values are not always plain numbers. A formula may return text, a date serial, a logical result such as TRUE, or an error. Paste Values keeps the current result, but the destination’s formatting affects how numbers and dates look.
Preserve number formats deliberately. If a result must display as currency, a percentage, or a date, either format the destination afterward with Home > Number Format, or select Values & Number Formatting in the Paste menu. Check the result before sharing; a value of 0.25, for example, may display as 25% in a percentage-formatted cell but as 0.25 in General format.
Use the Paste Special dialog for other choices. The dialog can paste formulas, formats, or other available parts of a copied range. When the goal is to detach results from formulas, make sure the selected option says Values, not Formulas.
Copy only what you need. Large ranges can overwrite existing information or make a workbook harder to review. For a non-contiguous selection or data with hidden rows, check the destination carefully; selecting a clean, contiguous block is usually more predictable.

Troubleshooting

The destination still contains formulas. You may have chosen regular Paste or the Formulas option. Undo the paste, copy the source again, open Home > Paste, and choose Values. Confirm by clicking one of the pasted cells and checking that the formula bar contains a result rather than an expression starting with =.

The pasted result is old or unexpected. Excel may be using Manual calculation, or the formula may depend on inputs that have not been updated. Press F9 to recalculate, then inspect the source result before copying again. If the formula itself returns an error or an unwanted value, fix its inputs or logic first; pasting values will preserve whatever result exists at copy time.

A date or number looks different after pasting. The value may be present but displayed using the destination’s format. Select the pasted cell and inspect the formula bar to see its underlying value, then apply an appropriate format from Home > Number Format. Alternatively, undo and use Values & Number Formatting if that option appears in the Paste menu.

The paste option is unavailable or does nothing. Make sure you copied cells in Excel and that the destination is not in cell-edit mode. Press Esc, copy the source again, click a single destination cell, and retry. If the workbook or sheet is protected, check whether editing is restricted. In Excel for the web, browser clipboard behavior can also affect pasting; try the ribbon menu or open the workbook in the desktop app.

Excel reports that the copied and destination ranges differ. For a standard rectangular copy, select only the destination’s top-left cell rather than selecting a second range of a different size. If you are pasting into a filtered list, a merged-cell area, or a protected region, choose a simple unmerged destination range first. Those layouts can restrict or complicate a paste.

You overwrote cells by mistake. Use Ctrl+Z on Windows or Command+Z on Mac immediately. Then select the intended destination and paste again. If you have already made more changes and cannot undo safely, close without saving only if you are sure you do not need those changes, or recover an earlier workbook version or backup.

Frequently Asked Questions

Does Paste Values remove formulas from the original cells?
No. It places formula results in the destination and leaves the source cells unchanged. To remove formulas from a range, paste values over that same range, but keep a backup if you may need to edit the formulas later.

Can I paste values into the same cells that contain the formulas?
Yes. Copy the formula cells, then paste Values over the selected source range. The formulas are replaced by their current results. This is a one-way change unless you undo it or restore a saved copy.

Will the pasted values update when the original data changes?
No. A pasted result is a snapshot, not a live link to the original formula. If you need ongoing updates, use a regular formula paste or a suitable reference instead of Paste Values.

Does Paste Values copy formatting too?
The basic Values option is meant to paste results without the source formatting. The destination’s existing number format may affect how those results appear. Choose Values & Number Formatting if available and if you want the number format as well.

Can I paste values between worksheets or workbooks?
Yes. Copy the cells, switch to the destination sheet or open workbook, select the top-left destination cell, and choose Values. Check that the pasted results and formats look right, especially when the destination workbook uses different number formats.

What happens if a formula returns text or an error?
Excel pastes the current result, whether that result is text, a number, TRUE or FALSE, or an error such as #N/A. It does not preserve the formula that produced it when you use Paste Values.

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.