Make your own free website on Tripod.com

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 working with databases, lists, and PivotTables

Working in a data form

To

Press

Select a field or a command button

ALT- key, where key is the underlined letter in the field or command name

Move to the same field in the next record

DOWN ARROW

Move to the same field in the previous record

UP ARROW

Move to the next field you can edit in the record

TAB

Move to the previous field you can edit in the record

SHIFT-TAB

Move to the first field in the next record

ENTER

Move to the first field in the previous record

SHIFT-ENTER

Move to the same field 10 records forward

PAGE DOWN

Move to the same field 10 records back

PAGE UP

Move to the new record

CTRL-PAGE DOWN

Move to the first record

CTRL-PAGE UP

Move to the beginning or end of a field

HOME or END

Move one character left or right within a field

LEFT ARROW or RIGHT ARROW

Extend a selection to the beginning of a field

SHIFT-HOME

Extend a selection to the end of a field

SHIFT-END

Select the character to the left

SHIFT-LEFT ARROW

Select the character to the right

SHIFT-RIGHT ARROW

Working with the AutoFilter feature

To

Press

Display the AutoFilter list for the current column (from the cell that contains the column label)

ALT-DOWN ARROW

Close the AutoFilter list for the current column

ALT-UP ARROW

Select the next item in the AutoFilter list

DOWN ARROW

Select the previous item in the AutoFilter list

UP ARROW

Select the first item (All) in the AutoFilter list

HOME

Select the last item in the AutoFilter list

END

Filter the list by using the selected item in the AutoFilter list

ENTER

Working with the PivotTable Wizard (Excel 97)

In Step 3 of the PivotTable Wizard, to

Press

Select the next or previous field button in the list

UP ARROW or DOWN ARROW

Select the field button to the right or left in a multicolumn field button list

LEFT ARROW or RIGHT ARROW

Move the selected field into the Page area

ALT-P

Move the selected field into the Row area

ALT-R

Move the selected field into the Column area

ALT-C

Move the selected field into the Data area

ALT-D

Display the PivotTable Field dialog box

ALT-L

Working with page fields in a PivotTable

To

Press

Select the previous item in the list

UP ARROW

Select the next item in the list

DOWN ARROW

Select the first item in the list (in Excel 97, the first visible item in the list)

HOME

Select the last item in the list (in Excel 97, the last visible item in the list)

END

Display the selected item

ENTER

Grouping and ungrouping PivotTable items

To

Press

Group selected PivotTable items

ALT-SHIFT-RIGHT ARROW

Ungroup selected PivotTable items

ALT-SHIFT-LEFT ARROW

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