Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)

Good news! If you have Office 365 you can now unhide multiple sheets at once! YAY!

Free Excel Download Utility to unhide selected worksheets.
You can add this tool to your Quick access toolbar or to your Excel ribbon by saving it in your personal macro workbook. In this video I show you the steps to do that.

Many Thanks to Daniel Lamarche from Combo Projects for sharing this tool for free with our community members here.

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel

[LeilaGharani]

Good news! If you have Office 365 you can now unhide multiple sheets at once! YAY!

[DanielLamarche]

Thanks Leila for your interest in this utility and the great presentation. I certainly could not have done better. The post goes into some details but, as you clearly explained, the most important thing is to copy it in the PERSONAL.XLSB workbook. That was very well demonstrated.

Thanks!!! B-)

[MadhweshPS]

Leila you are indeed very inspiring.. the fact that you gave all the credit to Daniel here shows your heart is in the right place, pls keep the good work coming in.. Daniel you are a super star!

[himanshuchhabra]

Thanks you Daniel and leila . We are so grateful to you

[yulinliu]

Thank you Daniel and Leila for sharing this!

[roderickmose]

Wow! I just love the spirit of this community. Always sharing, always recognising each other's talents and contribution. Came for the training, stayed for the comradery.

"Amid whiffs of truffle oil and warm maple syrup, there was an overall air of comradery; a glamorous village held together by their shared interest in a humblingly good cause. "
— Carmen Rosy Hall, Vogue. Feb 2019

[kapa]

Madam, the flow of your presentation is so beautiful, I can't stop myself to praise you, though I don't like excel but still I subscribed your video, beautiful madam.😊

[nipunkavinda]

Thanks Daniel and Laila for your great effort to build these kind of utilities free for use. This is a release of a huge burden to most of Excel users...

[sachinrv]

Hi Leila;
Thanks for a wonderful utility. But somehow I feel, this thing is like using a cannon to kill a rabbit. The simple way is ALT+O+H+U (sheet un-hide), select sheet from the drop list and press ENT. For hiding sheets, use CTRL + mouse to select the sheets and press ALT+O+H+H. Once the user by heart the key strokes it will become cake walk.

[kendallchaffeeband]

I have an excel 2019 workbook that has tabs linked to the main sheet. I have been successful in hiding unused portions of the main page however now I am coming up with an error "Cant Push Objects off sheet" when I try to hide rows. Also to the right of the main sheet I have many columns I don't use so I've successfully hid them and below the data of the main sheet I've been able to hid that unused area. So why can't I now hid and data in the middle of the main sheet without getting this error??? Any thoughts would be helpful

[TheHellis]

That was a complex way of doing it.
I make the files a xlam file and add my "install code" which means if you open the xlam you get the option to install the code.
That way I can just send a file to a colleague and they (hopefully) can install it themselves.

I also have code that can update the code if I make a new version. A auto update of xlam files.
Makes it so much easier to administrate VBA code in a work environment where most have no clue.

[andylenihan]

Brilliant! Will definitely be using this. Does it handle only hidden sheets or also xlveryhidden sheets?
Thanks!
Update: did you edit the code? Daniels version doesn’t recognise using shift and ctrl for selecting multiple sheets?

[ravimittal]

Help me for vba
Column a is empty my entries are in b, c, d, e, f....and if I write sold in column a in any cell then that row cuts and gets paste in the end of sheet2
Thanks

[NavneetPriyeChauhan]

Thanks Leila, your videos are great help. My work sometime requires me to move through different workbooks, so I keep most of them open or hidden. I request you to help me unhide workbooks all at once or any utility like this one to unhide a list of workbooks those are hidden.

[alipezu]

How did you record your screen and face simultaneously? Did you record you face using a camera and later you embeded with your screen recorded video?

[pralhadgujar]

Hi leila, i have created the personal workbook but its showing run-time error 13 while un-hide

[RGlen]

Really cool! Is there a similar quick utility option to unhide rows and columns?

[antoniosangelidis]

Thank you Daniel & Leila for sharing with us. You just made my working life so much more easy and beautiful!!! You are a blessing for the Excel Users community. I have no words!!!

[stephenbrincat]

Thanks for sharing Liela, very useful.

[aperkinsvt]

Thank you Leila and Daniel! I’m going to add that to my ribbon this morning.

And congratulations on reaching 100k subscribers - not at all surprising!