VIEWS: 4 PAGES: 3 POSTED ON: 10/31/2011
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.
Pages to are hidden for
"pivot_table"Please download to view full document