Paste Just Values in Excel: Keyboard Shortcuts and Steps

How-to basics · Updated November 20, 2026

To paste only the results of copied cells in Excel for Microsoft 365 on Windows, copy the cells, select the destination, press Ctrl+Alt+V, choose Values, and press Enter. This keeps the copied results but leaves out their formulas and source formatting. You need a workbook with the cells you want to copy; the original cells can contain formulas, numbers, dates, or text.

The reliable shortcut is a short sequence rather than one key combination. It opens Excel’s Paste Special dialog, where you choose which part of the copied cells to paste. The steps below also cover ribbon, Mac, and Excel for the web alternatives, since available shortcuts can differ by app and version.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or the Excel version and device you normally use.
  • A source range to copy and a destination cell or range. If you are pasting a block of cells, make sure the destination has enough room and does not overlap the source unintentionally.
  • Permission to edit the destination workbook. If the sheet is protected, you may need to unprotect it or paste into an unlocked area.

Step-by-Step

  1. Select the source cells. Click a cell or drag across the range you want to copy. To copy a complete column or row, click its column letter or row number, but take care: pasting an entire column can replace much more data than intended. If the source cells contain formulas, Excel will copy both the formulas and their calculated results; you will choose to paste only the results later.
  2. Copy the selection. Press Ctrl+C on Windows. A moving dashed outline usually appears around the copied cells. Keep the copy operation active until you paste. If you click another cell or copy a different item, the clipboard contents may change.
  3. Choose the destination. Click the upper-left cell where the pasted result should begin. For a multi-cell source range, Excel will fill a destination block of the same size. You can select a destination range of matching dimensions instead, but selecting just its top-left cell is usually simplest. Check that you are not about to overwrite data you need.
  4. Open Paste Special. Press Ctrl+Alt+V. The Paste Special dialog appears. This is the standard Windows shortcut for opening the dialog; it does not paste values immediately, because you still need to select the paste type.
  5. Choose Values. In the dialog, select the Values option. In many Windows builds, pressing V moves to or selects Values; if it does not, use the mouse or Tab and the arrow keys to select the option. Do not choose Formulas, Formats, or Values and Number Formats if your goal is to leave out the source formatting.
  6. Confirm the paste. Press Enter or click OK. Excel places the copied cell contents as fixed results rather than formulas. The destination’s existing formatting remains in place, if there is any. The dashed outline may remain around the source; press Esc when you have finished pasting to clear copy mode.
  7. Check the result. Click one of the pasted cells and look at the formula bar. A formula source such as =A2*B2 should now appear as its calculated result, such as 24, rather than as a formula. Text and errors can also be pasted as values. If a date or number looks different, check the destination cell’s number format before assuming the paste failed.
  8. Use the ribbon if you prefer not to use the dialog shortcut. Copy the source, select the destination, then go to Home > Paste and choose the Values paste option. Depending on the ribbon layout, Values may appear as a clipboard icon or as an option in the Paste menu. Point to an option to read its tooltip before selecting it; choose Values, not the regular Paste command.

On a Mac: Copy the source with Command+C, select the destination, then use Excel’s Edit > Paste Special menu and choose Values in the dialog. You can also look under Home > Paste for the Values option. Mac keyboard layouts and Excel builds vary, so the menu is a dependable way to identify the correct option rather than relying on the Windows Ctrl+Alt+V sequence.

In Excel for the web: Copy the cells, select the destination, and use Home > Paste to choose the Values option, or use the right-click paste menu if it offers Paste Values. Browser and operating-system shortcuts can intercept key combinations, so use the ribbon if a shortcut opens a browser command or does nothing.

Common Mistakes

  • Pressing Ctrl+V and expecting values only. Ctrl+V performs a regular paste, which can bring formulas and source formatting along. Use Paste Special and explicitly choose Values when you need fixed results.
  • Choosing the wrong Paste Special option. Formulas copies formulas, while Formats copies appearance. Values and Number Formats also carries the source number format. For values only, select the option named Values.
  • Confusing displayed appearance with stored value. A cell showing $1,250 may contain the number 1250 with a currency format. Pasting Values transfers the underlying number, not necessarily the visual appearance. If the destination is formatted as General, it may show 1250; apply the desired number format afterward if appropriate.
  • Expecting a copied formula to keep updating. Pasting values intentionally removes the formula. The result is a snapshot of the calculated value at the time of copying, so it will not change when the source cells later change.
  • Pasting into the wrong-sized or wrong location. A multi-cell copy fills a block starting at the selected destination cell. Before confirming, check the active cell and consider whether the pasted block will overwrite existing entries.
  • Assuming a formula’s displayed result is current. If workbook calculation is set to Manual, a formula may not have recalculated before you copy it. Recalculate the workbook with F9 if needed, then copy and paste the updated result.

Tips

  • Memorize the Windows sequence: Ctrl+C, select the target, then Ctrl+Alt+V, choose Values, and press Enter. The dialog route works even when a dedicated paste-values shortcut is not available in your Excel build.
  • Use the Values icon for repeated work. The Home tab’s Paste menu can be quicker once you recognize its Values option. Hover over icons to see their names, especially if your ribbon is compact or customized.
  • Keep the destination formatting when it matters. Values-only paste is useful for filling a preformatted report or template because it does not copy the source cell’s font, fill, borders, or number format. If the destination has no suitable format, format it separately after pasting.
  • Paste a whole range at once. Copying and pasting an entire rectangular block is usually faster and less error-prone than repeating the operation one cell at a time. Confirm that the source and destination ranges are aligned the way you intend.
  • Use a temporary range for a large conversion. If you want to replace formulas with their current results in the original cells, first copy the range and paste Values back over the same range. Consider saving a separate copy of the workbook first, because this replaces the formulas and cannot be reversed after the undo history is lost.
  • Know what values-only includes. The result can be a number, text, a date serial, a logical value, or an error such as #N/A. Values-only does not turn an error into a blank or explain its cause; it simply pastes the existing result without its formula.
  • Do not rely on a newer one-step shortcut without checking. Shortcut support can vary between Excel builds, platforms, and browser contexts. If a shortcut such as Ctrl+Shift+V is recognized in your setup, confirm that the resulting paste is values only; otherwise use the Paste Special sequence or ribbon option described above.

Troubleshooting

The Paste Special dialog does not open. Make sure Excel is the active window and that you have copied cells in Excel. Press Esc once, copy the source again with Ctrl+C, select the destination, and retry Ctrl+Alt+V. On some laptops, function or modifier-key settings can affect shortcuts; use Home > Paste and choose Values instead. On a Mac, use the Edit menu rather than the Windows shortcut.

The formula appears in the destination. The paste may have been a regular paste or the Formulas option may have been selected. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then repeat the operation and explicitly choose Values. Click the pasted cell and inspect the formula bar to confirm the formula has been replaced by a result.

The pasted date or number looks wrong. Values-only paste does not bring over source number formatting. A date may appear as a serial number, or a decimal may display with fewer digits, depending on the destination format. Select the destination and apply a suitable format from Home > Number. If the underlying value is genuinely wrong, check the source cell and whether its formula had recalculated.

Excel will not paste the full block. Check that the copied range and destination are compatible, that the sheet is not protected, and that merged cells are not disrupting the destination layout. Try selecting only the destination’s top-left cell. If you are copying filtered or hidden data, verify that the copied selection contains the cells you meant to include.

The Values option is unavailable or behaves unexpectedly. Copy the cells again immediately before opening the Paste menu; Paste Special options depend on what is currently on the clipboard. If the source is from another application, Excel may offer different options. Copy the data within Excel when possible, or use the ribbon menu and choose the closest available values-only option.

Frequently Asked Questions

What is the keyboard shortcut to paste values in Excel on Windows?
Use Ctrl+Alt+V to open Paste Special, choose Values, then press Enter. This is a dependable multi-key sequence, not a single shortcut that pastes instantly.

Does Ctrl+Shift+V paste values in Excel?
It may work in some current Excel builds or contexts, but shortcut behavior can vary. If it does not clearly paste values in your version, use Ctrl+Alt+V and select Values, or use the Home tab’s Paste menu.

Can I paste values on a Mac?
Yes. Copy with Command+C, select the destination, then choose Edit > Paste Special > Values where available, or use the Values option under Home > Paste. The exact keyboard shortcut differs from Windows.

Will paste values keep my formatting?
It leaves out the source formatting and retains the destination’s existing formatting. If the destination is unformatted, the displayed result may look different from the source. You can apply number or cell formatting afterward.

Can I replace formulas with their current results?
Yes. Copy the formula cells, select the same range as the destination, and paste Values. This replaces formulas with their current results, so save a backup first if you may need to edit those formulas later.

Why does a pasted date show as a number?
Excel stores dates as numbers and uses number formatting to display them as dates. Values-only paste does not copy the source format, so apply a date format to the destination if it shows a serial number.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.