And click on OK.Īs a result, we can see that the Filter Button is visible in the Pivot Table. Navigate to Display and check the Display field captions and filter drop downs. Right-click on cell B16 and select PivotTable.Now, we need to unhide the Filter Button in the Pivot Table. The following image shows such an example. Pivot Table filters can be hidden sometimes. How to Unhide Pivot Table Filters in Excel Navigate to Table Design > Table Style Options > Filter Button and uncheck the Filter Button.įrom the image, we can see that the FIlter Button is hidden now.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |