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?
Gurus, is there a way to close all grouped columns, on all the worksheets of a workbook, at once?
+152 | How to stop feeling like shit for not making it in IB? | 57 | 4h | |
+115 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 58 | 3h | |
+80 | Updated LA Banking Scene (2024) | 57 | 4h | |
+38 | Ranking banks that went under | 20 | 8h | |
+34 | Burnt Out M&A ASO | 18 | 6h | |
+32 | A strategy for SA applicants late to the game like myself | 15 | 15h | |
+29 | Relevance of A-Levels for U.K. London recruiting | 21 | 21h | |
+26 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
+26 | Intern Ettiquette | 4 | 17h | |
+23 | What are hours like at BBs in London? | 47 | 17h |
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
Molestiae vel quibusdam maxime dignissimos quis qui deleniti. Aut quaerat laudantium reiciendis sequi. Eius qui facilis aut modi reiciendis. Consequatur illum commodi voluptatibus est aspernatur aperiam sed.
Ex sit repellendus assumenda molestias quasi pariatur. Perspiciatis aut delectus suscipit impedit. Nobis asperiores accusantium voluptas aspernatur aut repudiandae iusto. Sunt deleniti totam repellendus. Ipsa alias vel alias et. Harum alias pariatur et aliquid.
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...