Keyboard Shortcut for Paste Values in Excel: Quick Guide

Learn the keyboard shortcut for paste values in Excel, with Windows and macOS steps, practical examples, and best practices to preserve data integrity. This guide from Keyboard Gurus covers step-by-step commands, tips, and common pitfalls.

Keyboard Gurus Team

March 27, 2026·5 min read

Paste Values in Excel - Keyboard Gurus — Photo by radekkulupavia Pixabay

Quick AnswerDefinition

Paste values in Excel means pasting only the resulting data, not formulas or formatting. The standard keyboard route is through Paste Special: Windows users press Ctrl+Alt+V to open the Paste Special dialog, then press V to select Values, then Enter to confirm. On macOS, use Cmd+Ctrl+V, then V and Return. These sequences help preserve your data while discarding formulas.

What paste values means in Excel

In Excel, cells can contain static values or formulas. When you copy and paste, Excel often transfers formulas, not just their results. Paste values changes that behavior by pasting only the calculated results, removing dependencies on source formulas. This is essential when you want to finalize a dataset for sharing, reporting, or data validation. The Keyboard Gurus team emphasizes that knowing the keyboard shortcut for paste values in Excel accelerates workflows and reduces mistakes when handling large ranges. Below are safe, repeatable methods that work across common Office versions and operating systems.

Bash

# Windows quick path (Paste Special: Values)
Ctrl+Alt+V
V
Enter

Bash

# macOS quick path (Paste Special: Values)
Cmd+Ctrl+V
V
Return

These sequences paste only the resulting values, discarding formulas and most formatting. If a particular version of Excel presents a different dialog layout, remember that you can still reach the same result by selecting Values in Paste Special.

Windows vs macOS: paste values keyboard shortcuts

Windows and macOS implement paste values differently, but the goal is identical: keep data, drop formulas. The Windows route commonly starts with opening the Paste Special dialog via Ctrl+Alt+V, then pressing V and Enter to apply Values. On macOS, the equivalent is Cmd+Ctrl+V, followed by V and Return. The Keyboard Gurus analysis shows that users who habitually use Paste Special save time and avoid accidental formula propagation, especially in large spreadsheets.

Bash

# Windows example (Paste Special -> Values)
Ctrl+Alt+V
V
Enter

Bash

# macOS example (Paste Special -> Values)
Cmd+Ctrl+V
V
Return

If you rarely use Paste Special, you can also learn to access it via keyboard by navigating the ribbon or context menus, but the two sequences above cover the majority of use cases.

Practical usage: formulas vs values in real datasets

Imagine you’ve built a model with several cells containing formulas that reference a data table. You want to freeze the results before sharing the workbook with teammates. Using paste values ensures recipients see the final numbers without needing the underlying formulas. This is particularly important when exporting to CSV or distributing a snapshot of your analysis. Keyboard shortcuts simplify this transition and reduce the risk of accidentally copying formulas again in future edits.

Bash

# Step-by-step (Windows)
Select the target range with formulas
Ctrl+C to copy
Ctrl+Alt+V
V to choose Values, then Enter
Check the pasted results

Bash

# Step-by-step (macOS)
Select the target range with formulas
Cmd+C to copy
Cmd+Ctrl+V
V to choose Values, then Return
Verify results are values-only

Common variations and alternatives

Some Excel versions offer alternative paths to the same outcome. For example, the legacy Alt+E+S+V sequence (Alt navigation) has been used for Paste Special in older editions. If you primarily operate on Windows and prefer keyboard-only navigation, you can practice both routes: Ctrl+Alt+V, V, Enter and Alt+E+S+V, Enter. The key is consistently selecting Values and confirming. As you gain confidence, you’ll switch between methods depending on your current data layout and version.

Bash

# Legacy path (Windows) – Paste Special: Values
Alt+E+S+V
Enter

Bash

# Alternate path (Windows) – Paste Special: Values (with keyboard navigation)
Ctrl+C
Ctrl+V  # paste then switch to Paste Special using keyboard again
Alt+E+S+V
Enter

Quick tips and common mistakes to avoid

Always verify the destination range before pasting; a misclick can overwrite data.
When dealing with large ranges, consider selecting non-adjacent blocks to avoid unintended overlaps.
If you paste values over formulas, the original formulas are lost; keep a backup workbook just in case.
On macOS, ensure you’re using the correct Cmd+Ctrl+V combination; some keyboards may require adjusting to non-US layouts.

Bash

# Quick verification (Windows/macOS)
# After pasting values, press F2 to edit a cell and confirm it shows a value, not a formula

Steps

Estimated time: 15-25 minutes

1
Prepare the source and destination
Select the cells containing formulas whose results you want to paste, then select the target range where you want to paste the values. This ensures you know exactly where to paste and avoids overwriting unrelated data.
Tip: Double-check selection to avoid accidental data loss.
2
Copy the source values
Use Ctrl+C (Windows) or Cmd+C (macOS) to copy the selected cells. You’re copying the results as they appear, not the underlying formulas yet.
Tip: If you copy a large range, consider using the Name Box to select the range first for accuracy.
3
Open Paste Special and choose Values
Invoke Paste Special with Ctrl+Alt+V (Windows) or Cmd+Ctrl+V (macOS), then press V to select Values and Enter to paste.
Tip: If you’re using Alt-based navigation, Alt+E+S+V can be an alternative path on Windows.
4
Verify the results
Ensure the pasted area shows numbers and text derived from the original data, not formulas. If a formula remains, redo with the correct Values option.
Tip: Use F2 to edit a pasted cell and confirm there is no leading '=' indicating a formula.
5
Document the change
If you’re preparing a report, note that values were pasted to finalize data, and consider saving a separate version for traceability.
Tip: Keep a backup copy before large-scale paste operations.

Pro Tip: Practice both Windows and macOS sequences to speed up your workflow.

Warning: Pasting values will remove formulas; always keep a backup if you may need the original formulas later.

Note: Some Excel versions offer additional Values-related options like 'Values and Number Formats' in the Paste Special dialog.

Pro Tip: Use keyboard focus rings to verify the active cell after pasting.

Prerequisites

Required

Microsoft Excel (Windows) 2016 or newer↗
Required
Microsoft Excel (macOS) 2016 or newer↗
Required
Basic familiarity with keyboard shortcuts (Ctrl/Cmd, Alt, etc.)
Required
Access to a workbook containing cells to paste values
Required

Optional

Optional: Paste Special menu navigation reference (Alt+E+S or Ctrl+Alt+V)
Optional

Keyboard Shortcuts

Action	Shortcut
Paste values via Paste Special dialogOpens Paste Special and selects Values; best for cross-version compatibility	`Ctrl`+`Alt`+`V, V, Enter`
Legacy path via old shortcutsOlder Excel versions; use if you’re on a legacy system	`Alt`+`E`+`S`+`V, Enter`

Got Questions?

What is the fastest way to paste values in Excel on Windows?

The quickest built-in route is Ctrl+Alt+V, then V, then Enter to apply Values via Paste Special. This avoids pasting formulas. If you frequently do this, practice the sequence until it becomes second nature.

Can I paste values on a Mac without altering cell formats?

Yes. Use Cmd+Ctrl+V, then V, and Return. This pastes only the values, leaving most formatting unchanged. If you need to keep formatting, choose a different Paste Special option in the dialog.

Are there any alternatives to Paste Special for pasting values?

Some versions support a direct keyboard shortcut like Ctrl+Shift+V to paste values, but availability varies by version. If unsure, use Paste Special via Ctrl+Alt+V or Cmd+Ctrl+V to ensure consistent results.

Will pasting values keep data validation rules?

Pasting values typically preserves data validation in the destination cells but may overwrite existing validations. Always test on a small area first if the sheet relies on strict data rules.

What should I do if Paste Special values stops working?

Check if the source range is correctly selected and the destination allows pasting. If needed, reopen the Paste Special dialog with the keyboard path, or try restarting Excel to reset any temporary UI issues.

Can I automate paste values in a macro?

Yes. You can write a simple VBA macro that pastes values from the clipboard into a target range using Selection.PasteSpecial xlPasteValues. This is useful for repetitive tasks and ensures consistency.