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.
We should be able to unhide multiple sheets at once. Since we can hide multiple sheets at the same time, why can't we unhide multiple sheets? It can be very time consuming to click each sheet individually and unhide them one by one. This would be a great feature so you do not have to manually go through unhiding them one at a time and trying to figure out which one you need.
J L Fischer commented
I updated data in several tabs for the main report on the first tab. It takes a few minutes to unhide all of the hidden tabs and then to hide them again. 1 time, this doesn't amount to much, but I have been doing this for years...
Could a feature be added to have a selection box, like in the pivot table filters, so I can select multiple tabs to unhide and/or hide at a time?
Eileen Shifflett commented
it drives me crazy that hidden worksheets have to be unhidden one at a time - seems like you should be able to use the ctrl key to select multiple worksheets when they are listed after clicking "unhide" from the worksheet tab menu
I was about to suggest the same when I found your post. Totally agree
Levi Bailey commented
In addition to the excellent suggestion by Tomas K, please consider making it easy to select a subset of sheets. It might make sense to do this with shift+click (where you click to select a start point, then shift+click on the end point and it extends the selection from the start point to the end point including everything in between).
Thomas K commented
Very nice to hear. Besides multi select, please include "all"
Sanjib Pradhan commented
Yes. This feature is badly needed. Thank you. :)
Sameer Bhide commented
If you have 10 sheets hidden and you want to unhide all of them it is a painful task to doing it one by one