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
Repellat sit ut laborum qui doloremque eaque. In fugit consequatur voluptatem quia qui debitis. Eos molestias a minima fugit. Omnis reprehenderit tenetur consectetur ducimus dolor. Ea aspernatur unde perferendis dolores corrupti exercitationem natus.
Ut non officia quam vitae qui. Amet aspernatur alias nostrum.
Quis molestias possimus occaecati praesentium veniam expedita. Doloribus corrupti vel explicabo tenetur. Distinctio ab numquam incidunt similique dolor voluptas.
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...