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.
Great news. We have started to rollout the Unhide multiple sheets dialog box improvement! It is currently available on Office Insider Windows- Beta channel build 16.0.13424.10000 and up.
We are working on rolling this out to a general audience (Current Channel), as well as to Mac and Excel for the web. We will post updates here.
If you are excited by this change or have comments for us, please share at File→Feedback.
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.
John, it's gotta be a simple fix. please make it happen!!. Bill
this functionaly would save us a lot of time. Please consider it. Thanks
Khris F. commented
PLEASE ADD THIS
Marc Labrie commented
It would make my day much easier...
This would be immensely helpful.
I would like to add my vote to this improvement. I use many documents with multiple worksheets that track payroll, etc., and most have at least 12 -24 worksheets. I would like to be able to hide quarters not in use and be able to restore them in one fell swoop, rather than one at a time...very laborious.
Varghese O commented
If there was an option to click the "Vote: button multiple times, I would have given this a thousand votes !!!!
Implementing the idea would really be beneficial to excel users.
I would love this feature. Currently, to get around this, I use the following macro:
ActiveWindow.DisplayWorkbookTabs = True
C Nielsen commented
It would be nice if there was an "Unhide All" check box which would enable Excel to launch all hidden tabs in a spreadsheet.