To copy the results of formulas without copying the formulas themselves in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+C, choose the destination, then use Home > Paste > Values. Excel pastes the displayed results as fixed values, leaving the source formulas unchanged unless you paste over them.
What You’ll Need
- An Excel workbook containing the cells you want to copy. The cells can contain formulas, numbers, text, dates, or a mixture.
- A destination cell or range with enough room for the copied results. If you want to keep the original formulas, choose a different destination from the source.
- Permission to edit the destination cells. Protected sheets or workbooks may block pasting.
Step-by-Step
- Select the cells to copy. Click the first cell and drag across the range, or click the first cell, hold Shift, and click the last cell. To select nonadjacent ranges, hold Ctrl as you click each range on Windows. Check the selection outline before copying so you do not include headings or nearby cells by mistake. For example, if a calculated total is in D2:D10, select only D2:D10 when you want just those results.
- Copy the selection. Press Ctrl+C on Windows. A moving dashed outline appears around the copied cells. You can also use Home > Copy or right-click the selection and choose Copy. Do not cut the cells: Ctrl+X would remove the source contents when you move them, rather than simply making a copy.
- Choose the destination. Click the upper-left cell where the results should go. For a range, Excel fills from that cell across and down using the copied range’s shape. Make sure the destination area is empty or that you are comfortable replacing its existing contents. If the copied area is five rows by two columns, select or provide space for five rows by two columns.
- Open the Paste Values command. On the Windows ribbon, select Home > Paste ▼ > Values. The Values option is usually shown with a clipboard or 123 icon. If the Paste menu is collapsed, click its arrow to display the paste choices. You can also right-click the destination and choose the Values icon under Paste Options. The icon may be easier to identify than a label in the context menu.
- Check the pasted cells. Click one of the destination cells and look at the formula bar. A pasted formula result should appear as a number, date, text, or other result, rather than starting with an equals sign as a formula would. The source cells should still show their original formulas if you pasted into a separate area. Check a few cells, especially when the copied range contains more than one kind of result.
- Use the keyboard alternative if you prefer. After copying and selecting the destination on Windows, press Ctrl+Alt+V to open Paste Special, press V to choose Values, then press Enter. In Excel for Mac, use the menu route Home > Paste > Paste Special > Values; the available keyboard shortcut can depend on the Mac keyboard and Excel setup. In Excel for the web, use Home > Paste > Paste Values if the command is available in the ribbon, or right-click and select the Values option.
- Save the workbook when the result is right. Pasting over formulas replaces them with fixed values, and that change may affect other cells that refer to those formulas. If you only need a static copy, paste the results into a separate area or a new worksheet. Save after checking the result, particularly if the workbook is important or shared.
For example, suppose a worksheet calculates monthly totals in a column. Copying that column with ordinary Ctrl+V usually copies the formulas too. Choosing Values instead copies the totals that are currently displayed. The destination no longer recalculates if the source data changes; the original formulas continue to recalculate if they have not been overwritten.
Common Mistakes
- Using ordinary Paste instead of Paste Values. Ctrl+V normally brings the formulas along with the cell contents. If the destination formula changes to refer to a different row or column, that is a sign you pasted formulas rather than fixed results. Undo immediately with Ctrl+Z, then repeat the copy and use the Values option.
- Pasting onto the source by accident. Paste Values is not a way to preserve the formulas in the cells being replaced. If you copy a formula range and paste its values back onto that same range, the formulas are replaced by their current results. Keep an untouched copy, paste elsewhere, or save a separate workbook before converting a large range.
- Expecting all formatting to come across. The Values option is intended to paste cell contents as values, not to duplicate the full formatting of the source. The destination’s existing formatting may remain, so a date can look like a serial number if the destination is formatted as General. If you need the result and its number format, choose Values & Number Formatting when that option is shown, or apply the needed format afterward.
- Copying only part of a result that spills into nearby cells. Dynamic-array formulas can display results across a spill range. Those displayed cells are controlled by the formula in the anchor cell. If you need a static version of the full result, select the entire displayed range and paste its values into a clear area outside the spill range. Do not try to type or paste into cells that belong to an existing spill range.
- Assuming the copied value will keep updating. A value-only paste is a snapshot of what Excel calculated at the time of copying. It does not keep a live link to the source formula. If you want the destination to update when the source changes, copy the formula normally or create a reference instead.
Tips
- Keep a live and a fixed version side by side. Put the original formulas in one column and paste values into another. This lets you compare changing calculations with a stable report-ready copy without risking the source.
- Use a new worksheet for a final report. Add a sheet with the plus button, copy the needed range, then paste values there. This is useful when you want to send a workbook containing results but do not want recipients to rely on formulas, linked data, or the original layout. Review confidential or hidden data separately; pasting values does not remove other workbook content.
- Choose the right paste variant. Values keeps the results without carrying over the source’s full formatting. Values & Number Formatting keeps the calculated contents and number formats, such as currency, percentage, or date display, while avoiding the formulas. If your Excel menu shows more than one Values option, pause and read the label before selecting it.
- Paste into a matching range. If you copy several columns and rows, click only the first destination cell and ensure the surrounding area has enough space. A blocked cell can stop the paste or produce a warning. For a single cell copied into a large selection, Excel may fill the selected cells with that value; avoid selecting a large destination unless that is what you intend.
- Remember that displayed and stored values can differ. A cell may display a rounded number while storing more decimal places. Paste Values transfers the calculated value, not necessarily the rounded appearance. If exact displayed rounding matters, use an appropriate number format or round the result in the original calculation before copying; do not assume the displayed digits are the only digits being saved.
- Use Paste Special when you need control. The Paste Special dialog offers distinct choices for values, formulas, formats, and other cell elements. Selecting Values is the key choice when formulas must not travel. Avoid selecting Formulas or All if the goal is to keep only calculated results.
Troubleshooting
- The destination still contains formulas. You may have selected the standard Paste button or pressed Ctrl+V. Undo the paste, copy the source again, and explicitly choose Home > Paste > Values. Click a destination cell and inspect the formula bar to confirm the cell contains a fixed result.
- The Paste Values choice is missing or unavailable. First copy a cell range; paste options may not appear until Excel has something on the clipboard. If the workbook is in a restricted editing state, enable editing if appropriate or ask for permission. In Excel for the web, some ribbon options vary with the browser and current selection, so try the right-click menu or open the workbook in the desktop app.
- The pasted dates or numbers look wrong. The underlying value may be correct but displayed with the destination’s number format. Select the destination and use Home > Number Format to choose a suitable format, such as Short Date, Currency, or Number. If a date appears as a large serial number, apply a date format rather than recopying it.
- You see a spill or overwrite warning. A destination cell may be occupied, merged, or part of a dynamic-array spill range. Choose a blank destination outside the spill range, remove or move obstructing contents if safe, and try again. Do not clear cells until you have confirmed that their contents are not needed.
- The values change before you copy them. Formulas may recalculate when workbook inputs change or when Excel recalculates. Confirm the source results are correct, then copy and paste values promptly. For volatile calculations or external data, make a separate copy of the workbook first and verify the snapshot after pasting.
- You replaced formulas and need them back. If the action just happened, press Ctrl+Z on Windows or Command+Z on Mac before making other changes. If the workbook has been saved, closed, or the undo history is gone, restore a prior version or recover the formulas from a backup. A value-only paste cannot reconstruct the formulas it replaced.
Frequently Asked Questions
Does Paste Values copy formulas?
No. It pastes the results currently calculated by the formulas as values. The destination does not update when the original inputs change, while the source formula remains in place if you paste somewhere else.
Can I paste values over the original formulas?
Yes, but that permanently replaces those formulas with their current results unless you undo the action or restore a backup. To preserve the formulas, paste into a different range or worksheet.
What is the fastest way to paste values in Excel for Windows?
Copy the range, select the destination, press Ctrl+Alt+V, press V, and press Enter. If the dialog does not respond as expected, use Home > Paste > Values instead.
Will Paste Values keep colors, borders, and number formats?
The basic Values option focuses on cell contents and does not copy all source formatting. The destination’s formatting can remain. Choose Values & Number Formatting if you need formats such as dates or currency and that option is available.
Can I paste formula results as plain text?
Paste Values pastes calculated results, but numbers and dates remain numeric values and can still be formatted or used in calculations. If you need literal text, format the destination as Text before pasting or convert the pasted cells to text afterward, then check that the characters display as intended.
Does this work in Excel for Mac and Excel for the web?
Yes. The Values paste option is available in current Excel versions, though the ribbon layout and keyboard shortcuts differ. On Mac or the web, use the Paste menu or right-click menu and choose Values; confirm the result in the formula bar.
Related
- Convert Excel to Word: Tables, Links, and Formatting
- How to Convert an Excel Sheet to Word
- How to Convert an Excel Spreadsheet to Word
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula for Last Updated Date in a Specific CellFor a live current date in Excel, use =TODAY(); for the current date and time, use =NOW(). Neither…
- How to Add Parentheses in Excel Formulas CorrectlyTo add parentheses in an Excel formula, edit the cell, type an opening parenthesis where you want a…
- How to Make Excel Sort Dates Correctly, Oldest FirstTo make Excel sort dates correctly, first ensure the date cells contain real Excel dates rather than text,…
- Excel UNIQUE Formula: Return a List Without DuplicatesIn Microsoft 365, Excel 2021, or Excel 2024, use =UNIQUE(A2:A100) to return a list of distinct values from…
- How to Compare Two Columns in Excel With a FormulaTo compare two Excel columns row by row, enter =IF(A2=B2,"Match","Different") in C2, then fill the formula down. This…
- Excel SUMIF After a Date: Formula and ExamplesTo sum values for dates strictly after a cutoff in Excel, use =SUMIF(A2:A100,">"&DATE(2024,1,1),B2:B100), where column A contains dates…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.