Windows XP and Office 2003 Keyboard Shortcuts

Excel s outlining features enable you to collapse large worksheets so that only the parts you need to see appear on screen. You can perform the main outlining actions easily from the keyboard by using the shortcuts described in this section.

Shortcuts for Working in Outlines

Group the selected rows or columns

[Alt] - [Shift] - [ ’ ]

Ungroup the selected rows or columns

[Alt] - [Shift] - [ ]

Toggle the display of outline symbols

[Ctrl] - [8]

You can hide outline symbols to reclaim the space that they take up on screen. Redisplay the symbols when you need to work with them again.