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

Lazy Cheating Bum’s Guide To Excel Shortcuts

January 19, 2016 by terp Leave a Comment

How Can I Become A Lazy, Cheating Bum With Excel Shortcuts?

Excel shortcuts are for “lazy” people (actually, for smart and efficient people).  But I’d like to take laziness to another level — and show you how to be lazy about being lazy.

excel-shortcuts-cheating

Excel provides some easy ways to discover shortcuts, or remind yourself of them if you’ve forgotten.  These methods work with some types of shortcuts, and only in some situations.  However, they can be very useful, especially while you’re learning shortcuts.  Or, if you’re too lazy to remember shortcuts, this is your easy way out.
[Read more…]

Filed Under: Alt Shortcuts, Cut Copy Paste, Delete, Excel Shortcuts, Menu Key, Paste Values Tagged With: Alt Shortcuts, Excel Shortcuts, Format Painter, Paste Values

Excel Paste Special Shortcuts To Make You Faster

September 2, 2015 by terp Leave a Comment

Basic Paste

The fastest way to cut, copy and paste is by using the keyboard shortcuts Ctr+X, Ctr+C and Ctr+V.  Ctrl+V performs the basic paste operation — and includes the formulas and formatting, if any.  But sometimes you want to do more — or less — when pasting.  And pasting can be used in ways you’ve never imagined.  Enter Paste Special.

Paste Special

The animation below shows some of the neat things Paste Special can do in Excel: pasting just values (no formatting or formulas), pasting a picture (that you can move around) and pasting formatting onto other numbers.

Excel-Paste-Special-Basics

[Read more…]

Filed Under: Convert Text To Numbers, Copy & Paste, Excel Shortcuts, Paste Special, Paste Values Tagged With: Excel Shortcuts, Menu Key, Paste Special, Paste Values

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