Quick, clean, and to the point

Display the Paste Special dialog box

Windows shortcut 
Mac shortcut 

Use this shortcut to display the Paste Special dialog box. Paste Special is the gateway into many powerful operations, including paste Values, which you probably use every day. Note that this shortcut only works when data has been copied to the clipboard.

On Windows, once you have the Paste Special Dialog open, you can type a letter to select the particular command you want, for example:

  • F = Formula
  • V = Values
  • T = Formats
  • C = Comments
  • N = Validation
  • H = All using source theme
  • X = All except borders
  • W = Column widths
  • R = Formulas and number formats
  • U = Values and number formats
  • D = Add
  • S = Subtract
  • M = Multiply
  • I = Divide
  • B = Skip blanks
  • E = Transpose
You are an angel. I have been forever frustrated when searching for help and finding no one gets what you get...teach the basic principle first!! Thank you, Thank you! - Christine
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course