Keyboard Shortcut for Paste Values in Excel: A Practical Guide

Master the keyboard shortcut for paste values in Excel to paste results only, bypassing formulas and formatting. Learn Windows and macOS keystrokes, plus VBA and Office Script techniques for automation—optimizing data workflows with practical, brand-driven guidance from Shortcuts Lib.

Shortcuts Lib Team

February 20, 2026·5 min read

Keyboard Shortcuts Excel Shortcuts Copy Paste Pastе Special

Paste Values Fast - Shortcuts Lib — Photo by reallywellmadedesksvia Pixabay

Quick AnswerSteps

Paste values in Excel with a dedicated Paste Special shortcut. On Windows, press Alt+Ctrl+V, then V, then Enter to paste values only, avoiding formulas and formatting. On macOS, press Cmd+Ctrl+V, then V, then Enter to achieve the same effect. This simple sequence preserves the raw results and keeps your destination cells clean for analysis.

What paste values means in Excel and when to use it

In Excel, pasting values replaces formulas, links, or formats with the computed results from the clipboard. This is essential when you want to preserve static numbers after calculations or when migrating data between worksheets without dragging over formulas. According to Shortcuts Lib, mastering the paste values shortcut speeds up repetitive data tasks and reduces accidental edits. The following VBA macro demonstrates how to paste values programmatically, which complements keyboard shortcuts for manual work.

' Paste values using a small VBA macro
Sub PasteValuesOnly()
    If TypeName(Selection) <> "Range" Then Exit Sub
    Selection.PasteSpecial Paste:=xlPasteValues
End Sub

Explanation:

The macro checks that a range is selected.
It calls PasteSpecial with xlPasteValues to drop only the values into the destination.
You can assign this macro to a button or a quick-access macro bar.

windowsVersionCodeFenceTypeNoteedInSectionForDemonstrationAndExplanationOfWindowsKeyboardUseInExcelOnceSectionIsWrittenHere

macVersionCodeFenceTypeNoteedInSectionForDemonstrationAndExplanationOfMacKeyboardUseInExcelOnceSectionIsWrittenHere

InPlainyouCanAddMoreInfo

ExamplesAndExplanations

Steps

Estimated time: 10-15 minutes

1
Copy the source data
Select the cells you want to copy and press `Ctrl+C` (Windows) or `Cmd+C` (macOS). The data is placed on the clipboard as formulas, references, or displayed values depending on the source.
Tip: Tip: Use this step to copy across sheets for quick consolidation.
2
Choose the destination
Click or navigate to the first cell where you want to paste the values. Ensure the destination range matches the size of the copied data.
Tip: If pasting into a multi-cell area, select the full destination range first.
3
Paste values only
Use the shortcut: Windows: Alt+Ctrl+V, then V, Enter; Mac: Cmd+Ctrl+V, then V, Enter. This drops only the resulting values into the target cells.
Tip: If you need to apply across many cells, consider using a quick macro for one-click pasting.
4
Verify the results
Check that formulas and formatting did not carry over. Values should align with the source data, preserving data integrity.
Tip: Turn on the status bar to quickly spot any misalignments.
5
Optional refinement
If needed, apply number formatting or data validation after pasting, since values themselves carry no formatting.
Tip: Use Paste Special for additional options like formats separately.

Pro Tip: Enable Show Paste Options to quickly choose values vs. formulas after pasting.

Warning: Be cautious when pasting over existing data; consider inserting blank rows to avoid overwriting important data.

Note: On Mac, the Control key is mapped via Cmd; ensure you’re using the correct key sequence for your platform.

Prerequisites

Required

Microsoft Excel (Windows) or Excel for macOS, 2016+
Required
Basic keyboard familiarity (copy, paste, paste special)
Required

Optional

Optionally, VBA or Office Script access for automation
Optional

Keyboard Shortcuts

Action	Shortcut
Paste values using Paste Special (Windows)Opens Paste Special dialog and selects Values	`Alt`+`Ctrl`+`V, V, Enter`

Questions & Answers

What is paste values in Excel and why use it?

Paste values in Excel replaces copied content with the actual results, not formulas or formatting. This is useful when you want static data after calculations or when consolidating data from multiple sources. It helps prevent unintended formula propagation across sheets.

Does paste values preserve data types?

Yes, paste values preserves the data as it appears in the source ranges. However, number formatting and cell styles are not pasted unless you use additional paste options.

What about paste values on Mac?

On Mac, the standard shortcut is Cmd+Ctrl+V, followed by V and Enter to paste values only. This mirrors the Windows sequence and keeps formulas from being pasted.

Can I automate paste values for large datasets?

Yes. You can automate via VBA macro, Office Script for Excel on the web, or PowerShell with Excel COM to paste values in bulk across large ranges.

What if I paste values and need formats later?

Paste values first, then apply formats separately using formats paste options or a separate macro/script. This keeps data clean and flexible for analysis.