Paste Special Excel Shortcut: Copy Formula, Paste Values, Copy Format, Excel Transpose, and more…

There are many Excel shortcuts, but few are as versatile as the Paste Special command. Check out the video below and learn how to boost your financial modeling skills with this 7-in-1 Excel powerhouse.

And here a quick summary:

  1. Simple Copy & Paste:
    • CTRL + C (to copy to clipboard)
    • Enter (to paste)
  2. Copy & Paste Formats:
    • CTRL + C (to copy to clipboard)
    • CTRL + ALT + V (to bring up Paste Special Menu)
    • T (for the Formats sub-command)
    • Enter (to paste)
  3. Copy & Paste Formulas:
    • CTRL + C (to copy to clipboard)
    • CTRL + ALT + V (to bring up Paste Special Menu)
    • F (for the Formulas sub-command)
    • Enter (to paste)
  4. Copy & Paste Comments:
    • CTRL + C (to copy to clipboard)
    • CTRL + ALT + V (to bring up Paste Special Menu)
    • C (for the Comments sub-command)
    • Enter (to paste)
  5. Copy & Paste as Values:
    • CTRL + C (to copy to clipboard)
    • CTRL + ALT + V (to bring up Paste Special Menu)
    • (for the Values sub-command)
    • Enter (to paste)
  6. Copy & Transpose Values:
    • CTRL + C (to copy to clipboard)
    • CTRL + ALT + V (to bring up Paste Special Menu)
    • (for the Transpose sub-command)
    • Enter (to paste)
  7. Copy & Paste as Link:
    • CTRL + C (to copy to clipboard)
    • CTRL + ALT + V (to bring up Paste Special Menu)
    • (for the Paste Link sub-command)

Leave A Reply ( so far)


  1. sandra gates
    3 years ago

    Excellent summary! I will be using #6 Copy & Transpose a lot and this will save so much time.