TheExcelAddict.com

The Excel Addict

Use This Keyboard Shortcut to Quickly Apply Currency Number Format

How often do you format numbers on your worksheets to Currency format?

You can easily click the currency command ($) on the Home tab but if your hands are on your keyboard, there's no need to reach for the mouse. Here's a quick keyboard shortcut that's easy to use and easy to remember.

Pressing CTRL+SHIFT+$ will apply the Currency format with two decimal places, a dollar symbol and negative numbers in red font to the cells you have selected.

The Excel AddictKeyboard shortcut to apply a current number format in Microsoft Excel

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict"

Subscribe at the TheExcelAddict.com.

You'll be amazed how much time you'll save just by learning a few of these tips.


Copyright All Rights Reserved by TheExcelAddict.com