Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

pivot_table

VIEWS: 4 PAGES: 3

									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.

								
To top