Unhide Multiple Excel Worksheets at Once

Excel lets you hide multiple worksheets (or tab) by giving you the option to group them first (Press Shift and right mouse click to choose the Hide command). However if you wanted to unhide the worksheets, there's not really a way to group them together and do it all at once. So here's the workaround. One way will be using VBA and the other way will be using Custom Views. Check out the video to see the tips.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[TheDistractionStudio]

Accidentally found your channel and I’m in Excel Heaven. Not only it’s great quality videos but very meaningful and daily use content. #ThankYou

[Neptune]

Thank you again. Found naming the hide and the unhide allowed easy switching between the two!

[kunchoktharlam]

Thank you so much for this amazing trick. I have been trying to figure it out for long time.

[valeriiaparfenyuk]

Thanks a lot! it saved me so much time!

[marting]

For each ws In sheets : ws. Visible=True:Next

[petercrowther]

Excell wont allow me to click on custom views :(