Expand/Collapse Entire Field - Pivot Table - Shortcut

[Sundance_Kid]

Hi,

I have a pivot table with 4 fields in the rows section and one field in the values section.

I am displaying the table in tabular form.

Is there a user friendly shortcut way to quickly expand/collapse the entire table without having to right click the first row and go to Expand/Collapse?

I am ideally thinking of some shortcut button i can add either add to the excel page or to the toolbar ribbon.

Below is the table I am using as an example. To collpase the entire field I normally would right click on the first row - 'Name' go to Expand/Collapse and click Collapse All.

Thank you

 

[meileetan]

I usually right-click, then press on keyboard: "E E" to expand all, or "E C" to collapse.

 

[Sundance_Kid]

I usually right-click, then press on keyboard: "E E" to expand all, or "E C" to collapse.

Thanks, I was hoping for something with less steps then even that.

Being able to just click once a button saying expand or collapse.

Is there some sort of macro that can be added with two buttons - one for expand and one for collapse?

Thanks

 

[meileetan]

Yes, you can certainly build in a macro. On Developer tab, click on Start Recording then go through the clicks you would make to expand or collapse. Then click on Stop Recording. You will need to make 2 recordings for the Expand vs Collapse actions.
After this, again on Developer tab, click on Insert > Button, then assign the respective Marco to the button. You can rename the buttons.

 

[Sundance_Kid]

Yes, you can certainly build in a macro. On Developer tab, click on Start Recording then go through the clicks you would make to expand or collapse. Then click on Stop Recording. You will need to make 2 recordings for the Expand vs Collapse actions.
After this, again on Developer tab, click on Insert > Button, then assign the respective Marco to the button. You can rename the buttons.

Many thanks for your reply. I may look into doing this later, I have yet to build a macro before but this may be a good starting point for my first build.

Thanks