ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Collapse/Expand Buttons in a Pivot Table (https://www.excelbanter.com/excel-worksheet-functions/195900-collapse-expand-buttons-pivot-table.html)

CindyC3

Collapse/Expand Buttons in a Pivot Table
 
I have a pivot table with line items that only show the "collapse" button
because they do not contain any information to show the "expand" button. Does
anyone know why the "collapse" button appears when there is no data to expand
or collapse? Can this "collapse" button be turned off without turning off
those other items in the Pivot Table that do need the "expand/collapse"
buttons showing? The Show/Hide Buttons under Options Ribbon is a toggle that
turns all of them off or on so that doesn't work for this purpose.


All times are GMT +1. The time now is 12:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com