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
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
Nemo tenetur est magni. Molestiae non voluptate praesentium animi soluta maxime. Autem odit non ipsam quia enim porro maxime. Autem voluptates sed veniam illum vel.
Tempore quibusdam non commodi culpa. Necessitatibus aut vitae ipsa. Fugiat odit doloribus expedita non officiis iste occaecati explicabo. Fuga quasi non similique est.
Dolor alias quis qui voluptatem accusantium rem quaerat. Voluptatem tenetur labore est. Quis corrupti suscipit quisquam nostrum. Placeat qui ipsum perspiciatis. Et perspiciatis quam sunt at animi quam. Alias quos praesentium rerum ut.
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...