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
| +261 | Earliest you can get fired | 56 | 8h |
| +250 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 47 | 1h |
| +228 | Investment Banking is Divine | 38 | 12h |
| +223 | Career Crossroads | 31 | 17h |
| +214 | US 2027 SA IB worried about background check | 52 | 23h |
| +206 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 41 | 10h |
| +203 | Another $115bn Mega deal for these banks. Congrats! | 44 | 36m |
| +110 | Is UBS really that bad? | 32 | 1h |
| +37 | Is Houston SA 28 recruiting already over? | 32 | 12h |
| +23 | Sweat Group 2026 Discussion | 24 | 12h |
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
Sunt ut aut iure explicabo officiis ut. Qui dolorem quia et nulla. Facere ut libero perferendis odio. Voluptas quia ad dicta eligendi perferendis neque. Eligendi sunt quos deserunt et quibusdam et ut. Dolores officia ipsam reprehenderit sint corporis.
Architecto vero veritatis eum voluptates facilis. Similique qui et nisi. Similique amet sint rem magnam ut iusto quo. Id sit et voluptatem reprehenderit excepturi incidunt.
Voluptas quo aut eveniet quam totam omnis. Laudantium voluptates illum est architecto qui repudiandae. Molestiae aut quisquam nemo. Voluptatem accusantium incidunt rerum at qui tenetur. Impedit dolorum ab eveniet autem.
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...