Excel Keyboard Shortcut to Paste Values Without Formulas

Formulas & functions · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, copy the cells, select the destination, then press Ctrl+Alt+V, press V, and press Enter. This opens Paste Special and pastes the copied results as values, not as formulas.

The Windows shortcut, step by step

The shortcut is a short sequence: the first key combination opens the Paste Special dialog, and the next key selects its Values option. It works when a range has been copied in Excel and a destination cell or range is selected.

  1. Select and copy the cells you want, using Ctrl+C.
  2. Click the destination cell, or select the top-left cell of a destination range.
  3. Press Ctrl+Alt+V to open Paste Special.
  4. Press V to choose Values, then press Enter to paste.

In the English-language Windows dialog, the V key activates Values. If a different option is highlighted or the dialog behaves differently in a localized version, use the arrow keys to select Values and press Enter. The dialog’s options are also available with the mouse, so you do not have to memorize the letter key.

What Paste Values changes

When a copied cell contains a formula, Excel normally pastes the formula. For example, a cell displaying 24 might contain a formula that adds two other cells. Pasting that cell normally can bring the formula to the new location, where it may calculate a different result because its references adjust. Pasting Values puts the current result, 24, into the destination instead.

This is useful when you want to keep a result but remove its link to the calculation that produced it. The pasted value no longer updates if the source cells change. If the copied cells contain constants rather than formulas, values paste those contents as values as well.

Paste Values is not the same as taking a screenshot or copying only what appears on screen. Excel places the underlying cell contents into the destination. A date, for instance, is stored as a number with a date display format. If you paste only values into a cell formatted as General, that number might appear instead of a familiar date. The underlying value is still a date serial; the destination formatting determines how it looks.

How to use the ribbon instead

If you prefer not to use the dialog shortcut, the ribbon provides a direct way to choose the paste type. Copy the cells, select the destination, and use Home > Paste to open the paste options. Choose Values, often shown with a 123 icon. The exact arrangement of the paste buttons can vary with window size, but the Values option is in the Home tab’s Paste menu.

You can also right-click the destination and choose the Values paste option from the context menu. Excel may show several icons, such as Values, Formulas, and Formatting; hover over an icon to see its label if the meaning is not obvious. The ribbon and context menu are useful when you want to confirm the specific paste behavior before applying it.

The shortcut is especially convenient for repeated cleanup work: after you learn the sequence, it avoids opening the ribbon menu each time. The ribbon is a good choice when you are unsure which paste option you need or when you are working in an environment where keyboard shortcuts differ.

Values, formulas, and number formats are different

Paste Special offers several choices because a spreadsheet cell has more than one kind of content. A cell can have a value or formula, a number format, a font and fill, borders, comments or notes, and other properties. Choosing the wrong paste type can leave a sheet looking or behaving differently than intended.

  • Values pastes the results or contents without the formulas and without copying the source cell’s formatting.
  • Formulas pastes formulas rather than their current calculated results.
  • Formats pastes visual formatting, such as number formats, fills, and borders, without replacing the destination’s values.
  • Values & Number Formats pastes the values and their number formats, but not every visual property such as font color or borders.

That distinction matters for a report. If you paste a price such as 1250.5 as Values into a General-formatted cell, Excel may show 1250.5 rather than the source’s currency display. To retain currency or date presentation while removing formulas, use Values & Number Formats if that option appears in your Paste Special choices. If you also need borders or shading, apply those separately or use an appropriate combined paste option.

Common reasons to paste values

Values-only pasting is often a finishing step rather than a way to build a calculation. It can make a deliverable easier to share, prevent later source changes from altering a finalized result, or remove formulas before sending a copy to someone who needs the numbers but not the workings.

  • Freeze a calculation: turn a calculated total into a fixed amount after checking it.
  • Prepare a report: copy formula results into a presentation sheet without bringing along references to working tabs.
  • Stop external links: replace formulas linked to another workbook with their current results before distributing a copy.
  • Clean imported data: keep text or numeric results from formulas while removing helper calculations.
  • Avoid changed references: paste a formula’s result somewhere it should remain unchanged even if the original formula would adjust.

Consider a monthly summary whose total is calculated from a detailed transactions sheet. If the summary is approved and should remain unchanged in an archived snapshot, copy the total and paste Values in the archive. Keep the original formula-based workbook if you may need to recalculate or audit the total later. Values-only pasting removes the calculation, so it is not a substitute for retaining a source copy.

What happens with dates, errors, and blanks

Pasting values preserves the cell’s content, not necessarily the way it looked. Dates and times are numeric values with formats that make them readable as dates or times. If the destination has a different format, the same value can look different. Apply the appropriate number format to the destination if the appearance matters.

If a formula currently returns an error such as #DIV/0!, pasting Values copies that error result; it does not repair the calculation. Likewise, a formula returning an empty text string can leave a destination that looks blank, even though the pasted cell’s content is not the same as a genuinely empty cell. Check the source results before freezing them.

For a multi-cell selection, Excel pastes the copied cells in the same relative layout, beginning at the selected destination. To replace a destination range, make sure its size and shape are suitable for the copied range. Selecting just the top-left destination cell is often sufficient for a rectangular copy, but be careful not to overwrite nearby data accidentally.

Common problems and quick fixes

  • The dialog does not open: confirm Excel has an active copied range. The Paste Special options depend on what is on the clipboard; copying text from another application may not offer the same choices as copying cells inside Excel.
  • The paste looks unchanged: if the source already contains fixed values, the result will look the same. To check whether a cell contains a formula, select it and inspect the formula bar.
  • The result has an unexpected appearance: Values does not copy the source formatting. Use Values & Number Formats or format the destination afterward.
  • The result is an error: values-only pasting preserves the formula’s current error result. Fix the source calculation if you need a valid result, then copy it again.
  • The paste replaces cells you meant to keep: undo immediately with Ctrl+Z, if the action is still the latest operation, and select a safer destination.

Excel’s normal Undo can reverse a paste operation. However, if you have made later changes, undoing may also reverse those changes, so review the result promptly. Also note that pasting values is deliberately destructive to formulas in the destination cells: once overwritten, those formulas are not retained there.

Mac and Excel for the web

In Excel for Microsoft 365 on Mac, copy and select the destination as usual, then use Control+Command+V to open Paste Special. Choose Values in the dialog and confirm. Keyboard behavior can depend on the keyboard layout and Excel version, so if the key combination is intercepted or does not open the dialog, use the menu or right-click paste options instead.

Excel for the web runs in a browser, where keyboard shortcuts can interact with browser commands and may vary by browser. The reliable approach is to copy the cells, select the destination, then choose the Values option from the Home tab’s Paste menu or the context menu when available. If you use a browser shortcut, verify the result rather than assuming it performed a values-only paste.

Frequently Asked Questions

What is the shortcut to paste values in Excel on Windows?
Copy the cells, select the destination, then press Ctrl+Alt+V, V, and Enter. This opens Paste Special and chooses Values in the English-language dialog.

Does Ctrl+Shift+V paste values in Excel?
Do not rely on Ctrl+Shift+V as the standard Windows Excel values-only shortcut. Use Ctrl+Alt+V, then V and Enter, or choose Values from the Paste menu. Shortcuts can differ by platform, version, or application.

Can I paste values without losing number formatting?
Yes. Choose Values & Number Formats in Paste Special when available. The plain Values option does not copy the source number format, so a date, percentage, or currency amount may display differently in the destination.

Does Paste Values remove formulas permanently?
It replaces formulas in the destination with their current results. The source formulas remain unless you paste over them. Keep a separate copy if you may need the calculations later.

Can I paste values with the mouse?
Yes. Copy the cells, right-click the destination, and choose the Values paste option, or use Home > Paste > Values. This is useful when you want to inspect the available paste choices.

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.