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.
Anonymous
shared this idea
58 comments
-
JLS
commented
It’s ridiculous that this hasn’t already been available
-
Anonymous
commented
While a macro can be used to unhide all sheets, it would be most helpful if I could select and unhide multiple random sheets from the list without it having to be an all-or-one proposition. I would like to see a selection process similar to selecting multiple sheets for any other purpose: "Ctrl + click + click + click" to select any sheets from the list, or "Ctrl + Shift + click" to select several consecutively-listed sheets.
-
Anonymous
commented
There is a macro to unhide all sheets. While helpful I do agree that we should be able to just ctrl or shift click multiple sheets and unhide in the existing menu.
If anybody wants help with the macro I mentioned feel free to contact me.
-
Anonymous
commented
I work with a lot of workbooks that contain many hidden sheets. Unhiding many sheets at one time would be a great time-saver.
-
Kristy Beam
commented
A much needed feature
-
Dave
commented
Very helpful to have this feature
-
Helge Raab
commented
It,s useful
-
CB
commented
Yes, please add feature to unhide multiple sheets. Thanks.
-
Matt
commented
Unhide ‘em!
-
Anonymous
commented
I support this.
-
Anonymous
commented
Yes Pelase
-
Laura Redmond
commented
Please add
-
Patricia McCarthy
commented
Please add this.
-
Anonymous
commented
Please add.
-
Malak
commented
Please consider adding this feature, it will save us a lot of time!
-
Don Farrey
commented
Please add with an option to unhide all or select workbooks.
-
Doug Haught
commented
Please add this functionality
-
Anonymous
commented
Yes, please!
-
Anonymous
commented
This would be great! I run into it every month.
-
Jourdan Carrell
commented
This would be very helpful to be able to unhide multiple sheets at once.