A simple improvement to Excel appeared in November 2020: You can now unhide multiple worksheets at once. This feature is rolling out to Office 365 subscribers.
Transcript of the video:
Learn Excel from MrExcel podcast episode 2379. Unhide multiple worksheets in Excel.
This has been a long time coming.
It was always possible to hide a whole bunch of worksheets at once. But then when you went to unhide them you had to unhide them one at a time.
This problem is going back 11 years.
I have a series of podcasts on how to how to do this using either a macro or Custom Views.
Great news: now Office Insider, the Beta channel, version 2012 - so the 12th release of of 2020. It has now addressed this problem. Excel.UserVoice.com had 754 votes for Unhide Multiple Worksheets at Once. It is there. So look down here at the bottom of the spreadsheet.
I have 11 worksheets. I am going to hide them all. So click on Apple. Shift-click on Kiwi.
Right-click and Hide.
But then when we come up here to the Home tab and go to Format, Hide and Unhide, Unhide Sheet. You could only select one at a time.
But now, check this out, Unhide One OR MORE sheets. I can click on Apple. Shift-click on Kiwi. And unhide them all. Seems so simple.
But for so many people this was such a hassle because you never think to set up the Custom View beforehand. Thanks to the Excel team for this awesome awesome improvement.
I can't wait for that to roll out widely. If you like these tips, please down below, click Like. Subscribe.
And ring that bell.
Feel free to post any questions or comments down in the YouTube comments below. Thanks for stopping by. We'll see you next time for another netcast from MrExcel.
This has been a long time coming.
It was always possible to hide a whole bunch of worksheets at once. But then when you went to unhide them you had to unhide them one at a time.
This problem is going back 11 years.
I have a series of podcasts on how to how to do this using either a macro or Custom Views.
Great news: now Office Insider, the Beta channel, version 2012 - so the 12th release of of 2020. It has now addressed this problem. Excel.UserVoice.com had 754 votes for Unhide Multiple Worksheets at Once. It is there. So look down here at the bottom of the spreadsheet.
I have 11 worksheets. I am going to hide them all. So click on Apple. Shift-click on Kiwi.
Right-click and Hide.
But then when we come up here to the Home tab and go to Format, Hide and Unhide, Unhide Sheet. You could only select one at a time.
But now, check this out, Unhide One OR MORE sheets. I can click on Apple. Shift-click on Kiwi. And unhide them all. Seems so simple.
But for so many people this was such a hassle because you never think to set up the Custom View beforehand. Thanks to the Excel team for this awesome awesome improvement.
I can't wait for that to roll out widely. If you like these tips, please down below, click Like. Subscribe.
And ring that bell.
Feel free to post any questions or comments down in the YouTube comments below. Thanks for stopping by. We'll see you next time for another netcast from MrExcel.
