Master Paste Special Keyboard Shortcuts for Excel & Sheets

Master paste special keyboard shortcut techniques for Excel and Google Sheets. Learn Windows and macOS variants, practical workflows, and code examples to paste values, formulas, or formats without clutter.

Shortcuts Lib Team

February 21, 2026·5 min read

Keyboard Shortcuts Excel Shortcuts Windows Shortcuts Copy Pastе Special Mac Shortcuts

Paste Special Shortcuts - Shortcuts Lib — Photo by fancycrave1via Pixabay

What Paste Special is and why it matters

The paste special keyboard shortcut is a deliberate, surgical way to move data. Instead of blindly pasting everything you copied, you choose exactly what to bring into the destination: values, formulas, formats, comments, or validation rules. This precision is essential when you stitch together datasets from different sources, preserve calculations, or avoid dragging unwanted formatting into your target. According to Shortcuts Lib, mastering paste special is a foundational skill for power users who work with large spreadsheets or data pipelines. The keyword here is control: you decide what gets pasted, reducing errors and maintaining data integrity.

Excel Formula

' Example: copy A1:A5 and paste values into B1:B5
Range("A1:A5").Copy
Range("B1").PasteSpecial Paste:=xlPasteValues

In practice, paste special is not a single keystroke but a small workflow that can be memorized: open the dialog, select the mode, and confirm. This sequence is a universal pattern across Excel and Sheets, and it works well with additional shortcuts for navigation within dialogs. This approach also scales to automation scripts, where you can call paste special APIs from macros to ensure consistent results.

Why paste special matters: it keeps your destination clean, preserves the intended structure of your data, and minimizes manual edits when integrating multiple datasets. When you routinely paste data from external sources, the paste special keyboard shortcut becomes an indispensable tool in your productivity toolkit.

Keyboard shortcuts by environment: Windows vs macOS

Jump-starting a paste special operation relies on environment-specific shortcuts. On Windows, the typical path to the Paste Special dialog in many Office apps is Ctrl+Alt+V, which opens a menu where you can choose Values, Formulas, or Formats. On macOS, the equivalent path uses Control+Option+V to launch the same dialog. After the dialog opens, you navigate to the desired option using arrow keys and confirm with Enter/Return. In Google Sheets, paste special can be triggered more directly: Windows users press Ctrl+Shift+V, macOS users press Cmd+Shift+V to paste values only. This hybrid approach lets you optimize workflows across apps.

Bash

# Illustrative keyboard flow (textual, not literal keystrokes)
# Windows: open Paste Special dialog
Ctrl+Alt+V
# Navigate to Values and press Enter
V
Enter

# Google Sheets: paste values directly
Ctrl+Shift+V
Enter

Line-by-line breakdown:

Open the paste special dialog or invoke a direct paste mode.
Choose the mode (values, formulas, or formats).
Confirm to apply changes. This modular approach helps you adapt to data cleaning tasks quickly.

Common variations: some apps also expose a dedicated shortcut for values-only paste (Sheets: Ctrl+Shift+V / Cmd+Shift+V). In Excel for Mac, try Control+Option+V and then navigate with the keyboard. In environments where the UI supports quick access keys, pressing the underlined letter (for example, “V” for Values) can reduce steps significantly.

Practical workflows: Excel and Google Sheets with code samples

This section demonstrates practical use cases and provides code samples to automate paste special workflows. The first example shows Excel VBA to paste values from the clipboard; the second demonstrates Google Apps Script to copy cell contents as values within a sheet. These patterns help you reproduce paste special behavior in automated pipelines, ensuring consistent results across datasets.

VBNET

' Excel VBA: Paste values only from clipboard
Sub PasteValuesOnly()
    Range("A1:A10").Copy
    Range("B1").PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False
End Sub

VBNET

' Excel VBA: Paste formulas only from clipboard
Sub PasteFormulasOnly()
    Range("A1:A10").Copy
    Range("B1").PasteSpecial Paste:=xlPasteFormulas
    Application.CutCopyMode = False
End Sub

JavaScript

// Google Apps Script: paste values only in Sheets
function pasteValuesOnly() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getActiveRange();
  range.copyTo(range, { contentsOnly: true });
}

// Google Apps Script: paste formats only
function pasteFormatsOnly() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getActiveRange();
  range.copyTo(range, { formatOnly: true });
}

Line-by-line breakdown:

The VBA examples copy a source range and paste into a destination using xlPasteValues or xlPasteFormulas, isolating the paste action from other clipboard attributes.
In Apps Script, range.copyTo with contentsOnly or formatOnly mirrors the concept in Sheets, letting you control what to paste programmatically.
You can extend these templates to loops, to processes that move data between sheets, or to pipelines that enforce specific paste rules consistently.

Common variations: if your data includes merged cells or specific number formats, adapt the PasteSpecial mode and test on a small sample first. For large data sets, consider turning off screen updating or calculation while running macros to speed up execution.

← More in Copy and Paste Shortcuts

What Paste Special is and why it matters

Keyboard shortcuts by environment: Windows vs macOS

Practical workflows: Excel and Google Sheets with code samples

Related Articles