Hello Working with Mac 2011 Excel. I have made a data spreadsheet and a pivot ta

Q: Hello Working with Mac 2011 Excel. I have made a data spreadsheet and a pivot ta

Select any cell in the Pivot Table in order to activate the Pivot Table contextual tab of the Ribbon. On that tab clcick the Expand or Collapse button in the Field group.

ID: 3562199 • Letter: H

Question

Hello

Working with Mac 2011 Excel. I have made a data spreadsheet and a pivot table that shows some fields of that data. By putting two values in Row Labels section of the Pivot Table Builder, I have a situation which shows Row Labels and then sub-headings within those. Each of the Row Labels now has a triangular toggle button which can be clicked to either show or hide the sub-headings.

Is there an easy way to Opeen or Close all the toggles at once rather than clicking each onee in turrn separately???

Explanation / Answer

Select any cell in the Pivot Table in order to activate the Pivot Table contextual tab of the Ribbon. On that tab clcick the Expand or Collapse button in the Field group.

Navigate

Hello Working on a project, and a bit stuck at the moment, here is what I have t

Hello World. So, I am new to programming entirely, let alone Matlab. I know it i

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.

Hello Working with Mac 2011 Excel. I have made a data spreadsheet and a pivot ta

Question

Explanation / Answer

Related Questions

Navigate