Excel Question - Close all grouped columns
Gurus, is there a way to close all grouped columns, on all the worksheets of a workbook, at once?
Trending Content - Investment Banking Forum
| +149 | Piper Sandler in talks to acquire PWP | 66 | 1h |
| +141 | Just One More Year | 11 | 2d |
| +116 | UBS Appears to be Exploring Sale | 17 | 9m |
| +79 | Bringing Deals as a Vice President | 25 | 6h |
| +75 | Paradise Is Paradise | 5 | 1d |
| +38 | Q&A | Investment Banking Analyst, UBS | 2 years in investment banking | 11 | 2d |
| +32 | M&A is Paradise | 1 | 3d |
| +31 | Will they pay Directors $1mm+? | 14 | 3d |
| +29 | Drunk VP. How to manage? | 15 | 2h |
| +26 | Best Groups at UBS NY | 10 | 1d |
Career Resources
Click the fucking 1.
Missed the 'all the worksheets' part... No button. Here's a macro.
sub CloseAllTheFuckingGroups()
dim ws as worksheet
for each ws in activeworkbook.worksheets ws.outline.showlevels rowlevels:=0, columnlevels:=1 'untested, if that doesn't work uncomment the two lines below 'ws.activate 'activesheet.outline.showlevels rowlevels:=0, columnlevels:=1 next ws
end sub
Ut aliquid numquam consequatur eos. Ipsam quis sit delectus distinctio itaque quasi sit. Commodi perferendis voluptatibus dolorum velit. Suscipit nulla maiores qui. Est ex necessitatibus quis reprehenderit tempore.
In alias id rerum incidunt autem cumque voluptatem. Consequuntur est ipsam molestiae omnis enim magnam. Eum qui quis doloremque. Nesciunt aspernatur sint suscipit velit. Architecto inventore architecto officiis quae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...