To copy results without copying their formulas in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+C, choose the destination, press Ctrl+Alt+V, press V, then press Enter. Excel pastes the current values rather than the formulas, so the copied cells will not recalculate from the original references.
What You’ll Need
- An Excel workbook with the cells you want to copy.
- A destination range in the same workbook or another workbook. If you are replacing formulas in place, make sure you are ready to keep their current results instead of the formulas.
You do not need to change workbook settings or add an add-in. If the source cells contain formulas, Excel copies their displayed results as values. If they already contain typed numbers or text, those are copied as values too.
Step-by-Step
- Select the source cells. Click and drag across the cells you want, or click the first cell and Shift-click the last cell in a continuous range. To select a whole column or row, click its heading. Check that the selection includes only the cells you intend to copy; copying a large range can also carry blank cells over the corresponding destination cells.
- Copy the selection. Press Ctrl+C on Windows. A moving dashed outline appears around the copied range. You can also choose Home > Copy on the ribbon or right-click and choose Copy. Do not cut the cells: cutting moves the contents and is not the method for making a separate values-only copy.
- Choose the destination. Click the top-left cell where the pasted results should begin. If you are pasting into a different workbook, open that workbook and select the destination cell there. Confirm that the destination area is empty or that you are comfortable overwriting its contents. Excel expands the paste across the size of the copied range.
- Open Paste Special. Press Ctrl+Alt+V. The Paste Special dialog opens. If Excel shows a compact paste menu instead, use the menu or ribbon method in the next step rather than choosing the ordinary Paste command.
- Choose Values. In the Paste Special dialog, select Values, then select OK or press Enter. The keyboard sequence after opening the dialog is V, then Enter. The destination now contains the source cells’ values, not their formulas. On the ribbon, use Home > Paste and choose the Values option, commonly shown with a 123 icon. In some layouts, the Values option is visible in the paste menu without opening the full dialog.
- Check a pasted cell. Click one of the destination cells and look at the formula bar. A formula cell should show its result there, such as 25 or a text label, rather than a formula beginning with an equals sign. You can also edit the original source value and check that the pasted result stays unchanged.
- For an in-place conversion, paste onto the same range. Select and copy the formula cells, then keep that same range selected and choose Paste Special > Values. This replaces each formula with its current result. Verify the results before saving, because the original formulas are no longer in those cells.
On Mac, copy with Command+C and use Home > Paste > Paste Special, then choose Values. The ribbon/menu route avoids relying on a Windows shortcut that may differ on your keyboard or Excel version. In Excel for the web, use the Home tab’s Paste menu and choose the values-only option, or use the right-click paste options if they are available in your browser. The menu labels and icons can vary slightly by interface.
Common Mistakes
Choosing ordinary Paste. Ctrl+V normally pastes formulas, formatting, and other copied content. If you need only results, choose the Values option explicitly. A copied formula can look like a number in the cell while still being a formula; the formula bar is the quickest way to tell.
Confusing values with formatting. Paste Values transfers the results but does not bring over the source cell’s formatting. The destination keeps its existing number format. That means a date or currency value might appear as a plain number, or as a date or currency according to the destination format. If you want the source number formats as well, open Paste Special and choose Values and number formats, where available, rather than Values alone.
Overwriting useful formulas. Pasting values back onto the source cells removes the formulas from those cells. If you might need to update the results later, paste into a separate area or save a copy of the workbook first. For an in-place replacement, ensure the source results are current and correct before proceeding.
Copying an incomplete range. If a formula refers to nearby cells, selecting only part of the intended table can leave some formulas or values behind. Check the selection border and the destination size before pasting. Also remember that blank cells within a selected range may be pasted as blanks and overwrite existing destination content.
Assuming the copied result is a live link. A values-only paste is a snapshot of what the formulas returned at the time of copying. It will not update when inputs change. That is the point of the operation, but it may be the wrong choice if you need the destination to stay connected to the source.
Tips
Use values-only copying when preparing a report to share, archiving a calculation at a particular point in time, or moving results into a workbook where the original formulas and references are not needed. It is also useful when sending a sheet to someone who should see the results but should not depend on your source workbook’s links or calculation setup.
For a quick repeat, use the keyboard sequence after you have selected the destination: Ctrl+Alt+V, V, Enter. The V key selects Values in the Windows Paste Special dialog. If the dialog does not open or the keystrokes behave differently because of a customized keyboard, use Home > Paste > Paste Special and select Values by name.
To preserve the source’s appearance, decide whether you need just values, values plus number formats, or values plus all formatting. Values alone is usually the cleanest choice when the destination already has its own layout. If the destination is blank and should look like the source, apply the desired formatting separately or choose the appropriate Paste Special option; avoid choosing an all-content paste if formulas must not come across.
For a large conversion, consider keeping a backup or duplicate sheet until you have checked the results. After pasting, use the formula bar to inspect several cells, including dates, percentages, text results, and any cells that previously displayed errors. If the copied range contains formula errors, the error values are copied too; values-only paste does not correct a calculation problem.
When copying between workbooks, make sure both workbooks are open and select the destination workbook before pasting. The values themselves do not need the source workbook’s formulas to remain available. However, if the source formula has not recalculated or depends on unavailable external data, its current result may be stale or show an error. Review those results before making a permanent values-only copy.
Troubleshooting
The formula appears in the destination. The paste may have used ordinary Paste instead of Paste Special. Undo immediately with Ctrl+Z, then repeat and choose Values from the Paste Special dialog or Home > Paste menu. Confirm by clicking the pasted cell and checking that the formula bar does not begin with an equals sign.
The destination shows an unexpected number or date. The value may be correct but the destination format may not match the source. Select the destination cells and choose a suitable number format from Home > Number, or repeat the paste using Values and number formats if that option is present. For example, a date stored as a number can display as a serial number under the General format.
Excel will not paste into the selected cells. Check whether the sheet is protected, the destination includes merged cells, or the copied and destination ranges have incompatible shapes. Try an unmerged, unprotected destination area and start by selecting only its top-left cell. If a warning says the destination is occupied, verify that overwriting it is intended before continuing.
The values do not match what you expected. A formula may not have recalculated, or its result may depend on external links, volatile inputs, or a changed calculation setting. Check the source formula and its displayed result before copying. If needed, recalculate the workbook with F9 on Windows, then copy and paste values again. Do not treat an error result such as #N/A as a usable number; resolve or intentionally retain the error before converting.
The shortcut behaves differently. Use the ribbon route, which is less dependent on keyboard layout: Home > Paste > Paste Special > Values. On Mac, use the corresponding Home tab or Paste menu and select Values. In Excel for the web, use the paste options shown in the browser interface. If you are using a remote desktop or browser, its keyboard shortcuts can intercept key combinations.
Frequently Asked Questions
Does Paste Values remove formulas from the original cells?
No. When you paste into a different destination, the source formulas remain unchanged. They are replaced only if you paste values directly over the source range.
Will the copied values update when the original data changes?
No. Values-only paste stores the results as fixed cell contents. To get updated results later, copy and paste values again, or keep formulas in the destination instead.
Can I paste values without changing the destination formatting?
Yes. Choose Values, not a formatting option. Values-only paste leaves the destination’s existing formatting in place. If the destination is formatted as General, a date or percentage may not look like it did in the source.
Can I copy values from one workbook to another?
Yes. Copy the range, switch to the other open workbook, select the destination cell, and use Paste Special > Values. The pasted results do not require the source formulas to remain in the destination workbook.
Can I use this for cells that contain text or errors?
Yes. Excel pastes the current result, whether it is a number, text, a blank result, or an error value. Values-only paste does not remove or fix errors, so inspect the source results first if errors are not wanted.
Related
- How to Close an Open Dialog Box in Excel
- How to Close an Excel File With a Keyboard Shortcut
- How to Convert an Excel Workbook to Word Documents
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Copy Values Without Formulas in Excel: Step-by-StepTo copy formula results without copying the formulas in Excel for Microsoft 365 on Windows, select the cells,…
- Excel Table Filters: Can You Filter Only Some Columns?Excel tables do not have a built-in setting to show filter arrows on only selected columns: the table’s…
- Excel Uppercase to Lowercase: Shortcut and FormulaExcel has no dedicated keyboard shortcut that changes selected text from uppercase to lowercase. The dependable method is…
- Excel IF Statement for Dates: Compare Dates and Set RulesWith due dates in A2:A20, enter a formula in B2 to label each date as overdue or not:…
- How to Round Numbers in Excel to the Nearest ThousandIf the value is in A2, enter =ROUND(A2,-3) to round it to the nearest thousand; for example, 1,234,567…
- How to Find Repeated Names in Excel with COUNTIF FormulaTo find repeated names in Excel, put names in A2:A100, then enter =COUNTIF($A$2:$A$100,A2) in B2 and fill it…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.