Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

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

Excel Magic: 4 Clever Shortcuts To Copy And Paste Simultaneously

September 20, 2016 by terp Leave a Comment

Ready For Some Magical Excel Shortcuts?

Did you know you can copy and paste simultaneously in Excel?

Just use Ctrl+D, Ctrl+R, Ctrl+Enter or Autofill.

excel-copy-paste-ctrl-d-r-enter-autofill

These magic tricks don’t fit every situation.  But when they do fit, they’re lightning fast.

Below is a magic show — and after that the magic tricks are discussed. [Read more…]

Filed Under: Copy & Paste, Double Click, Mouse Shortcuts Tagged With: cut copy paste, Double Click, Excel Keyboard Shortcuts, Excel Mouse Shortcuts, Excel Shortcuts

Excel Chart Shortcuts: Hybrid Mutants

September 8, 2016 by terp Leave a Comment

Hybrid Excel Chart Shortcuts: How To Format, Select Data and Modify Fonts

When you right click on a Chart (or in any other context), you typically get a “context menu” that looks something like the ones further down the screen.  Context menus give you a sort of hidden shortcut option I call “hybrid” shortcuts.  They work by simply typing the underlined hot key for a menu option — rather than clicking on it.

I call these shortcuts “hybrid” shortcuts because they’re part keyboard shortcut, part mouse shortcut.  If they were animals, they might be half-man, half-beast.  Kind of like the mutants below.

excel-hybrid-pivot-shortcut-images

My favorite hybrid shortcuts involve virtually no extra motion from my hands.  My left hand stays on the left side of the keyboard and my right hand stays on the mouse.  Call me lazy.

[Read more…]

Filed Under: Charts, Excel Shortcuts, Font, Formatting, Hybrid shortcuts Tagged With: Charts, Excel Mouse Shortcuts, Excel Shortcuts, Font, format, Hybrid Shortcuts

4 Shortcuts To Delete Excel Worksheets

June 7, 2016 by terp Leave a Comment

4 Easy Ways To Delete Excel Worksheets

Below are four different shortcuts to delete Excel worksheets.  The second one is the fastest, and hence my favorite.

(1) Right-clicking: RC-<Delete> while hovering over the tab.  You’ll see the following when right-clicking over the tab — just click on Delete:

excel-delete-worksheet

(2) Hybrid shortcut: RC-D (Right-Click, followed by typing ‘D’).  This does the same thing as RC-<Delete>, except you’re using the hot key instead of clicking.  The ‘D’ is underlined in Delete, which means you can just type ‘D’ instead of clicking on Delete.  I call this a “hybrid” shortcut since it combines mouse and keyboard into one shortcut.  This is the fastest (typing ‘D’ is faster than clicking on ‘Delete’). [Read more…]

Filed Under: Alt Shortcuts, Delete, Excel Shortcuts, Hybrid shortcuts, Keyboard Shortcuts, Mouse Shortcuts, Right Click Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Mouse Shortcuts, Excel Shortcuts

Double-Click Excel Shortcuts

January 13, 2016 by terp Leave a Comment

What are some great double-click Excel shortcuts?

Double-clicking in Excel is like lighting dynamite — it tends to “explode” or expand things.

ExcelDoubleClickDynamite

Here are my favorite double-click shortcuts — what about you?

AutoFit: Double click on the edge of a column (or row) to automatically resize it to the widest (or tallest) column (or row) (you can do a similar thing with the bottom of the formula bar) [Read more…]

Filed Under: Double Click, Excel Shortcuts, Mouse Shortcuts Tagged With: Double Click, Excel Mouse Shortcuts, Excel Shortcuts

8 Types Of Excel Shortcuts (Ctrl, Shift, Ctrl+Shift, Alt, F-Key, QAT, Mouse, Hybrid)

December 1, 2015 by terp Leave a Comment

How Many Types Of Excel Shortcuts Are There?

Excel shortcuts come in eight basic flavors (there are more but these are the main ones):

  1. Ctrl shortcuts (which use the Ctrl key)
  2. Shift shortcuts (which use the Shift key)
  3. Ctrl+Shift shortcuts (which use the Ctrl and Shift keys together)
  4. Alt shortcuts (which use the Alt key)
  5. F-key shortcuts (which use the F-keys)
  6. QAT shortcuts (which use the Quick Access Toolbar)
  7. Mouse shortcuts (which use the right-click menu)
  8. Hybrid shortcuts (which use both the mouse (typically right-clicking) and the keyboard)

Below, I’ll go through each type of shortcut briefly, with a few examples of each.

But first, here is an animation of Alt shortcuts to whet your appetite:

excel-alt-shortcut-filter

[Read more…]

Filed Under: Cut Copy Paste, Delete, Excel Shortcuts, Format Cells, Hybrid shortcuts, Keyboard Shortcuts, Navigation Shortcuts, Right Click, Save Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Mouse Shortcuts, Excel Shortcuts, F-Key Shortcuts, Hybrid Shortcuts, Quick Access Toolbar - QAT

  • 1
  • 2
  • Next Page »

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