Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

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

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

Top 12 High Frequency Excel Shortcuts Using The Ctrl Key

December 16, 2015 by terp 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…]

Filed Under: Cut Copy Paste, Excel Shortcuts, Format Cells, Navigation Shortcuts, Save Tagged With: cut copy paste, Excel Keyboard Shortcuts, Excel Shortcuts, Format Cells, Formatting, save, Selection and Navigation

Change Excel Column Width With Autofit & Paste Column Width

November 23, 2015 by terp Leave a Comment

How do I quickly adjust my Excel column width with AutoFit?

Sometimes you have columns that are too narrow to display what’s in them (or are so wide they leave extra space in every cell).  You may have a similar problem with your row heights.

excel-column-width-autofit

[Read more…]

Filed Under: Uncategorized Tagged With: Excel Shortcuts, Format Cells, Formatting

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

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