• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 11: Appendixes > PivotTable and PivotChart Wizard Layout Dialog Box

PivotTable and PivotChart Wizard Layout Dialog Box

To display this dialog box, press Next and select the Layout button in Step 3 of the PivotTable And PivotChart Wizard.

PressTo
Up Arrow or Down ArrowSelect the previous or next field button in the list on the right.
Left Arrow or Right ArrowWith two or more columns of field buttons, select the button to the left or right.
Alt+RMove the selected field into the Row area.
Alt+CMove the selected field into the Column area.
Alt+DMove the selected field into the Data area.
Alt+PMove the selected field into the Page area.
Alt+LDisplay the PivotTable Field dialog box for the selected field.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint