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
| +211 | Who Killed Wall Street | 65 | 1d |
| +176 | Worlds Worst MDs Competition (2026 Edition) | 37 | 2m |
| +164 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 4d |
| +121 | Lindsay Clancy - Thoughts from A2 | 22 | 1d |
| +45 | NYC Wall Street Run Club | 11 | 5h |
| +43 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 21 | 1d |
| +34 | Most technical groups? | 18 | 2d |
| +24 | Shana tova - happy new year | 4 | 1h |
| +21 | Meritocratic IB groups / banks | 15 | 3d |
| +20 | Feeling a bad pattern forming. I need some help | 3 | 16h |
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
Corporis qui qui vitae. Adipisci fugiat aut minima quaerat sint sint. Voluptatem amet sit alias. Quos minima dolor aspernatur suscipit.
Qui omnis ut aperiam quidem. Mollitia tempore rerum molestiae distinctio harum.
Illum ut sit sed eos reprehenderit repellendus. Impedit quibusdam pariatur voluptates iure. Aut quibusdam laboriosam voluptatibus earum explicabo dignissimos. Officiis error nisi temporibus ullam. Iure natus error in sint deserunt. Inventore quod deleniti eligendi vero. Impedit quis quis totam velit aut odio et.
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...