Look Who it Was Random video

Excel - Unhide All Worksheets in a Single Command with an Easy Macro - Episode 789

404 views · Published 15 January 2009 · 1:46 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Unhide All Worksheets in Excel In One Command. 
Welcome back to another MrExcel netcast! In our previous video, we discussed the frustration of having to unhide multiple worksheets in Excel. But today, I have a solution for you that will save you time and effort. No more clicking through each worksheet individually to unhide them. Let's dive in!

Yesterday, we talked about using a custom view to unhide multiple worksheets at once. But today, I'm going to show you how to write a simple macro that will do the job for you. All you need to do is go to INSERT, MODULE, and create a new macro called SUB UNHIDEALL. Then, we'll use a FOR EACH loop to go through each worksheet in the active workbook and set the visible property to TRUE. This will unhide all the worksheets in one go!

Now, you might be thinking, "But Bill, I'm not familiar with macros." Don't worry, it's easier than you think. Just follow along with me in the video and you'll have it done in no time. And once you have the macro set up, you can save it in your personal macro workbook and assign it to an icon or shortcut key for easy access. No more wasting time clicking through menus to unhide your worksheets.

And just like that, with a few lines of code, you can unhide all your worksheets in a matter of seconds. No more frustration, no more wasted time. So go ahead and give it a try in your own Excel workbooks. And don't forget to subscribe to our channel for more helpful tips and tricks. Thanks for watching and we'll see you in the next netcast from MrExcel!"

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/


Rather than use a custom view, Episode 789 shows how to create a 3-line macro to unhide all worksheets.

Table of Contents:
(00:00) Introduction to the topic of unhiding multiple worksheets
(00:12) Frustration with unhiding worksheets individually
(00:22) Solution using a custom view
(00:34) Alternative solution using a macro
(01:00) Demonstration of the macro in action
(01:15) Tips for implementing the macro for easy access
(01:25) 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:
1-click access to unhide sheets
Active workbook worksheets
Alt+F8 shortcut
Custom view
Format sheet unhide
Insert module
Macro for unhiding all worksheets
MrExcel netcast
Personal macro workbook
Sub UnhideAll macro
Unhide worksheets
Visible property

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

More from this channel