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