Look Who it Was Random video

Excel - Unhide Multiple Worksheets (Excel 2021 & Older) - Episode 788

624 views · Published 15 January 2009 · 2:09 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: You can hide 20 worksheets in a single command, but it is very tedious to unhide all worksheets. Episode 788 shows how to use a custom view to unhide all worksheets.

Welcome back to the MrExcel netcast! In this video, we'll be discussing a common frustration for Excel users - the inability to unhide multiple worksheets at once. Have you ever found yourself in a situation where you need to unhide several hidden sheets, but have to go through the tedious process of unhiding them one by one? Well, I have two solutions for you that will save you time and frustration.

During my recent seminars in Trinidad and Tampa, I had multiple attendees ask me about this exact issue. They were frustrated with the fact that they could easily hide multiple sheets at once, but couldn't do the same when it came to unhiding them. This is where custom views come in handy.

In this video, we'll be focusing on one solution - using custom views. First, we'll create a custom view called "ALLVISIBLE" where all of our sheets are visible. Then, we'll create another view called "SOMEHIDDEN" where we'll hide the sheets we don't want to see. Now, instead of using the tedious process of going to FORMAT, SHEET, UNHIDE, we can simply go to VIEW, CUSTOM VIEWS, and select the "ALLVISIBLE" view to bring back all of our sheets at once.

But that's not all! In tomorrow's video, we'll take a look at another quick solution - using a macro to unhide all sheets at once. So make sure to tune in for that. Thanks for watching and don't forget to subscribe to the MrExcel netcast for more helpful Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction to the topic
(00:12) Funny experience with repeated question
(00:22) Frustration with hiding and unhiding multiple sheets
(00:32) Solution 1: Using custom views
(01:01) Creating and using custom views
(01:17) Solution 2: Using a macro to unhide all sheets
(01:41) Conclusion and preview of next topic
(01:51) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

"This video answers these common search terms:
Excel custom views
Excel custom views tutorial
Excel macro to unhide all sheets
Excel productivity tips for managing multiple sheets
Excel sheet unhide problem
Excel sheet unhide workaround
Excel tips and tricks for hiding/unhiding sheets
Format sheet hide/unhide
Hide multiple sheets in Excel
How to hide multiple sheets in one step
MrExcel netcast solution for hiding/unhiding sheets


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152085/"

More from this channel