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.
Our pivot table is finished and ready to print (FIGURE 8).