Faster At Excel

Number Formatting Shortcuts For Excel

by 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+^)

Top 12 High Frequency Excel Shortcuts Using The Ctrl Key

by Leave a Comment

The 12 Excel Ctrl Shortcuts I Use Most

Here are my favorite Excel Ctrl shortcuts — those I use most frequently, but in no particular order.  They’re my fave’s because they’re so easy on the hands.  Nine of the 12 can be executed with the left hand.  For these nine, your right hand can remain comfortably on the mouse, relaxing in a hot tub.  I’ll explain why I include the other three at the end of the post.

Cut, Copy & Paste

Ctrl+C: Copy (see more on Excel shortcuts for Save, Cut, Copy, Paste and Bold here)

Ctrl+V: Paste (see more on Excel shortcuts for Save, Cut, Copy, Paste and Bold here)

Ctrl+X: Cut (see more on Excel shortcuts for Save, Cut, Copy, Paste and Bold here)

Undo & Redo

Ctrl+Z: Undo

Ctrl+Y: Redo [Read more…]

Learn Excel Shortcuts — For Beginners

by 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…]