Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

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

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

Basic Excel Shortcuts — FREE 1-Hour Course

August 17, 2016 by terp Leave a Comment

Want Basic Excel Shortcuts For Everyday Productivity?

Here’s my FREE one-hour course: Basic Excel Shortcuts For 11 Everyday Tasks: Get 65% Faster

I’ll teach you 16 basic Excel shortcuts to get 65% faster at 11 everyday tasks: Save, Copy, Paste, Cut, Undo, Redo, Bold, Italics, Underline, Find and Replace.

I’ll also show you how to memorize shortcuts — plus some neat tricks to make Excel remind you what the shortcuts are.

excel-shortcuts-smiley-face-excel-logo2

If you’re slow at Excel and want to become more productive, this course is custom made for you!  It’s easy to follow, and you only need to be a beginner in Excel.

The course has 9 lectures.

Get 65% faster at basic Excel tasks — in less than an hour!

Sign up now — before it’s no longer free!

Filed Under: Copy & Paste, Cut, Cut Copy Paste, Excel Shortcuts, Find And Replace, Formatting Tagged With: cut copy paste, Excel Keyboard Shortcuts, Excel Shortcuts, Find & Replace

Number Formatting Shortcuts For Excel

August 9, 2016 by terp Leave a Comment

Excel Number Formatting Shortcuts

If you don’t mind having both hands on the keyboard, here are some handy number formatting shortcuts — all using Ctrl+Shift.

The Currency, Percent and Exponential formats are probably easiest to remember since the shortcuts incorporate the format symbol itself.

Format

Example

Shortcut

General 12345 Ctrl+Shift+` (accent grave)
Comma (with 2 decimals) 12,345.00 Ctrl+Shift+1
Time 12:00 AM Ctrl+Shift+2
Date 18-Oct-33 Ctrl+Shift+3
Currency $12,345.00 Ctrl+Shift+4 (or Ctrl+$)
Percent 1234500% Ctrl+Shift+5 (or Ctrl+%)
Exponential 1.23E+04 Ctrl+Shift+6 (or Ctrl+^)

Filed Under: Formatting, Keyboard Shortcuts Tagged With: Excel Keyboard Shortcuts, Excel Shortcuts, Formatting

Excel Alt Shortcuts

October 4, 2015 by terp Leave a Comment

What are Excel Alt shortcuts?

If you’ve ever seen someone use both hands all day long on the keyboard in Excel, chances are they were using Alt shortcuts or “keyboard accelerators.”  So what are they and how do they work?

If you hit the Alt key you’ll see the Ribbon and the QAT (Quick Access Toolbar – just below the Ribbon) light up with letters or numbers.  See below.

excel-alt-shortcuts-ribbon

These letters and numbers guide you through keystroke sequences that allow you do do virtually anything with your keyboard — instead of clicking with your mouse — as I’ll explain below. [Read more…]

Filed Under: Alt Shortcuts, Cut Copy Paste, Excel Shortcuts, Formatting, Keyboard Shortcuts, Paste Special Tagged With: Alt Shortcuts, cut copy paste, Excel Keyboard Shortcuts, Excel Shortcuts, Paste Special

Learn Excel Shortcuts — For Beginners

September 14, 2015 by terp Leave a Comment

Do you feel slow in Excel?  Do you want to learn Excel shortcuts but don’t know where to start?  Let’s go through some easy and useful keyboard shortcuts, plus some simple ways to commit them to memory.

If you’re a beginner in Excel, you probably use the Ribbon a lot, which is the area below.

Excel-Ribbon

While this gets the job done, there are faster ways.  But where should you start?

I will briefly walk through three Excel actions that (a) you probably perform regularly, and (b) have easy shortcuts.  These actions are: saving, cutting/copying/pasting and formatting fonts.

You can also take my free one-hour online video course.  It covers even more: Save, Copy, Paste, Cut, Undo, Redo, Bold, Italics, Underline, Find and Replace. [Read more…]

Filed Under: Cut Copy Paste, Excel Shortcuts, Formatting, Keyboard Shortcuts, Save Tagged With: cut copy paste, Excel Keyboard Shortcuts, Excel Shortcuts, format, Formatting, save

  • 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