Skip to main content

Paste Special in Excel (macOS)

Press Control + Command + V to open the Paste Special dialog.

What it does

Paste Special lets you choose what to paste from what you copied: only the values, only the formulas, only the formats, or the column widths. Values is the common choice, because it turns formulas into their results. The dialog can also add, subtract, multiply or divide the copied numbers into the target cells, and swap rows and columns with Transpose.

More Excel shortcuts: Frequently used

  • Underline
  • Italic
  • New Workbook
  • Save As
  • Select All

All 95 Excel shortcuts for macOSThe full list has a search and a printable PDF.

Questions

What is the Excel shortcut for Paste Special on macOS?

⌃⌘V (Control + Command + V). Press it to open the Paste Special dialog.