O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and 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

Formatting a PivotTable

The Design tab that appears on the ribbon under PivotTable Tools when you select any part of a PivotTable includes a large selection of professionally designed PivotTable styles. These work just like—and, in fact, are similar to—the styles available with ordinary tables. By choosing from the PivotTable Styles gallery, you can ensure that your PivotTable looks good and uses colors consistent with the rest of your workbook. You can customize the built-in style choices by selecting or clearing the check boxes in the PivotTable Style Options group, and you can add your own designs by clicking New PivotTable Style at the bottom of the PivotTable Styles gallery. To display the PivotTable Styles gallery, click the More button ...

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