Practice Exercise 27 – Customize a Pivot Table by Preparing it for Printing
We’re about ready to print our pivot table but we need to remove the filtering controls. There are two (FIGURE 1):
STEP 1: The first filter control are the minus symbols (called Expand/Collaspe buttons) next to our Year and Month controls (2014 and Jan, Feb) STEP 2: The second filter control is the downward pointing arrow next to Year, Month, Market, and Category. |
FIGURE 1
|
Our pivot table is finished and ready to print (FIGURE 8).
FIGURE 8
Module 4 completed. Take the Module 4 quiz here.