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

12 Basic Excel Data Analysis Shortcuts

September 14, 2016 by terp Leave a Comment

Easy Shortcuts For Excel Data Analysis

Below are 17 steps I take with fresh data, along with the shortcuts I use.

12 deal directly with data analysis; the other 5 are generic.

If you do a lot of Excel data analysis, these shortcuts will help you fly through your work much faster.  Consider them arrows in your quiver.

 

excel-data-analysis-shortcuts

[Read more…]

Filed Under: Alt Shortcuts, Charts, Find & Replace, Keyboard Shortcuts, Save, Sort Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts, Filter, Find & Replace, freeze panes

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

Use Excel’s Ctrl+Enter To Fill Multiple Cells Quickly

August 31, 2016 by terp Leave a Comment

How Do You Enter The Same Material Into Multiple Cells Quickly?

If you want to enter something in cell A1, and have the same value or formula extend down to A20, how would you do it?  Here are three methods that are commonly used:

  1. Copy and Paste (copy A1, then select A2:A20, and hit paste)
  2. Autofill (drag what you’ve entered in A1 all the way down through A20 using the autofill handle (or by double-clicking in some cases))
  3. Ctrl+D (fill-down shortcut — you enter into A1, then select A1:A20 and hit Ctrl+D)

Ctrl+Enter: A Less Common, But More Useful Fourth Way

Here’s a fourth one that’s simple, yet not as commonly used — and you’ll see that it’s also faster and more flexible:

4. Ctrl+Enter

So how does Ctrl+Enter work?

Simple: just select your whole range BEFORE you start typing.  Then, after you’re done typing, hit Ctrl+Enter instead of Enter.

[Read more…]

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

Excel Sort Shortcuts With Alt Key & Menu Key

August 23, 2016 by terp 2 Comments

Fast Excel Shortcuts For Sorting — Using the Alt Key

In an earlier post I talked about some Excel Sort Shortcuts using the Right-Click or Context Menu.

Here I’ll talk about some really fast Sort shortcuts using the Alt key, or “keyboard accelerators” or “key tips.”  As a bonus, I’ll reveal some fast ones using the Menu Key as well.

Below is a brief video showing you how fast these shortcuts are:

[Read more…]

Filed Under: Alt Shortcuts, Sort Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Shortcuts, Sort

  • 1
  • 2
  • 3
  • …
  • 9
  • 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