Paste Values in Excel: Keep Results, Remove Formulas

To get paste values in Excel, copy the cells, select where the results should go, then choose Home > Paste > Values. Excel pastes the displayed results instead of the original formulas, so the pasted cells no longer recalculate when their source data changes. You can paste into a separate range or use the same method to replace formulas in place.

What You’ll Need

A workbook open in Excel for Microsoft 365, with the cells you want to copy visible or otherwise accessible.
Permission to edit the destination cells. If a worksheet is protected, you may need the password or an unlocked destination range.
A clear idea of whether you want to keep the destination’s formatting. Paste Values transfers results, not the source cells’ formatting.

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. To select a whole column of data, include only the cells you need when practical; copying a very large range can make the workbook slower and may overwrite other content. If you are copying a formula, its current calculated result is what Paste Values will place in the destination.
Copy the selection. On Windows, press Ctrl+C, or choose Home > Copy. On a Mac, press Command+C. A moving dashed border around the selection indicates that Excel has copied it. Do not press Esc yet, because that cancels the active copy.
Choose the destination. Click the top-left cell where the pasted results should begin. For a multi-cell range, make sure there is enough room to the right and below for the entire copied selection. You can select a destination range of the same size, but selecting just its top-left cell is usually simplest. Check that the destination does not contain data you need to keep, because pasting will replace it.
Open the Paste Values command. In Excel for Microsoft 365 on Windows, go to Home > Paste and choose the clipboard option labeled Values (the icon commonly shows “123”). In some ribbon layouts, select the arrow beneath Paste to see the choices. On a Mac or in Excel for the web, use the Home tab’s Paste menu and choose Values or Paste Values. The menu wording and icons can vary slightly by version, so use the label rather than relying only on the icon.
Check the pasted cells. Click one of the destination cells and look at the formula bar. A pasted result such as 125 should appear as a value, rather than as a formula beginning with an equals sign. Change a source cell, if appropriate, to confirm that the pasted result remains unchanged. Remember that a value can still be a number, date, text string, or error; Paste Values does not convert every result into plain text.
Replace formulas in place, if that is your goal. Select the formula cells, copy them, and paste Values onto the same selected range using the command above. This replaces each formula with its current result. Before doing this, consider making a copy of the sheet or workbook: once overwritten, the formulas cannot be restored by changing the source data, and a later save may make recovery difficult.
Use the keyboard route on Windows if you prefer. Copy the cells with Ctrl+C, select the destination, then press Ctrl+Alt+V to open Paste Special. Choose Values in the dialog and press Enter. Depending on the dialog and Excel build, the letter key V may select the Values option; check that the option is selected before confirming. On Mac, Control+Command+V opens Paste Special in many Excel configurations; choose the Values option, or use the ribbon menu if that shortcut is unavailable.
Use the result-only option for numbers when needed. The standard Values choice pastes results while leaving formatting behind. If you also need the source cells’ number formats—for example, to display a decimal result as currency—open Paste Special and select Values & Number Formats if that choice is available in your version. This still does not copy all formatting such as fill colors, borders, or font styling.

For example, suppose B2 contains a formula that adds the amounts in A2 and A3 and currently displays 48. Copying B2 and choosing Paste Values in C2 places the number 48 in C2, not the formula. If A2 later changes and B2 recalculates, C2 stays at 48. If the displayed result is a date or a percentage, the pasted underlying result is still a date serial or numeric value; what you see depends partly on the destination cell’s existing number format.

Common Mistakes

Choosing ordinary Paste instead of Values. Standard Paste usually copies formulas and formatting as well as cell contents. If the destination should keep fixed results, open the Paste menu and deliberately select Values.
Expecting source formatting to come along. Paste Values generally leaves the destination’s formatting in place. A number may therefore look different after pasting if the destination is formatted as General while the source showed currency or a date. Use Values & Number Formats when appropriate, or format the destination separately.
Overwriting formulas before checking the selection. Pasting values over the source range is useful for freezing results, but it destroys those formulas in the selected cells. Verify the highlighted range and save a backup if you might need to edit or audit the formulas later.
Selecting an incorrectly sized destination. A copied block needs room for all its rows and columns. A destination that overlaps important data can replace it, while merged cells or a filtered range can make the paste behave unexpectedly.
Assuming a pasted result will keep updating. A value is fixed at the time it is pasted. If you need the cell to recalculate as inputs change, keep the formula or copy the formula with ordinary Paste instead.

Tips

Use the Paste menu for clarity. Ribbon icons can look similar, especially when the window is narrow. Hover over an icon to see its tooltip, or open the menu and read the Values label before selecting it.
Keep a formula copy when the calculation matters. Duplicate the worksheet first, or paste results into a nearby column and retain the original formulas. This makes it easier to compare the fixed output with the calculation that produced it.
Plan number formatting separately. If a result needs to appear as a date, percentage, or currency, format the destination after pasting with the options on the Home tab. A value can be numerically correct even when its display looks unfamiliar.
Use Paste Values for exports and snapshots. It can help prepare a report that should not depend on formulas, external workbook links, or changing source data. Review the result before sharing, especially where formulas could have returned errors or blanks.
Use Undo immediately if the wrong cells change. Press Ctrl+Z on Windows or Command+Z on Mac to undo a paste, provided you have not performed actions that prevent the undo. Confirm that the original formulas and destination contents are back before continuing.

Troubleshooting

Values is missing from the Paste menu. First copy a cell or range in Excel; the paste choices may be unavailable if the clipboard is empty or if you copied from an app in a format Excel cannot interpret. Try Ctrl+C on Windows or Command+C on Mac, then reopen Home > Paste. If the ribbon is collapsed, expand it or open the Paste dropdown.
The cells still contain formulas. Click a pasted cell and inspect the formula bar. If it starts with an equals sign, ordinary Paste was likely used, or you pasted into a different range than intended. Undo, select the correct destination, and choose the explicit Values option. If the formula bar shows a constant but the cell looks formula-like, check that you are viewing the intended cell.
The pasted number or date looks wrong. Check the destination’s number format on the Home tab. Paste Values does not necessarily bring over the source display format, so a date serial may display as a number or a decimal may not show a currency symbol. Apply the appropriate number format, or repeat the paste using Values & Number Formats if available.
Excel will not paste into the selected area. Look for merged cells, a protected sheet, or a destination with a different shape from the copied block. Try an unmerged, editable range of the same dimensions. If a filter is active, be cautious: selecting visible cells and pasting into a filtered list can have different results from pasting into a continuous range. Check the selected cells and any hidden rows before proceeding.
The result is an error or blank. Paste Values preserves the formula’s current result; it does not repair the formula. If the source currently displays an error, the pasted cell will contain that error value. If it appears blank, the formula may return an empty string or the source cell may be empty. Fix or inspect the source first if you need a different result, then copy and paste again.
The Mac or web shortcut does not work. Keyboard shortcuts can differ by operating system, keyboard settings, and browser. Use the ribbon instead: copy the cells, open Home > Paste, and choose Values. This menu route is also a reliable alternative when the Paste Special dialog opens but its shortcut keys do not select the expected option.

Frequently Asked Questions

Does Paste Values remove formulas permanently?
It replaces the formulas in the destination cells with their current results. Undo may reverse the change immediately, but once you continue working, save, or close the workbook, you may not be able to recover those formulas. Keep a copy if you may need them.

Can I paste values over the cells I copied?
Yes. Copy the formula range, keep the range selected, and choose Home > Paste > Values. This freezes the current results in place. Check the highlighted range first, because this operation removes the formulas from those cells.

Will Paste Values copy colors, borders, or column widths?
No. It pastes cell results rather than the full formatting and layout. The destination’s existing formatting typically remains. Use a separate formatting paste option if you also need styles, and adjust column widths separately when needed.

Can I use Paste Values in Excel for the web?
Yes. Copy the cells, select the destination, then use Home > Paste and choose the Values option. Menu details can vary with the web interface, but the ribbon menu is preferable to assuming a desktop keyboard shortcut works in a browser.

What is the difference between Values and Values & Number Formats?
Values pastes the calculated results and generally leaves the destination’s formatting alone. Values & Number Formats also carries formats such as currency, percentage, or date display where the option is offered. It does not copy every visual style, such as borders or fill color.

Does Paste Values update when the original formula changes?
No. The pasted result is a snapshot of what the formula returned at the time of copying. To keep the cell linked to changing inputs, leave the formula in place or use ordinary Paste instead of 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.