Look Who it Was Random video

Excel - Unhide All Sheets Using 3 Lines of VBA Code - Episode 611

4,207 views · Published 31 March 2009 · 2:34 · Indexed 10 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Unhide All Worksheets in Excel.

Welcome back to another MrExcel podcast! In today's episode, we'll be tackling a question that was asked during one of my seminars in Fort Wayne, Indiana. The question was, "Is there a way to unhide multiple sheets at once in Excel?" And the answer is yes! 

Many of us are familiar with the process of hiding multiple sheets at once by selecting them and going to "Format" ＞ "Sheet" ＞ "Hide". However, when it comes to unhiding those same sheets, we are forced to do it one at a time by going to "Format" ＞ "Sheet" ＞ "Unhide". This can be a time-consuming and tedious task, but fear not, there is a solution. 

The best way to unhide multiple sheets at once is by using a little bit of VBA code. Now, I've received some requests from viewers to incorporate more VBA into my videos, so today, I'll be doing just that. I'll switch over to the VBA editor and insert a new module. From there, I'll use a simple code that will loop through all the worksheets in the active workbook and make them visible. 

To make things even easier, I'll assign this code to a shortcut key. In this case, I'll use "Ctrl + U" to unhide all sheets at once. Of course, if you already use "Ctrl + U" for underline, you can choose a different shortcut key. Now, whenever you have multiple hidden sheets, simply hit "Ctrl + U" and watch as Excel quickly unhides them all. It's a small but powerful solution to a common problem. 

I hope you found this VBA tip helpful. Don't forget to subscribe to our channel for more Excel tips and tricks. And as always, thanks for tuning in to another netcast from MrExcel. 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/

You can hide several sheets with a single command, but you have to unhide sheets one at a time. Today, using a little VBA, we turn unhiding into a single keystroke. Episode 611 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Table of Contents:
(00:00) Introduction to the topic
(00:18) Question asked in seminar
(00:28) Difficulty with unhiding multiple sheets
(00:45) Introduction to VBA code solution
(01:00) Explanation of code
(01:19) Demonstration of code in Excel
(02:05) 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:
Ctrl U (keyboard shortcut)
Excel workbook
Format
Hide sheets
Loop
Macro
Sheet
Shortcut key
Unhide sheets
VBA code


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

More from this channel