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...

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

CTRL+SHIFT+@

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.

To perform this action...

Press...

To apply or remove the top border

ALT+T

To apply or remove the bottom border

ALT+B

To apply or remove the left border

ALT+L

To apply or remove the right border

ALT+R

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

ALT+H

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

ALT+V

To apply or remove the downward diagonal border

ALT+D

To apply or remove the upward diagonal border

ALT+U

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