Apply Currency Formatting

An Excel Keyboard Shortcut

This Excel tip covers applying currency formatting to selected cells in an Excel spreadsheet using a keyboard shortcut.

The key combination that can be used to apply currency formatting to data is:

• Ctrl + Shift + 4

Example of How to Apply Currency Formatting using a Keyboard Shortcut

Note: For help with this example, see the image to the right.

1. Add the following data to cells A1 to B2: 7.98, 5.67, 2.45, -3.92
   
   
2. Drag select cells A1 to B2 to highlight them.
   
   
3. Press and hold down the Ctrl and Shift keys on the keyboard.
   
   
4. Press and release the number four key ( 4 ) on the keyboard without releasing the Ctrl and Shift keys.
   
   
5. In cells A1, A2, and B1 the dollar sign ( $ ) should be added to the data.
   
   
6. In cell B2, because the data is a negative number, it should be red and surrounded by round brackets in addition to having the dollar sign ( $ ) added.
   
   

Other Keyboard Shortcuts

• Adding the Current Date
• Adding the Current Time
• ALT - TAB Fast Switching in Windows