Microsoft Excel Applying Design Style

Applying a Design Style

Once ou have created the pivot table report, it is possible to add a design Style, this will enhance the presentation.

1.     Select PivotTable Tools →.Options.   

                  

2.  Click on the Select button, this will give you various selection options.

Once you have selected the option required, the pivot table will highlight the area.

3.     Click on the Design tab on the ribbon.

Select the required Design Style.