Excel: Keyboard Shortcuts to Format Spreadsheet Cells

Cedarville's Center for Biblical and Theological Studies glowing in the evening light

Cedarville University

Excel: 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 2016, 2013, 2010, and 2007.

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.


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.


In Excel 2010 and Excel 2007, 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 2016 and 2013, you can just type 1/2 to get the desired result.


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

Keywords: abbreviations, short cuts, shorthand, automatic, zip code, automatically changing numbers

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