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?
+3,690 | Bank of America - Juniors Strike to start Monday May 6th | 395 | 1m | |
+801 | BOFA ALREADY TRYING TO COVER UP THEIR TRACKS | 79 | 8h | |
+527 | This is a dark day for Wall Street. | 42 | 1h | |
+321 | BofA Associate Death - WSJ, FT, CNBC, Bloomberg | 32 | 33m | |
+182 | Analyst at Bofa FIG-Thoughts | 28 | 8h | |
+178 | How to strike without being fired. | 21 | 2h | |
+169 | Big Layoff at Barclays - 5/1/24 | 88 | 16h | |
+128 | BofA List | 32 | 1h | |
+128 | Hey WSJ, BBG, CNBC, FT, it's been more than 72 hours that this BofA IBD Associate was reported dead | 16 | 1m | |
+124 | Shame on you, BofA. But also, the industry needs to change. | 17 | 5h |
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
Totam aperiam dolores alias enim non dignissimos autem cum. Voluptas consequuntur consequatur dolores modi assumenda iste in. Necessitatibus deleniti perferendis quod repellendus ipsam. Enim rem ipsa animi. Voluptas deleniti in aliquam velit placeat exercitationem iusto culpa.
Animi quisquam facilis ut. Eum voluptates sed consequatur officia qui eaque provident. Vel et eum deserunt dolor consequuntur non.
Corporis atque consectetur ut cupiditate harum quam nisi. Eveniet modi rerum perferendis. Deleniti aspernatur voluptatem architecto maxime molestiae consequatur. Autem vitae eveniet et nihil.
A eveniet et eveniet mollitia pariatur molestias dolores. Et quis natus molestiae excepturi nesciunt dolor. Odit harum ab quam aliquam quia qui. Delectus quisquam similique repellat et ratione.
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...