To copy a formula’s result without copying the formula in Excel, select the cell or range, press Ctrl+C, choose the destination, then use Home > Paste > Values. This pastes the current results as fixed values, so the destination no longer calculates from the original formula. You’ll need an open workbook and a destination cell or range where you can paste.
What You’ll Need
- Excel for Microsoft 365 on Windows for the steps below. The same Paste Values option is available in Excel for Mac and Excel for the web, though the menus and shortcuts can differ.
- A cell or range to copy and a destination for the pasted results. The destination can be in the same worksheet, another worksheet, or another workbook.
- If you want to keep the original formulas, paste into a separate destination rather than over the source cells.
Step-by-Step
- Select the cells you want to copy. Click a single cell, or drag across a range. To select a range using the keyboard, click its first cell, hold Shift, and select its last cell. You can also click the Name Box to the left of the formula bar, type a range such as B2:B15, and press Enter. Check that your selection includes only the results you want to transfer.
- Copy the selection. In Windows, press Ctrl+C, or choose Home > Copy. A moving dashed border appears around the copied cells. Copying, rather than cutting, leaves the original cells in place. If the source contains formulas, the copied cells still have formulas temporarily; the next step changes what gets pasted.
- Choose the destination. Click the top-left cell where the pasted results should begin. If you are pasting into another worksheet, click that sheet’s tab first. Make sure the destination area is empty or that you are comfortable replacing its contents. When pasting a multi-cell range, Excel fills cells to the right and down from the selected starting cell.
- Open the Paste Values choices. On the ribbon, go to Home > Paste and select the Values option, usually shown with a clipboard and a 123 icon. Depending on the Excel window size, you may need to open the Paste dropdown to see the icons. You can also right-click the destination and choose the Paste Values icon from the context menu.
- Check that the result is no longer a formula. Click one of the pasted cells and look at the formula bar. It should show the cell’s result or stored value, not an expression beginning with an equals sign. The destination cell will not update if the original formula’s inputs later change.
- Use the keyboard alternative if you prefer. In Excel for Microsoft 365 on Windows, copy with Ctrl+C, click the destination, press Ctrl+Alt+V to open Paste Special, choose Values, and confirm with Enter. The Paste Special dialog can look different in some Excel versions. If the shortcut does not open it on your device, use the ribbon or right-click menu instead.
- Repeat for other ranges as needed. After a successful paste, you can select another source range and repeat the process. If you need to paste into a separate workbook, keep both workbooks open, copy the source, switch to the destination workbook, and choose Paste Values there.
Excel’s Paste Values command pastes the results stored in the copied cells, not their formulas. For a formula that displays words, the pasted result will generally be text. A formula that returns a number or date pastes a number or date value instead. Paste Values does not turn every kind of result into text; it removes the formula while retaining the underlying result.
For example, if a cell displays the word Approved because a formula produced that word, Paste Values puts Approved in the destination as a fixed text value. If a formula calculates 25, the destination contains the number 25. In either case, changing the cells that fed the original formula will not change the pasted value.
Common Mistakes
- Choosing regular Paste instead of Paste Values. Ctrl+V normally pastes formulas along with other cell content. If the destination formula changes when you copy it, undo with Ctrl+Z right away and repeat using the Values option.
- Expecting Paste Values to preserve the original appearance. Values-only paste does not necessarily copy the source cell’s font, fill, borders, or number format. The destination may display a date as a serial number or a decimal without currency formatting if its existing format differs.
- Assuming a value is now text because it came from a text-producing formula. Paste Values keeps the result’s type. Words remain text, but numbers and dates remain numeric values, which is often useful for later calculations.
- Pasting over the formulas you still need. If you paste values onto the source range, those formulas are replaced by their current results. Keep a backup or paste into another area if you may need the formulas later.
- Selecting the wrong destination size. With a range, the paste starts at the active destination cell and can replace existing cells below or to the right. Confirm the size and location before pasting.
- Copying a formula result that has not recalculated. If calculation is set to Manual, the displayed result may be out of date. Check Formulas > Calculation Options and recalculate the workbook before copying if current results matter.
Tips
- Use the right Paste Values option for the job. The plain Values option pastes results without bringing over source formatting. In the Paste dropdown, Excel may also offer Values & Number Formatting, which keeps number formats such as dates, percentages, or currency while leaving out the formula. Icon labels and availability can vary slightly with window size and Excel version.
- Keep source formatting when needed by applying it separately. If you want the destination to look like the source but do not want formulas, first paste values and then use Home > Paste > Formats to apply formatting. This is a separate paste operation and does not bring formulas over.
- Use Paste Values for a fixed snapshot. This is useful for sharing a report, preparing a static export, or freezing calculations before archiving a worksheet. Remember that a pasted value will not refresh when the source data changes.
- Check the formula bar, not only the displayed cell. A formula and its result can look identical in the worksheet grid. Selecting the pasted cell and checking the formula bar is a quick way to confirm that the formula is gone.
- Use the context menu when ribbon icons are hard to find. Right-click the destination and inspect the Paste Options icons. Hover over an icon, when available, to see its tooltip before selecting it.
- For Excel for Mac, use the Paste Values menu option. Copy with Command+C, select the destination, then use Home > Paste > Values or the right-click Paste Values option. Keyboard shortcuts for Paste Special differ between Mac and Windows, so the ribbon or context menu is a reliable alternative.
- For Excel for the web, look for Paste Values in the Home tab or context menu. Browser and keyboard settings can affect shortcuts. If a shortcut pastes normally, undo it and use the visible Paste Values option instead.
Troubleshooting
The pasted cell still shows a formula. You probably used ordinary Paste. Select the destination, press Ctrl+Z to undo if the paste was just made, and paste again through Home > Paste > Values. Then click the cell and check the formula bar. If you already made other changes after the paste, be careful about undoing: Ctrl+Z reverses the most recent action first.
The result looks different after pasting. The underlying value may be correct while the destination’s number format changes how it appears. For example, a date may show as a number, or a percentage may show as a decimal. Undo if needed, then use Values & Number Formatting if that option appears, or apply the appropriate date, percentage, or currency format afterward using Home > Number Format.
The destination shows a blank or an unexpected result. Check the original cell first. The formula might return an empty string, an error, or a result that has not updated. Select the source cell and inspect the formula bar and displayed result. If it shows an error such as #N/A, Paste Values will copy that error; fix the source or decide whether the error should be retained before copying.
Paste Values is missing or disabled. Make sure you have copied cells in Excel and selected a destination cell. If the clipboard has been cleared or you copied content from another application, Excel may not offer the same paste choices. Copy the source cells again, then reopen the Home tab’s Paste menu. In a protected worksheet, the destination may also be locked; use an allowed cell or ask the workbook owner about protection settings.
The paste changes more cells than expected. Undo immediately if the pasted range replaced content you need. Select only the intended source cells, then click one destination cell at the top-left of the area. Excel will size the pasted block to match the copied range. Check for merged cells in either area, since merged layouts can prevent a rectangular range from pasting as expected.
The result changes when the source changes. This usually means the destination still contains a formula or a link. Click the destination and inspect the formula bar. If it begins with an equals sign, repeat the paste using Values. A genuine value-only paste is fixed and does not recalculate from the original cells.
Frequently Asked Questions
Does Paste Values remove formulas permanently?
It replaces formulas in the destination with their current results. The original source formulas remain unless you paste over them. If a formula is replaced and you need it back, use Undo immediately or restore it from a saved copy.
Can I copy just text from a formula that returns words?
Yes. Copy the cell and paste with Values. The destination contains the displayed text as a fixed text value rather than the formula that generated it.
Does Paste Values keep formatting?
The plain Values option does not copy the source formatting. The destination’s existing format remains. Use Values & Number Formatting when available if you want to retain number formats, or paste formats separately.
Can I paste values between worksheets or workbooks?
Yes. Copy the cells, switch to the destination worksheet or open workbook, select the starting cell, and choose Paste Values. Keep the workbooks open during the operation and check that the destination range is correct.
How do I copy a displayed value as plain text?
Paste Values removes the formula but does not force numbers or dates to become text. If the destination must contain text exactly as displayed, first make sure the copied result is text, or use a text-conversion process appropriate to the data. For preserving display formatting while removing a formula, try Values & Number Formatting and verify the destination.
Will the pasted value update when the formula changes?
No. Paste Values creates a snapshot of the result at the time you paste. If you need the destination to update automatically, copy the formula normally instead.
Related
- Close Research in Excel: Shortcut Key and Full Steps
- How to Close the Research Pane in Excel on Windows
- Close a New Window in Excel Without Closing the Workbook
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for BMI Calculation (Step-by-Step)The Excel formula for BMI (Body Mass Index) is =weight_kg/(height_m^2) when your data is in kilograms and meters.…
- Excel COUNTIFS With Multiple Criteria in One RangeYes. Excel’s COUNTIFS can apply more than one condition to the same range by repeating that range for…
- Excel Formula for Weekday: Get Day of WeekThe core Excel formula for a weekday is =WEEKDAY(date), which returns a number from 1 (Sunday) to 7…
- Excel INDEX MATCH: How to Build Flexible Lookup FormulasIn Excel, combine INDEX and MATCH to find a value in one range and return the corresponding value…
- Excel Formula for Quarter From Date: 3 Easy MethodsIf the date is in A2, use =ROUNDUP(MONTH(A2)/3,0) to return its calendar quarter as a number from 1…
- C++ Function Syntax: A Complete GuideThe basic syntax for a function in C++ is return_type function_name(parameter_list) { body }. For example, int add(int…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.