Expand/collapse data groups on multiple worksheets

[seanrmckenna]

Hi all,
I have a file with ten worksheets which have data groups in the same position on each sheet. I'd like to expand and collapse them on all sheets by using grouped sheets but it seems this isn't possible when clicking the + or - box, or clicking on the 1, 2, 3 etc boxes in the top left corner.

Is there any way of doing it?

thanks
Sean

 

[Smitty]

Welcome to the Board!

You can start by recording a macro expanding the groups on each sheet, then another collapsing them.

Feel free to post back what you get and someone can clean it up for you.

Here's a good link: http://www.mrexcel.com/forum/excel-...collapse-expand-all-grouped-rows-columns.html

HTH,