Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

How Do You Paste Special In Excel?

June 28, 2016 by terp Leave a Comment

What Is Your Excel Paste Special Profile

How do you Paste Special in Excel?  Leave a comment!

Are you an AA, AB, BA or BA?  See the questions below.

 

(1) How do you bring up the Excel Paste Special menu(s)?

(A) With the mouse (by right-clicking)?

(B) With the keyboard (with the menu key)?

(2) How do you select your Excel Paste Special option?

(A) With the mouse (by clicking)

(B) With the keyboard (by typing the hot key)

excel-paste-special-menu

I strive to be an AB (I right click to bring up the menu, then click on the hot key to choose the option).

But that’s only when the hot key is on the left side of the keyboard.

Why?  I prefer keeping my right hand on the mouse as much as possible.  I find it faster to click on an option than move my right hand off the mouse, onto the keyboard to type it, and then back to the mouse.  For example, I’ll do a RC-V (right-click-V) to Paste Values.  I call this a “hybrid shortcut” since it uses both the mouse and the keyboard.

But I won’t do a RC-N for Paste Links — I find it faster to just click on the Paste Link icon.  That would make me an AA in that situation (doing everything with the mouse) in this case.  Maybe I’m just lazy or averse to change…

If my right hand DOES happen to be on the keyboard already, then I’ll do a BB (everything with the keyboard).  For example, to do Paste Special in this situation, I’ll do a MK-N (menu-key-N).

What about you?  AA, AB, BA or BB?

Filed Under: Excel Shortcuts, Paste Special, Paste Values, Right Click Tagged With: Hybrid Shortcuts, Paste Special, Paste Values

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel