How to Paste in Excel Without Formulas and Keep Values

Formulas & functions · Updated November 20, 2026

To paste in Excel without copying formulas, copy the cells, select the destination, then choose Home > Paste > Values (the clipboard icon marked 123). This replaces formulas with their current results while leaving the source cells unchanged. Before you start, make sure the formulas have calculated and that you know whether you also want to preserve the source formatting.

What You’ll Need

  • An Excel workbook with cells you want to copy. The cells can contain formulas, numbers, dates, or text.
  • A destination range in the same workbook or another workbook. If you are pasting a block, check that the destination has enough room and will not overwrite data you need.
  • Access to the Paste Values command. The instructions below are for Excel for Microsoft 365 on Windows; a Mac and Excel for the web have similar ribbon options, with some shortcut differences noted below.

Step-by-Step

  1. Check the source results. Look at the cells you intend to copy and confirm their displayed results are current. A formula can show an old result if calculation is set to manual. If the results look outdated, press F9 on Windows to recalculate the workbook, then check the cells again. This matters because Paste Values copies the result available at the time of copying, not a live connection to the formula.
  2. Select the cells to copy. Drag across the range, click its first cell and hold Shift while selecting the last, or select the relevant rows or columns. Avoid including extra cells unless you intend to paste their contents too. If you only need one column of results, select that column rather than an entire table; a smaller selection makes it easier to avoid overwriting unrelated information.
  3. Copy the selection. Press Ctrl+C on Windows. A moving border appears around the copied cells. Copying does not remove or change the original formulas. If you prefer the mouse, right-click the selection and choose Copy. Keep the selection copied until you complete the paste; copying another range replaces the clipboard contents.
  4. Choose the destination. Click the top-left cell where the copied results should begin. For a multi-cell selection, Excel fills the destination from that starting point using the same row-and-column layout. Check that the destination block is clear. Pasting into occupied cells replaces their contents, and a paste may overwrite more cells than the single destination cell you clicked.
  5. Paste values from the ribbon. On the Home tab, open the arrow beneath Paste and select Values, usually represented by a clipboard with 123. Do not choose the main Paste command if you need to remove formulas: ordinary Paste carries the formulas and other copied cell properties. Values puts the source results into the destination as fixed entries instead of formulas.
  6. Or use the Paste Special keyboard sequence. With the source copied and the destination selected, press Ctrl+Alt+V to open Paste Special, choose Values, then press Enter. In many Windows versions, pressing V selects the Values option, so Ctrl+Alt+V, V, Enter is a quick sequence. If the dialog looks different or the key does not select Values, use the mouse to choose the Values option rather than guessing.
  7. Check what was pasted. Click a destination cell that used to be a formula. The formula bar should show the result as a fixed number, date, text, or other value rather than a formula beginning with an equals sign. Compare a few results with the source, especially at the top and bottom of a large range. Then save the workbook so the values are retained.

On Excel for Mac, copy with Command+C and use Home > Paste > Values for the most straightforward method. The Paste Special shortcut differs from Windows; Control+Command+V opens Paste Special in many Mac installations, but the ribbon is more reliable if your keyboard settings or Excel version behave differently. In Excel for the web, use Home > Paste and choose the Values option where available. Browser clipboard permissions can affect ordinary paste, so use the ribbon command if a keyboard paste does not work.

Paste Values also works when copying between workbooks. Open both workbooks, copy the source cells, switch to the destination workbook, select the starting cell, and choose Values. If the copied formulas depended on other sheets or workbooks, the destination receives their calculated results, not those references. Keep the source workbook open until the paste is complete, and verify the pasted results before closing it.

Common Mistakes

  • Choosing ordinary Paste by habit. Ctrl+V normally pastes formulas along with copied cells. It is not the right command when the goal is to freeze formula results. Use the Values choice explicitly.
  • Confusing values with formatting. Paste Values is for cell contents, not for reproducing every visual property. Depending on the paste option selected, the destination may retain its existing appearance or show values without the source’s custom formatting. If you need the source’s number format too, choose Values & Number Formatting instead, if that option is shown. It pastes the results and number formats, but not the formulas.
  • Copying results before they have updated. If the workbook uses manual calculation, a formula’s displayed result may not reflect the latest inputs. Recalculate first, then copy. Otherwise, the pasted fixed value can be out of date even though the paste itself worked correctly.
  • Pasting over the wrong range. Excel starts a block paste at the cell you selected and expands it to fit the copied block. A single click does not limit the paste to one cell. Check the destination area and undo immediately with Ctrl+Z if you overwrite something accidentally.
  • Assuming a pasted number will look identical. A date, percentage, or decimal may display differently if the destination has a different number format. For example, the underlying date value can be correct while appearing as a serial number. The cell’s display and its stored value are related but not the same thing.

Tips

  • Use the ribbon when accuracy matters. Home > Paste > Values makes the choice visible and avoids relying on a shortcut that may vary by version or keyboard setup. After you have confirmed the Paste Special dialog options on your installation, the keyboard sequence can save time for repeated tasks.
  • Choose the right values option. If the destination should keep its existing formatting, use Values. If results should carry source number formats, use Values & Number Formatting. If you also want the source’s full visual styling, look for Values & Source Formatting. The labels and icons can vary slightly by Excel build, so read the option name before clicking.
  • Paste into a new area first when the source is important. If you are unsure which cells are included or how the results will appear, paste into a blank worksheet or a spare area. Confirm the results, then move or copy them into the final location. This reduces the risk of replacing original data.
  • Keep a distinction between a result and a live calculation. A pasted value will not update when the original inputs change. Use this method for snapshots, reports, exports, or values you want to preserve. Keep the formulas in the original range, or save a separate copy of the workbook, if you may need recalculation later.
  • Use the format painter or a separate format paste only when needed. If the values are correct but the appearance is not, you can copy the source formatting separately using Paste Special > Formats. Check the outcome afterward: formatting can change how dates, currency, percentages, and decimal places are displayed without changing the underlying values.
  • Consider filtered data before copying. When a list is filtered, the visible rows may not form one uninterrupted block. Inspect the selection and pasted layout before replacing data elsewhere. For a critical update, copy the visible results to a blank area first and confirm that rows line up as intended.

Troubleshooting

The destination still contains formulas. Undo the paste if possible, copy the source again, and use the explicit Values command rather than Ctrl+V. Click a destination cell and inspect the formula bar. If it begins with an equals sign, that cell still contains a formula. Make sure you selected Values in Paste Special, not Formulas or the standard Paste option.

The Paste Values option is unavailable or does nothing. First copy a cell range again, then select a destination cell and reopen the Paste menu. Paste options depend on having compatible copied content. If you are in Excel for the web, browser restrictions may interfere with keyboard paste; choose the command from the ribbon. If the menu is still unavailable, close and reopen the workbook or copy the cells within the same workbook as a check.

The pasted results are blank or unexpected. Recheck the source cells before copying. A formula may currently return an empty display, an error, or a stale result. Recalculate with F9 on Windows if calculation is manual, then copy and paste again. If the source result is an error, Paste Values will preserve that error as the result; it does not repair the formula that produced it.

Dates, percentages, or currency look wrong. The content may have pasted correctly while the destination’s number format changed how it appears. Select a destination cell and inspect the formula bar, then choose the appropriate number format from Home > Number. If you need the source’s date, percentage, or currency display, repeat the paste using Values & Number Formatting. Compare a few cells rather than assuming that a different display means the underlying value is wrong.

Some cells were overwritten or the block landed in the wrong place. Press Ctrl+Z immediately on Windows, or Command+Z on Mac, if the paste was the last action. Then select the correct top-left destination cell and verify the copied range dimensions before trying again. If additional edits have happened since the paste, undo may also reverse those edits, so check the workbook’s current state before continuing.

A table seems to restore formulas. Excel tables can use calculated columns that automatically fill formulas down a column. If formulas reappear after you paste values into a table column, undo and check the table’s calculated-column behavior and AutoCorrect settings. You can paste into a plain worksheet range to determine whether the table is involved, then decide whether the column should contain fixed values or remain a calculated column.

Frequently Asked Questions

Does Paste Values delete the original formulas?
No. It changes the destination cells only. The source formulas remain in place unless you paste over the source range itself.

Will pasted values update when the source data changes?
No. They are fixed results at the time you copied them. Copy and paste values again when you need a refreshed snapshot, or keep formulas if you need automatic updates.

Can I paste values into another workbook?
Yes. Copy the source range, switch to the other open workbook, select a destination cell, and choose Paste Values. The destination gets the calculated results, not the source formulas or their external references.

Does Paste Values keep colors, borders, and number formats?
Values is intended to paste contents rather than full formatting, so do not rely on it to reproduce the source’s appearance. Choose Values & Number Formatting for source number formats, or a values-and-source-formatting option when you also need visual styling. Check the destination after pasting because available options can differ slightly.

Can I paste only the displayed text?
Paste Values usually places the cell’s underlying value, not necessarily the exact string of characters shown on screen. A number displayed with two decimal places, for example, can retain more precision internally. If exact displayed characters are essential, copy the displayed text from the formula bar or convert the data to text in a suitable workflow, then verify the result.

What is the quickest reliable way to do this on Windows?
Copy with Ctrl+C, select the destination, then use Home > Paste > Values. For a keyboard-first workflow, try Ctrl+Alt+V, choose Values, and press Enter. Confirm the formula bar shows a fixed result, not a formula.

Related

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.