Excel Keyboard Shortcuts Paste Values: A Practical Guide

Learn how to paste values only in Excel using Windows and macOS shortcuts, plus VBA automation. Shortcuts Lib guides you to speed data cleaning, avoid formulas, and verify results with practical examples.

Shortcuts Lib Team

February 21, 2026·5 min read

Keyboard Shortcuts Excel Shortcuts Windows Shortcuts Copy Paste Mac Shortcuts

Paste Values Fast - Shortcuts Lib — Photo by nattanan23via Pixabay

Quick AnswerDefinition

Paste values in Excel means inserting only the visible results of copied cells, not their formulas or formats. Mastering the paste values shortcut lets you preserve results while discarding formulas. According to Shortcuts Lib, learn both Windows and macOS shortcuts, plus a small VBA snippet for automation. This guide also covers how to paste values in place and how to validate results with simple checks.

Quick Start: Paste Values in Excel

Paste values means you copy a range and paste exactly what Excel calculated, not the underlying formulas or formatting. This is essential when you want static results, not dynamic references, or when sharing data with others who should not see formulas. According to Shortcuts Lib, this approach reduces workbook complexity and prevents accidental formula propagation across sheets. In practice, you copy a range, select the destination, and apply the paste-values action. The most reliable path in Windows is through Paste Special, while macOS users can access the same feature via the Paste Special dialog or keyboard shortcuts.

Excel Formula

Sub PasteValuesOnly()
    'Assumes data is copied to clipboard
    Selection.PasteSpecial Paste:=xlPasteValues
End Sub

This macro is a compact way to ensure only values are pasted, no formulas, but you still need to copy first. Another approach is to convert formulas to values in place using a simple VBA snippet:

Excel Formula

Sub ConvertToValues()
    With Selection
        .Value = .Value
    End With
End Sub

Pros: fast, repeatable, preserves data types.
Cons: if you paste into a range with different formatting, you may lose formats you intended to keep.
Variations: you can apply to a named range, or wrap in an error handler to manage empty cells.

prerequisites_presented_in_block_to_be_parsed_by_qa?false? null? true? false?

Steps

Estimated time: 10-15 minutes

1
Copy the source data
Select the cells with formulas or values you want to duplicate and press the copy shortcut. This prepares the clipboard for a values-only paste.
Tip: Use Ctrl+C on Windows or Cmd+C on Mac for speed.
2
Choose the destination
Click or navigate to the starting cell where you want to paste the values. Ensure the destination range matches the source size to avoid truncation.
Tip: If pasting into a table, select only the body range to avoid header shifts.
3
Paste values via Paste Special (Windows)
Open Paste Special and choose Values. Use the shortcut: Ctrl+Alt+V, V, Enter to apply values-only paste.
Tip: If you have formatting you want to preserve, skip this step or choose Val from the Paste Special dialog.
4
Paste values via Paste Special (Mac)
Mac users can use Cmd+Ctrl+V, then V, Enter. Alternatively, use the menu: Edit > Paste Special > Values.
Tip: On Mac, the exact sequence may vary slightly with Excel versions.
5
Verify the result
Check a few cells to confirm formulas are gone and only computed values remain.
Tip: If formulas persist, redo with the exact Paste Special Values command.
6
Optional automation
If you paste values frequently, set up a tiny macro and assign a shortcut key.
Tip: Document the macro for future use.

Pro Tip: Use Paste Special values after filtering to paste only visible results.

Warning: Be aware: pasting values can overwrite existing data; back up the sheet first.

Note: In large datasets, run the operation on non-consecutive ranges to avoid performance issues.

Prerequisites

Required

Excel: Office 2016 or newer (Windows) or Office 2019/365 (Mac)
Required
A copied range ready to paste
Required
Basic familiarity with Paste Special (Windows) or Paste Special (Mac)
Required

Optional

VBA editor access (optional for automation)
Optional

Keyboard Shortcuts

Action	Shortcut
Paste values in destination (Windows via keyboard)Opens Paste Special and selects Values; works after copying data	`Ctrl`+`Alt`+`V, V, Enter`
Copy and paste values quickly (alternative)Requires manual removal of formulas after paste; use Paste Special for true values	`Ctrl`+`C → Ctrl`+`V (not values-only)`
Quickly convert formulas to values in placeUseful for single-shot conversions without altering layout	`Select range → Type: .Value = .Value in VBA (paste values in place)`

Questions & Answers

What is paste values in Excel?

Paste values in Excel inserts the computed results from copied cells, not the formulas or formatting. This is useful when you want static data that won't change if the source workbook changes. It helps avoid unintended formula propagation when sharing data.

How do I paste values in Windows vs Mac?

In Windows, use Ctrl+Alt+V, then V, then Enter. In Mac, use Cmd+Ctrl+V, then V, Enter. You can also access Paste Special > Values from the right-click menu or Excel's ribbon. Shortcuts Lib covers these steps for speed.

Can I convert formulas to values without pasting?

Yes. You can convert in place by selecting the range and using a small VBA snippet (Selection.Value = Selection.Value). This assigns the current values back to the cells, removing formulas while keeping results.

Is there a Mac shortcut for paste values?

Yes. Mac users can paste values with Cmd+Ctrl+V, then V, then Enter. If your keyboard mapping differs, use Edit > Paste Special > Values from the menu. Shortcuts Lib outlines these options clearly.

How can I automate paste values across a range?

Create a small VBA macro like Sub PasteValuesOnly() Selection.PasteSpecial Paste:=xlPasteValues End Sub and assign it to a keyboard shortcut via the Macro Options. This makes repeated pasting fast and error-free.