How to Format Your Pivot Tables in Excel 2013

To format a pivot table in Excel 2013, just click a cell in the pivot table to add the table tool’s contextual tabs to the ribbon, then click its design tab. You can use the Live Preview feature to see how a pivot table would look in any style you highlight.