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
|
|
STEP 3: First we’ll remove the minus symbols (Expand/Collapse buttons) next to the year and months.
STEP 4: Select any pivot table cell. STEP 5: On the shortcut menu, select Pivot Table Options (FIGURE 2). |
 FIGURE 2
|
|
STEP 6: On the Pivot Table Options dialog box, select the Display tab (FIGURE 3).
STEP 7: Uncheck the box, “Show expand/collaspe buttons”. STEP 8: Select OK button. |
 FIGURE 3
|
|
STEP 9: As you can see from the graphic on the right, the Expand/Collapse buttons have been removed from previous step (FIGURE 4).
|
 FIGURE 4
|
|
Now we’ll remove the second filter control (downward pointing arrows next to Month, Market, and Category).
STEP 10: Select any pivot table cell. STEP 11: On the shortcut menu, select Pivot Table Options (FIGURE 5). |
FIGURE 5
|
|
STEP 12:On the Pivot Table Options dialog box, select the Display tab (FIGURE 6).
STEP 13: Uncheck the box, “Display field captions and filter drop downs”. STEP 14: Select OK button. |
 FIGURE 6
|
|
STEP 15: As you can see from the graphic on the right (FIGURE 7), the field captions and drop-down filters have been removed from previous step.
The removed captions were previously in cells A6, B6, C6, and E4 (Year, Month, Market, and Category respectively). |
 FIGURE 7
|
Our pivot table is finished and ready to print (FIGURE 8).
FIGURE 8
Module 4 completed. Take the Module 4 quiz here.