O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Naming a PivotTable and Setting Options for It

When you insert a PivotTable, Excel gives it an automatic name (such as PivotTable1 or PivotTable2) and sets default display options, layout options, and data options. To rename the PivotTable or to choose different options, choose PivotTable images Data images Options to display the PivotTable Options dialog box, then work with its controls. (If the Excel window is too narrow for the Ribbon to fit, the command is PivotTable Data Options PivotTable Options.)

Figure 12–15 shows the PivotTable Options dialog box ...

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