Unhide multiple worksheets at once
We can hide several worksheets at once, but we can only show them individually.
Although the VBA can solve this issue with some lines of code, but it would be a great improvement if you add this capability to Excel as a build in feature.
We’re excited to share that this feature is now available for Microsoft 365 Subscribers. To get it, you should update to version 16.0.13525 or greater on Windows, or 16.45 or greater on Mac. It’s also available in Excel for the web.
If you are excited by this change or have comments for us, please let us know at Help → Feedback.
Jourdan Carrell commented
This would be very helpful to be able to unhide multiple sheets at once.
Jennifer Westrich commented
This would be very helpful
This would be very helpful to complete outside of VBA
Valerie Laurence commented
This would be great!
Dory Owen commented
Unhide with a multi-select checkbox list. Yeah! Let's do it!
David Ringstrom commented
I've launched a social media campaign as of late to promote this, and I've gotten more 200 votes in the past week. Please help this initiative by promoting this topic on social media. I've also gotten my team members to vote. I think we need at least 1,000 votes to get the development team to take notice. As of today we're almost half-way there. Please help get the word out!
Omar Khan commented
Can we merge this other thread with this since it seems they are the same issue?
yes, definitely yes. Have it so can have same select options as you do for visible sheets. Using Ctrl or Shift
Ibrahim yesufu commented
It will be awesome!!
Yar Sheets commented
You can hide as many tabs at one time as you'd like. But you can only unhide one at a time. Batch the process.
Would help a lot!
Being able to unhide all or multiple sheets at once, rather than single sheet.
When the selection of hidden sheets appear have the ability to pick different sheets by using Ctrl and mouse
Maybe also have an unhide all option
Yeah, could be improved with ctrl and/or maj clicks
Here's a workaround for Office 2016 until--yeah right--Microsoft addresses the problem.
Open the VBA screen with Alt F11. In the Immediate window at the bottom of the screen, type in
For Each s In Sheets: s.Visible = True: Next
and hit Enter. I've saved this coding in a Word document so I just copy and paste whenever I need it. Hope this helps.
Ashley Morris commented
Make sure to go to the suggestion that is getting the most votes about this and vote on it.
Ashley Morris commented
It has to be so simple but it is a HUGE time suck - the other addition would be the ability to sort the tabs in the list to find the tab - or range of tabs - you want to unhide.
Jamie McIntyre commented
I like this one too.
Perhaps it could be merged with this suggestion which has another 200 votes at the moment?
Unhiding multiple sheets is a painful task, you have to go one by one. There should be an option to unhide multiple sheets at once.
Please bring in this feature.
You have the option to choose multiple tabs, and hide them in one go. It would be useful if there was an option to unhide all or multiple tabs, instead of doing them all individually.