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. |
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
