Excel 97/2000 Shortcut Keys

[Keys for working with spreadsheet files] [Keys for moving and scrolling on a worksheet] [Keys for moving between worksheet panes, worksheets, and workbooks] [Keys for entering data] [Keys for formatting data] [Keys for editing data] [Keys for selecting data, cells, chart items, or objects] [Keys for printing and previewing a spreadsheet file] [Keys for working with names] [Keys for working with databases, lists, and PivotTables] [Keys for outlining data]

Keys for outlining data

To

Press

Group rows or columns

ALT-SHIFT-RIGHT ARROW

Ungroup rows or columns

ALT-SHIFT-LEFT ARROW

Display or hide outline symbols

CTRL-8

Hide selected rows

CTRL-9

Unhide selected rows

CTRL-SHIFT-(

Hide selected columns

CTRL-0 (ZERO)

Unhide selected columns

CTRL-SHIFT-)

Go Back to the Top of the Page

 

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

 This site was created and is managed with
Microsoft FrontPage

 

Internet Content Rating Association