Home Up Bookstore Site Map Site Search

Excel 2003 Shortcut Keys

[Keys for General Use] [Keys for Moving and Scrolling on Worksheets] [Keys for Moving between Worksheet Panes, Worksheets, and Workbooks] [Keys for Entering Data] [Keys for Selecting Data and Cells] [Keys for Editing Data] [Keys for Formatting Data] [Keys for Printing and Previewing Spreadsheet Files] [Keys for Working with Names] [Keys for Working with Databases and Lists] [Keys for Outlining Data] [Keys for Working with Charts] [Keys for Working with PivotTables and PivotCharts] [Keys for Working with Objects]

Keys for Formatting Data

All shortcut keys are based on the U.S. keyboard layout. Keys on other layouts may not correspond exactly to the keys on a U.S. keyboard.

For keyboard shortcuts in which you press two or more keys together, the keys to press are separated by a plus sign, like this: SHIFT+F10.
For shortcuts in which you press keys one after the other, the keys to press are separated by a comma, like this: ALT, F, X.


To perform this action...


To display the Style dialog box

ALT+' (apostrophe)

To display the Format Cells dialog box


To apply the General number format


To apply the Currency format with two decimal places (negative numbers in parentheses)


To apply the Percentage format with no decimal places


To apply the Exponential number format with two decimal places


To apply the Date format with the day, month, and year


To apply the Time format with the hour and minute, and AM or PM

[email protected]

To apply the Number format with two decimal places, thousands separator, and minus sign () for negative values


To apply or remove bold formatting


To apply or remove italic formatting


To apply or remove underlining


To apply or remove strikethrough


To hide the selected rows


To unhide any hidden rows within the selection

CTRL+SHIFT+( (opening parenthesis)

To hide the selected columns

CTRL+0 (zero)

To unhide any hidden columns within the selection

CTRL+SHIFT+) (closing parenthesis)

To apply the outline border to the selected cells


To remove the outline border from the selected cells


Working with the Border Tab in the Format Cells Dialog Box

Press CTRL+1 to display this dialog box.

To perform this action...


To apply or remove the top border


To apply or remove the bottom border


To apply or remove the left border


To apply or remove the right border


To apply or remove the horizontal divider if cells in multiple rows are selected


To apply or remove the vertical divider if cells in multiple columns are selected


To apply or remove the downward diagonal border


To apply or remove the upward diagonal border


Go Back to the Top of the Page

Home ] Keys for General Use ] Keys for Moving and Scrolling on a Worksheet ] Keys for Moving between Worksheet Panes, Worksheets, and Workbooks ] Keys for Entering Data ] Keys for Selecting Data and Cells ] Keys for Editing Data ] [ Keys for Formatting Data ] Keys for Printing and Previewing Spreadsheet Files ] Keys for Working with Names ] Keys for Working with Databases and Lists ] Keys for Outlining Data ] Keys for Working with Charts ] Keys for Working with PivotTables and PivotCharts ] Keys for Working with Objects ]

Send mail with questions or comments about this web site to our webmaster.
Last modified: June 05, 2004

Labelled with ICRA