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 are excited to share an update on the feature availability. This is available on Excel Insiders min build: 16.0.13525.10000, and on Mac Insiders min build:16.44.1125.0. We will post updates here as this rolls out to Current Channel. (A description of Office channels can be found here: https://docs.microsoft.com/en-us/deployoffice/overview-update-channels )
If you are excited by this change or have comments for us, please share at File→Feedback.
Galin McMahon commented
How did the MS devs decide "OK, let's allow users to hide a hundred sheets at one time...but make them unhide them one...at...a...time?" Mind boggling.
I would like to suggest that when activating the command to Unhide Spreadsheets, there could be the possibility to SELECT ALL or even HIDE THE OTHER active sheets also
That's a massive leap forward to have this build feature in Excel.
Alejandro Ramirez commented
David Ringstrom commented
THANK YOU! I look forward to seeing improvement. It'll remove a thorn in from my side that's been there for decades now! :-)
Ashley Morris commented
Steve K. You just made my week. THANK YOU SO MUCH!
https://toanhoc.org - Trang toán học miễn phí cho người mới bắt đầu. Có nhiều bài giảng hay để học sinh tiểu học, THCS, THPT tự học hay giáo viên - phụ huynh học sinh tham khảo để dạy con em mình.
Raoul Federman commented
Agree with many others that this is long overdue. Thanks for sorting it out
Tim Ellis commented
This would be helpful I have written VBA to get around this problem.
I want to change a file which has become READ ONLY how do I do it
Ngaan Le commented
Thank you for the helpful sharing. Excel is also the topic I'm interested in ( https://sophuc.com ). Hope to learn more from you.
John Harvie commented
The ideal way would involve three options:
1) an "all" option
2) a hold down ctrl key and select from a drop-down or list to pick out non sequential sheets
3) a hold down shift key to select contiguous sheets as a group
And while we are about it, how about an option to sort and rearrange sheets by name
I agree to all the comments as to being easy to hide, but a hassle to unhide multiple tabs, this needs to be built in.
It’s ridiculous that this hasn’t already been available
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.
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.
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
Very helpful to have this feature
Helge Raab commented