| Work with databases, lists, and PivotTables by using shortcut keys | |
| Work in a data form by using shortcut keys | |
| 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 |
| Work with the AutoFilter feature by using shortcut keys | |
| To | Press |
| Display the AutoFilter list for the current column | Select the cell that contains the column label, and then press 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 |
| Work with the PivotTable Wizard by using shortcut keys | |
| 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 |
| Work with page fields in a PivotTable by using shortcut keys | |
| To | Press |
| Select the previous item in the list | UP ARROW |
| Select the next item in the list | DOWN ARROW |
| Select the first visible item in the list | HOME |
| Select the last visible item in the list | END |
| Display the selected item | ENTER |
| Group and ungroup PivotTable items by using shortcut keys | |
| To | Press |
| Group selected PivotTable items | ALT+SHIFT+RIGHT ARROW |
| Ungroup selected PivotTable items | ALT+SHIFT+LEFT ARROW |
CAclubindia
