Here are the shortcut keys for working on the Pivot Table ...



Here are the shortcut keys for working on the Pivot Table without using the mouse. We use the pivot table when we want our information in a matrix form.

Keys for Pivot Table and Pivot Chart Reports.

A) Layout a report onscreen:-

• Press F10 to make a menu bar active.

• Press CTRL+TAB or CTRL+TAB+SHIFT to make the pivot table field list active.

• Press UP/DOWN ARROW to select the field you want. Press RIGHT/LEFT ARROW to open or close a field that can be expanded.

• Press TAB to select the ADD TO list and then press DOWN ARROW to open the list.

• Press DOWN/UP ARROW to select the area where you want to move the field and then press ENTER.

• Press TAB to select the ADDTO BUTTON and then press ENTER.

B) Use the pivot table and pivot chart wizard layout dialog box:-

To display this dialog box, press TAB until layout is selected in step 3 of the pivot table and pivot chart wizard.

UP/DOWN ARROW

Selects the previous or next field button in the list on the right.

LEFT/RIGHT ARROW

With two or more column of field buttons, select the button to the left or right.

ALT+R

Move the selected field into the Row Area.

ALT+C

Move the selected field into the Column Area.

ALT+D

Move the selected field into the Data Area.

ALT+P

Move the selected field into the Page Area.

ALT+L

Display the pivot table field dialog box for the selected field.

C) Display and Hide Items in a field:-

ALT+DOWN ARROW

Display the drop down list for a field in a pivot table or chart report use the arrow keys to select the field.

UP/DOWN ARROW

Select the previous/next item in the list.

RIGHT ARROW

For an item that has lower level item available, display the lower level items.

LEFT ARROW

For an item that has lower level item displayed, hides the lower level items.

HOME/END

Select the First /Last item in the list.

ENTER

Close the list.

D) Change the layout of the report:-

CTRL+SHIFT+*

Select an entire pivot report.

ALT+SHIFT+RIGHT ARROW

Group the selected item in a pivot table field.

ALT+SHIFT+LEFT ARROW

Ungroup grouped item in a pivot table field.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download