1. Home
  2. Computing & Technology
  3. Spreadsheets

Apply Currency Formatting
An Excel Keyboard Shortcut

By , About.com Guide

Applying currency formatting using a keyboard shortcut

Applying currency formatting using a keyboard shortcut

© Ted French

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

More Spreadsheets Quick Tips
Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Tips and FAQs
  5. Keyboard Shortcuts
  6. Apply Currency Formatting - Excel Keyboard Shortcuts

©2009 About.com, a part of The New York Times Company.

All rights reserved.