Keyboard Shortcuts to Format Spreadsheet Cells

If you frequently have to format cells after you've typed the information, you may want to take note of some of these keyboard shortcuts that allow you to format cells as you go. This information is for Excel 2007, Excel 2010, and Excel 2013.

Zip Codes

If you enter a zip code like 08976, Excel will assume it is a number and will drop the leading zero to display 8976 in the active cell. If you enter an ' (apostrophe) before the value, Excel will accept the zip code as text.

Currency

To format a number as currency, type a $ (dollar sign) immediately before the value. For instance, type $200.00 for 200 dollars in currency format.

Fractions

In Excel 2007 and Excel 2010, if you type 1/2 (1 slash 2) in an Excel cell, the resulting value will be the date 02-Jan. To enter a value in fraction format, precede your fraction by the number 0 (zero) > Press the spacebar > Type the fraction. In Excel 2013, you can just type 1/2 to get the desired result.

Percentages

Enter the percent as a whole number (i.e., 75) followed immediately by a % (percent sign).

Email this to a Friend

Help Page Feedback

Did this content help you? *


What is your opinion about the content? *


Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty