Good news! If you have Office 365 you can now unhide multiple sheets at once! YAY! If you don't have Office 365, you can download this Excel Unhide Utility for free from the description of this video: th-cam.com/video/1wcF-qCSgfI/w-d-xo.html. In the video, I show you how to install it.
This is good one. Mostly people are wary of using macros; which include me as well. Therefore the one I personally like is custom view; because once the same is defined; Excel takes care of the unhide task by itself. All these years I am habitual using short cut key ALT+O+H+H for hide and ALT+O+H+H+U for unhide. The flip side is you need to logically by-heart the key stokes which can be practiced. Thanks Leila for upload
You are like awesome! I work for the largest healthcare company in the world and loved this feature for Excel. I chose #3 as my method of opening up all sheets, thank you so much!
Hi Leila.. thanks for the video on un-hiding sheets. That process is always a chore to do one by one. I wrote a small Sub and put it on my QAT with the UP arrow icon to signify to un-hide all worksheets with a click. I never considered doing it on the fly using the Immediate Window.. what a great tip. In that regard, another issue is when I get a workbook from a client with different zoom levels on the worksheets and also with the cell pointer in different locations on each sheet. Before getting started, I like to set all sheet zooms to 100 and move the pointer to cell A1 on each sheet and then start on Sheet1 as the active sheet. In the spirit of your un-hide lesson, I came up with the following to use in the Immediate Window: For Each ws in Worksheets: ws.Activate: ActiveWindow.Zoom = 100: Range("A1").Select: Next ws: Sheets(1).Select. It even works on hidden sheets. While I could put this in a Sub and on the QAT, you showed that it is quick to open the VBE and IW and then type in what you want to do on the fly. Thanks for that tip and the insight to put it to use in other ways. Thumbs up!
Thank you Wayne. That's a great tip regarding the immediate window to set all sheets to A1 and adjust zoom level accordingly! I will add your tip to the blog post. Thank you very much :)
Thanks Leila.. glad to contribute. Credit to you for teaching me how to think about these solutions and put your lessons to good use in different ways. Thumbs up!
I used the macros method for a long time and it was very useful. Unfortunately I was facing problems like random crashing of all opened Excels when opening multiple workbooks. I realised it once I reinstalled MS Office. Don't know exactly what caused it though. I'm forced not to use it now. Nevertheless I am grateful to @Laila for sharing her ideas with us. Very inspiring.
This is cool and thank you Leila for always putting out content...Thank you really.I know you may not have time to read this ..But i really appreciate the effort yo put into everything you do...to make this channel value-adding. Thanks
Always enjoy Leila's videos and this one in particular is really useful. I like the macro solution because I don't need to ALT F11 and go to notepad each time - very helpful, so thank you!
I just found out that there is a visual basic editor feature in exel ... it's really very helpful, because there are dozens of hidden sheets, thank you very much for the knowledge.. Thank you very much from Indonesia 😄🇮🇩🇮🇩🇮🇩
I like the first option to proactively provide a way to unhide the sheets. However, I'm too deep in this workbook to start over; so, the 3rd option - creating a macro - genius! And your step by step tutorial was easy for me to follow! Thank you!
I bought your 5 Excel courses at once on Udemy.com and I highly recommand them to anyone who wants to improve their skills with Excel/ VBA without getting bored with online courses because your enthousiam is contagious ;)
What an interesting video. Love the immediate window idea. Always wondered how to send . Makes sense though... I use this syntax in a module like this also... For example... Dim rng as Range:set rng = sheet1.range("A1:A10")
I want to hide a sheet or many sheets when they are not in use but unhide when selected. I gain access to these sheets via macro push buttons on the master sheet of my workbook. But if I hide the sheets the macros dont work anymore. Can I get around this please. Thanks in advance I find your help very useful and Im very happy I found your channel please dont stop!!!!
This is very useful. I would use this in conjunction with a short macro that I have that deletes hidden worksheets. I can envision two macros in my personal workbook, one to un-hide and also the other to delete all hidden worksheets.
I'd love to hear your suggestions on restricting worksheet access (e.g., if an employee or client should not have access to the raw data of a particular worksheet or group of worksheets in a workbook that is being used by multiple people). I've seen some helpful tutorials for the VeryHidden feature but I wonder if there might be a more secure way with password protection. Currently, password protection doesn't seem to stop people from viewing the data (if they unhide the worksheet tab). Thank you for sharing this, your videos are always so helpful! :D
Video requests 1.how to make the negative time visible in excel (say 4Hrs -5hrs) 2.how to compare the current cell value with its previous value (it will be helpful in share trading sheet to know how much the share price has changed)
Method 3 is the most convenient way to unhide all worksheets. I have been using this method for long and it's really a time-saver. One tip to make it even more handy... I put it as the third icon on QAT, so that I can access to it through keyboard shortcut: Alt 3 As simple as that :)
Thanks for this, Leila! I liked the third option, creating a custom macro/button to activate it. Not sure why MS wouldn't build in this function into their own software.
Good news! If you have Office 365 you can now unhide multiple sheets at once! YAY!
If you don't have Office 365, you can download this Excel Unhide Utility for free from the description of this video: th-cam.com/video/1wcF-qCSgfI/w-d-xo.html. In the video, I show you how to install it.
Thank You For that I try to Get this tool
Hello, will the above methods will also apply to windows10?
This is good one. Mostly people are wary of using macros; which include me as well. Therefore the one I personally like is custom view; because once the same is defined; Excel takes care of the unhide task by itself. All these years I am habitual using short cut key ALT+O+H+H for hide and ALT+O+H+H+U for unhide. The flip side is you need to logically by-heart the key stokes which can be practiced. Thanks Leila for upload
Thank you Sachin - agree, the custom view can come in really handy. Also thank your for the shortcut tip :)
You are like awesome! I work for the largest healthcare company in the world and loved this feature for Excel. I chose #3 as my method of opening up all sheets, thank you so much!
That is awesome Mike! Glad it was helpful.
Very nice to see multiple possibilities for a single problem.
Thank you! I am glad you like the tutorial.
Life saviour. I have a model due tonight and I somehow hid all sheets but could not make them visible. The VBA method worked. Thank you!!!!
I love the simplicity od custom views! Thanks Leila for hide-unhide fun!
Third option opens a world of possibilities for me, thank you very much.
Hi Leila.. thanks for the video on un-hiding sheets. That process is always a chore to do one by one. I wrote a small Sub and put it on my QAT with the UP arrow icon to signify to un-hide all worksheets with a click. I never considered doing it on the fly using the Immediate Window.. what a great tip. In that regard, another issue is when I get a workbook from a client with different zoom levels on the worksheets and also with the cell pointer in different locations on each sheet. Before getting started, I like to set all sheet zooms to 100 and move the pointer to cell A1 on each sheet and then start on Sheet1 as the active sheet. In the spirit of your un-hide lesson, I came up with the following to use in the Immediate Window: For Each ws in Worksheets: ws.Activate: ActiveWindow.Zoom = 100: Range("A1").Select: Next ws: Sheets(1).Select. It even works on hidden sheets. While I could put this in a Sub and on the QAT, you showed that it is quick to open the VBE and IW and then type in what you want to do on the fly. Thanks for that tip and the insight to put it to use in other ways. Thumbs up!
Thank you Wayne. That's a great tip regarding the immediate window to set all sheets to A1 and adjust zoom level accordingly! I will add your tip to the blog post. Thank you very much :)
Thanks Leila.. glad to contribute. Credit to you for teaching me how to think about these solutions and put your lessons to good use in different ways. Thumbs up!
Its amazing how everything is so simple with you ! Many thanks !!!
Method 3! Wow this saves me so much time! Thank you.
legend - you saved me soooo much time - thanks so much
I like the tip/technique for adding a macro button to the quick toolbar section.
Very handy - thanks
Oh my gosh - this is so helpful. Thank you !!
You're so welcome, Bill!
Very nice tutorial and clear explanation! I suppose 2nd option, using immediate window would be potentially the simpliest way =)
An excellent video from Leila! The first method is so simple to use. Thanks Leila
Excellent tip, loved both options, had used the second one first but plan on setting up a personal worksheet, subscribed
OMG!! I love you!! I am becoming a ninja at work :D
Nice tips. Thanks!
Wow!!! second option is soooooo cool. Thank you so much!
Boy have been waiting for this option. Thanks in million
You're very welcome Mohammed :)
wow u r the best , ur tutorials are super helpful, the way u present them is wooooooooooooooooooooooowwwwwwwwwwwwwwwwwwwww
I used the macros method for a long time and it was very useful. Unfortunately I was facing problems like random crashing of all opened Excels when opening multiple workbooks. I realised it once I reinstalled MS Office. Don't know exactly what caused it though. I'm forced not to use it now. Nevertheless I am grateful to @Laila for sharing her ideas with us. Very inspiring.
No. 3 wins !!! Thanks for sharing.
VBA is the way I do it. Hiding/unhiding all very hidden sheets. Password protected as well. Great work Leila :-)
Thank you , have learnt a lot from your channel.
Literally saved so much of my time, thanks a ton!
Third method is my favorite. Thx. 😀
This is cool and thank you Leila for always putting out content...Thank you really.I know you may not have time to read this ..But i really appreciate the effort yo put into everything you do...to make this channel value-adding. Thanks
Always enjoy Leila's videos and this one in particular is really useful. I like the macro solution because I don't need to ALT F11 and go to notepad each time - very helpful, so thank you!
Glad it was helpful!
I just found out that there is a visual basic editor feature in exel ... it's really very helpful, because there are dozens of hidden sheets, thank you very much for the knowledge..
Thank you very much from Indonesia 😄🇮🇩🇮🇩🇮🇩
I like the first option to proactively provide a way to unhide the sheets. However, I'm too deep in this workbook to start over; so, the 3rd option - creating a macro - genius! And your step by step tutorial was easy for me to follow! Thank you!
Glad it was helpful, Beth!
Thank you! I used the 2nd option and then BOOM! Tadahhhh! Fixed
Glad it helped!
Thanks Leila, you helped my again. Your a genius! I prefer the third option.
Excellent! Thanks Leila.
Excellent video Leila
I like the 3rd option with the easy access button Thank you, Leila.
Agree - This one comes in really handy if you need it often...
Thanks for your making this video. Tip 3 is very useful to me...
I bought your 5 Excel courses at once on Udemy.com and I highly recommand them to anyone who wants to improve their skills with Excel/ VBA without getting bored with online courses because your enthousiam is contagious ;)
Thank you Walid for your support of my courses & TH-cam tutorials! I am very glad you enjoy them :)
This is super helpful. God bless you!! That's the best.
Thanks for the trifecta of unhiding fun : )
You're 3x welcome :)
I love it! It was very useful :)
The 3rd one is very useful! :)
extremely grateful for this video
This is great. hope to see more sharing on what immediate window can do in excel
Simple and super technique. Thanks a lot.
Third one is my favorite.Thanks for all!!!
Thank you very much. Very helpful.
What an interesting video. Love the immediate window idea. Always wondered how to send . Makes sense though... I use this syntax in a module like this also... For example...
Dim rng as Range:set rng = sheet1.range("A1:A10")
Thanks again Leila, you saved the day!
I'm happy to hear that Hector :)
Thank you for a great and helpful video. I like method #3 👍
Wonderful video as always.. thank you. btw, the third method is what i'll be using
The last method, #3, is my favourite.
Yes I'm using unhide one by one..but your VBA method is awesome..that wl help a lot..you are just amazing..thanks a lot..😚😙
That's great that you can apply this!
Thanks for this trick.
My preference is for personal macros, but it was interesting to know about Custom views option too.
So really helpful.. thanks alot for Ms Leila Gharani...
Another great video. Thank you 🙏
Superb. Thanks for teaching.
Thank you so much for you videos:)
I like your videos so much . really I have learnt alot .. thank you
method 2 worked Awesome . thank you
Super awesome!! Thank you!!👍👍
Thank You. Great tutorial as always!
thank you 1st one not work. but 2nd one worked perfectly. superb!
Great 👍
I want to hide a sheet or many sheets when they are not in use but unhide when selected. I gain access to these sheets via macro push buttons on the master sheet of my workbook. But if I hide the sheets the macros dont work anymore. Can I get around this please. Thanks in advance I find your help very useful and Im very happy I found your channel please dont stop!!!!
liked the macro on. will give it a try.
Big help! Appreciate it.
My pleasure, glad to help.
This is very useful. I would use this in conjunction with a short macro that I have that deletes hidden worksheets. I can envision two macros in my personal workbook, one to un-hide and also the other to delete all hidden worksheets.
That sounds great!
Great! , I didn't know we can hide worksheets !!
I definitely like the 2nd one
cannot thank you enough
I like both methods
I liked the last one...infact I am using it it for 3 years now.
Thank you Leila! The third one is my favorite :-)
I'd love to hear your suggestions on restricting worksheet access (e.g., if an employee or client should not have access to the raw data of a particular worksheet or group of worksheets in a workbook that is being used by multiple people). I've seen some helpful tutorials for the VeryHidden feature but I wonder if there might be a more secure way with password protection. Currently, password protection doesn't seem to stop people from viewing the data (if they unhide the worksheet tab). Thank you for sharing this, your videos are always so helpful! :D
Do you dream in excel? How do you know all this? Impressive indeed.
Actually I sometimes do dream of Excel :)
Nice and useful, thank you
Thanks you very much very use full information
Nice explanation.
Glad you like it.
Thank god for this, life saver
Nice Work
Nice, Super-Sweet with 3
I always listening your tutorial. So Good. And good wishes.
Thank you for your support .
Leila Gharani thanks Leila gharani
Excellent!
Video requests
1.how to make the negative time visible in excel (say 4Hrs -5hrs)
2.how to compare the current cell value with its previous value (it will be helpful in share trading sheet to know how much the share price has changed)
This is just great! Thanks a ton!
You're very welcome Ankan. Thank you for your support.
Thanks Ms. Leila
Third one is the best!
Excellent, as always..
Great Vid 👍
Superb mam, thank you
Thank you so much
Thanks Leila. This is very interesting :)
You're very welcome John :)
Method 3 is the most convenient way to unhide all worksheets. I have been using this method for long and it's really a time-saver. One tip to make it even more handy... I put it as the third icon on QAT, so that I can access to it through keyboard shortcut: Alt 3
As simple as that :)
Great help maam
Thanks- a life saver??
Thanks for this, Leila! I liked the third option, creating a custom macro/button to activate it. Not sure why MS wouldn't build in this function into their own software.
True, sure would be useful.
you are gr8.
i will prefer 3rd one as it will always remain open in the background.
Very Nice Leila
Glad you like it.
Quick access tool bar is best option by far. Just takes a couple minutes to set up. Thx