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

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

Labelled with ICRA