Page 17 - Document Preparation Guidelines - Excel

F I NA NC E R EF ER EN C E G U ID E

4. Applying that modified style to subsequent pivot tables you create in the workbook – If you check the box in step 3
above to set your custom pivot table style as the default for the document, all subsequent pivot tables you create will
use this custom style. You may also manually apply the style to subsequent pivot tables by repeating step 2 above.

The most common elements you will generally modify are the Subtotal Row lines to apply the standard
striping for the division. There are a number of other elements that can also be modified based on need.
When modifying the Subtotal Rows, on the Fill tab, click More Colors and enter the appropriate color

code noted above in the Hex field.

EMORY ADVANCEMENT AND ALUMNI ENGAGEMENT | FINANCE REFERENCE GUIDE | Updated 11.7.21 16