Tổng Hợp

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


Get Office 365:
Microsoft Surface:

Screen recorder:

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!


Nguồn: https://77days.net/

Xem thêm bài viết khác: https://77days.net/tong-hop/

Tổng Hợp
| 2020 | Hướng dẫn chuyển đổi đuôi MOV sang MP4 giữ chất lượng cao [ Mỗi Ngày Một Niềm Vui ]
Tổng Hợp
Thiết kế nhà 2 tầng hiện đại trở thành xu hướng, vì sao?
Tổng Hợp
  • Would 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.

  • 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!

  • Excellent! Thanks Leila.

  • 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! 😀

  • Great Vid 👍

  • Yes

  • Nice… I have a similar video on my channel. You can check and leave comments 🙂

  • Another great video. Thank you 🙏

  • 3

  • Thanks for your making this video. Tip 3 is very useful to me…

  • I tried to use the second scenario and I get an error. Leila can you tell me why?

  • I use "For each ws in sheets: ws.visible=true: next" in immediate window

  • include more formulas related to construction industry , specially for quantity sirveyors

  • wow u r the best , ur tutorials are super helpful, the way u present them is wooooooooooooooooooooooowwwwwwwwwwwwwwwwwwwww

  • You are really nice

  • Hi 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!

  • Suddenly all my sheets disappeared…. Even the current sheet im working on the Excel Window isnt showing add sign.
    What can i do?

  • Third method is my favorite. Thx. 😀

  • NadimNadim

    Author Reply

    Big help! Appreciate it.

  • Nice Work

  • Is 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.

  • How 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.

  • Thank you Leila! The third one is my favorite 🙂

  • 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

  • Excellent tip, loved both options, had used the second one first but plan on setting up a personal worksheet, subscribed

  • 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.

  • I use ASAP utilities, it has an Unhide All function I use everyday.

  • First one is easy….but 3rd is super

  • Third one is the best!

  • i tried the second way but it showed "compile error ! Cant find project or library ".ca you help me out

  • Thanks you very much very use full information

  • I 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.

  • We could use alt + OHU

  • Yes.. I use it frequently coz u work with a lot of sheets

  • Nice and useful, thank you

  • good video