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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.