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.
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.
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