O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Press

To

Up Arrow or Down Arrow

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

Left Arrow or Right Arrow

With two or more columns 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 PivotTable Field dialog box for the selected field.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required