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...	Press...
To display the Style dialog box	ALT+' (apostrophe)
To display the Format Cells dialog box	CTRL+1
To apply the General number format	CTRL+SHIFT+~
To apply the Currency format with two decimal places (negative numbers in parentheses)	CTRL+SHIFT+$
To apply the Percentage format with no decimal places	CTRL+SHIFT+%
To apply the Exponential number format with two decimal places	CTRL+SHIFT+^
To apply the Date format with the day, month, and year	CTRL+SHIFT+#
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	CTRL+SHIFT+!
To apply or remove bold formatting	CTRL+B
To apply or remove italic formatting	CTRL+I
To apply or remove underlining	CTRL+U
To apply or remove strikethrough	CTRL+5
To hide the selected rows	CTRL+9
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	CTRL+SHIFT+&
To remove the outline border from the selected cells	CTRL+SHIFT+_

Working with the Border Tab in the Format Cells Dialog Box

Press CTRL+1 to display this dialog box.

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 ]