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 (1 comment so far)


  1. sandra gates
    4 years ago

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


  2. REMONTDem
    5 months ago

    Your comment is awaiting approval

    Ohio governor * Video
    Ohio governor Ohio governor Ohio reintroduces ‘heartbeat’ abortion bill as new governor vows to sign it into law Ohio House passes anti-abortion ‘heartbeat bill’ When Ohio legislators in December passed the heartbeat bill, which would make abortions illegal once a fetal heartbeat can be detected, former Gov. John Kasich’s refused to sign it into law. But state legislators — who came one vote short of overriding Kasich’s veto — are giving new life to the bill, which is expected to pass in March. Ohio Gov. Mike DeWine, a pro-life Republican, has already vowed he will “absolutely” sign the controversial legislation. …
    The post Ohio governor * Video appeared first on Finance USA.

    [url=http://invest.remmont.com]San-francisco Finance[/url]