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 Outlining 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 group rows or columns	ALT+SHIFT+RIGHT ARROW
To ungroup rows or columns	ALT+SHIFT+LEFT ARROW
To display or hide the outline symbols	CTRL+8
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)

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 ]