Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

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

5 Quick Data Set Up Excel Shortcuts

November 29, 2016 by Terp Leave a Comment

Excel Shortcuts For Data Set Up

Watch the 15-second video below to see if you can figure out the 5 shortcuts I used to set up the data for easier use  This is something you can do easily in 15 seconds any time you get a new data file that begins in A1 with a header row in row 1.  (Alternatively, you can also create a Table with Ctrl+T — which will do much of the same, but much more — and maybe some features and formatting you don’t want).

See if you can do it in under 15 seconds.

Scroll down for my solution.

Here are the tasks (starting point is cell D8):

  1. bold top row
  2. freeze top row
  3. add filters

CLICK ON THE GRAPHIC TO BEGIN THE 15-SECOND VIDEO CLIP

excel-shortcuts-data-set-up-gif

 

[Read more…]

Filed Under: Alt Shortcuts, Challenges, Data management, Excel Shortcuts, Excel Speed Tricks Tagged With: Alt Shortcuts, data, Excel Keyboard 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 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

Excel Zoom Shortcuts

June 14, 2016 by terp Leave a Comment

 What Good Is Zooming In Excel?

(1) it helps confirm that you’ve selected everything you want to select (important with big selections where you’re using Ctrl+A or Ctrl+Shift+End).  Zooming out will show you clearly whether you’ve omitted anything.  In other words: it can save your @$$.

(2) it helps your eyes when you’re in the office until 11pm for the fourth straight night

(3) it helps you share your screen with someone standing behind you

(4) you tell me…

So here are some shortcuts so you can zoom faster in Excel.

 

Three Excel Zoom Shortcuts (Actually, Four)

Fastest: Ctrl+mouse-scroll — in other words, press the Ctrl key and (while it’s pressed) roll your mouse wheel forwards/backwards.  This will zoom you in and out, and you can see exactly how far (what %) you are zoomed in/out by looking at the Zoom Slider at the bottom right of Excel (see picture below).  It doesn’t get much easier than this.  You get to keep your hand on the mouse.  I call this a “hybrid shortcut” since you’re using both mouse and keyboard in one shortcut.

excel-zoom-slider [Read more…]

Filed Under: Alt Shortcuts, Hybrid shortcuts, Keyboard Shortcuts, Zoom Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel 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

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