Pivot Table Show/Hide Options

Modified on Thu, 20 Jun at 1:46 AM

Overview

There are three options in this category and can be found on the PivotTable Tools Analyze Ribbon

  1. Field List
  2. +/- Buttons
  3. Field Headers


 

Field List

The 'trickiest' Show/Hide option is showing the Pivot Table Field List itself. The cursor MUST be positioned within the Pivot Table Report area for the Field List to show. In addition, the Field List Button must be pressed down as shown above.


+/- Buttons

Use the +/- Buttons option to turn on/off the ‘drill down’ icons in the report label areas


Field Headers

Use the Field Headers option to Show/Hide the Headers of your columns:

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article