3 Methods to Unhide All Sheets in Excel (& how to hide)
Check the Excel Essentials Course:
How can you un-hide all Excel sheets at once? Hiding many worksheets at once is easy in Excel. Click on a sheet, hold down the control or the shift key, click on the other sheets you’d like to hide, right-mouse click and select hide.
Now what if you wanted to unhide all the sheets in one go? If you right-mouse click on any sheet name and select unhide – a new window opens with a list of hidden sheets. Unfortunately you can’t use the control key or the shift key to select multiple sheets to unhide. You have to unhide tabs one by one.
Find out 3 methods you can use to un-hide:
1. Use Custom views to quickly unhide all sheets – no Excel VBA is needed here
2. Use the Immediate Window in VBA – type in or copy and paste a very simple macro
3. Save the macro in your Excel personal macro Workbook. You can add a button for the macro to your Quick Access Toolbar so it is available for ALL your Excel workbooks – also the ones that are not macro-enabled (just xlsx).
⯆ Blog Post:
LINKS to related videos:
Excel VBA FOR EACH Loop:
Excel VBA full playlist:
★ My Online Excel Courses ►
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
EXCEL RESOURCES I Recommend:
Get Office 365:
Microsoft Surface:
GEAR
Camera:
Screen recorder:
Microphone:
Lights:
More resources on my Amazon page:
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!
#MsExcel
Nguồn: https://77days.net/
Xem thêm bài viết khác: https://77days.net/tong-hop/
Xem thêm Bài Viết:
- 4+ lợi thế đến từ mặt bằng dự án Sunrise Riverside
- Người nước ngoài có được mua bán nhà đất Tuy Hòa, Phú Yên không?
- Top 3 nước mạnh nhất trong bảng xếp hạng kinh tế thế giới 2017
- Địa chỉ nào thuê chung cư mini ở Thanh Xuân không bị lừa đảo
- Kinh nghiệm khắc phục lỗi your windows license will expire soon win 8
Comments
Leila Gharani
AuthorWould you like the ability to select which sheets you'd like to unhide? You can download the Excel Unhide Utility for free from the description of this video: https://youtu.be/1wcF-qCSgfI. In the video, I show you how to install it.
Mike Miller
AuthorYou 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!
Terry Douglas Jayasuriya
AuthorExcellent! Thanks Leila.
Cassandra Bishop
AuthorI'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! 😀
Marcus Whitfield
AuthorGreat Vid 👍
Amin Rahman
AuthorYes
Together We Excel
AuthorNice… I have a similar video on my channel. You can check and leave comments 🙂
Henric Andersen
AuthorAnother great video. Thank you 🙏
Yoke Boon Fong
Author3
Mirko Biljan
AuthorThanks for your making this video. Tip 3 is very useful to me…
ALINA TANASA
AuthorI tried to use the second scenario and I get an error. Leila can you tell me why?
Pankaj Maheshwari
AuthorI use "For each ws in sheets: ws.visible=true: next" in immediate window
Industryserveengineers Industryserveengineers
Authorinclude more formulas related to construction industry , specially for quantity sirveyors
Industryserveengineers Industryserveengineers
Authorwow u r the best , ur tutorials are super helpful, the way u present them is wooooooooooooooooooooooowwwwwwwwwwwwwwwwwwwww
Sanjay Gupta
AuthorYou are really nice
Soul of Chogokin
AuthorHi Leila! How Are you? I wonder if you have any tutorial video on how to auto hide rows (which is not selected) based on users selection using drop down list. Only the selected list will appear. Thanks you so much!
LUCKY OSAGHAE
AuthorSuddenly all my sheets disappeared…. Even the current sheet im working on the Excel Window isnt showing add sign.
What can i do?
Matthias Gollan
AuthorThird method is my favorite. Thx. 😀
Nadim
AuthorBig help! Appreciate it.
Muhammad Bilal
AuthorNice Work
sakhi mohammad hamidy
AuthorIs it possible to save a personnel function, which can be used in a newly opened xlsx doc? I tried by myself but couldn"t find my function.
Sibendu Jena
AuthorHow to hyperlink a document through excel and if I change the location of the file then the hyperlink shod be automatically updated can you please guide me that.
nohaynombrelibreeeee
AuthorThank you Leila! The third one is my favorite 🙂
Ayo Awosoji
AuthorThis 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
Nicholas Matthews
AuthorExcellent tip, loved both options, had used the second one first but plan on setting up a personal worksheet, subscribed
Dennis Hena
AuthorThanks 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.
Jon Meals
AuthorI use ASAP utilities, it has an Unhide All function I use everyday.
Kavitha Jayakumar
AuthorFirst one is easy….but 3rd is super
Dimitri Adhikary
AuthorThird one is the best!
Bhikaji Gawade
Authori tried the second way but it showed "compile error ! Cant find project or library ".ca you help me out
ubaidur hadi
AuthorThanks you very much very use full information
jojo colquitt
AuthorI can't figure out how to unhide a password protected sheets. Any ideas? when I right click on a tab, the "unhide" menu option is grayed out.
prince gautam
AuthorWe could use alt + OHU
Vicky Ca
AuthorYes.. I use it frequently coz u work with a lot of sheets
Sha Mangar
AuthorNice and useful, thank you
Veasna Skg
Authorgood video