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
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.
78 comments
-
Aaron Hubbard commented
Thank you Excel team!!!
-
Az
commented
YAY THANK YOU!!!! :D :D :D
-
Tim Ellis
commented
Thanks MS Excel Team.
-
Vee
commented
@john Harvie, from Excel, go to the Account area, and you should see there "update available". Also you must be a paid Microsoft paid subscriber. Once you update Excel, you should be able to do it. To unhide several sheets, right click, unhide and then press the Ctrl key to select the sheets you want to unhide. Hope this helps.
-
John Harvie
commented
Email says: "update to version 16.0.13525 or greater on Windows" but doesn't say how to do this.
Wow do you do it?
-
Vee
commented
I can confirm that this morning, after 20 years of using Excel, I was able to unhide multiple sheets by pressing the Ctrl key and selecting the sheets I wanted to unhide. A leap forward, a historic achievements.
-
Carmen Olteanu
commented
Will this feature will available also for other Windows versions? Our company currently owns a MS Office Home&Buisiness2019.
Thank you! -
Malak
commented
This is very excising!
Thank you :)
-
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.
-
Wellington_AprendaWell
commented
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
-
Vee
commented
That's a massive leap forward to have this build feature in Excel.
-
Alejandro Ramirez
commented
Finally! Excellent
-
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!
-
Anonymous
commented
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.
-
Anonymous
commented
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