Thursday, October 17, 2013

Formatting Keyboard Shortcuts

Greetings Excel Enthusiasts! I had a big Excel class of 54 professionals start this week at Continuing Education Group (CEG), so I have been a busy boy.

If you read this blog regularly, you know that I’m a huge fan of Keyboard Shortcuts. Over time, these shortcuts can save you literally hours of work time (and even improve your image as the resident Excel Guru…).

We all need to Change the Number Format in a cell or range of cells on a regular basis. Right-clicking and pulling up a context-sensitive menu is a good solution, but using the keyboard is Even Faster!

The shortcuts all start with “Ctrl+Shift”, so they are pretty easy to remember. The following are the most commonly used tricks for quick number formatting:

1.   General = Ctrl+Shift+~

2.   Number = = Ctrl+Shift+!

3.   Time = Ctrl+Shift+@

4.   Date = Ctrl+Shift+#

5.   Currency = Ctrl+Shift+$

6.   Percentage = Ctrl+Shift+%

Although it may take a little time to become fully accustomed to using these shortcuts, the time invested will certainly be worth it in the long run. They may even Free up some time for a Vacation!

Cheers!

1 comment:

Unknown said...

these are great! Thank you for sharing! Getting ready for the expert level Excel 2010 exam and these definitely help!