77days - Tin sức khỏe cho cuộc sống thêm tốt hơn
  • Home
  • Công Nghệ
  • Ẩm Thực
  • Kinh Doanh
No Result
View All Result
  • Home
  • Công Nghệ
  • Ẩm Thực
  • Kinh Doanh
No Result
View All Result
77days - Tin sức khỏe cho cuộc sống thêm tốt hơn
No Result
View All Result
Home Tổng Hợp

3 Methods to Unhide All Sheets in Excel (& how to hide)

admin by admin
July 11, 2020
in Tổng Hợp
36
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:

  • Bounce Rate là gì? Nguyên nhân khiến cho Bounce Rate tăng cao
  • Kinh nghiệm mua thiết bị tiết kiệm điện thông minh
  • 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
Previous Post

Front Line, 1982 Taito

Next Post

Hướng Dẫn Chế Độ Dinh Dưỡng Cho Người Tập Gym Từ A-Z

Next Post
Hướng Dẫn Chế Độ Dinh Dưỡng Cho Người Tập Gym Từ A-Z

Hướng Dẫn Chế Độ Dinh Dưỡng Cho Người Tập Gym Từ A-Z

Comments 36

  1. Leila Gharani says:
    2 years ago

    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.

    Reply
  2. Mike Miller says:
    2 years ago

    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!

    Reply
  3. Terry Douglas Jayasuriya says:
    2 years ago

    Excellent! Thanks Leila.

    Reply
  4. Cassandra Bishop says:
    2 years ago

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

    Reply
  5. Marcus Whitfield says:
    2 years ago

    Great Vid 👍

    Reply
  6. Amin Rahman says:
    2 years ago

    Yes

    Reply
  7. Together We Excel says:
    2 years ago

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

    Reply
  8. Henric Andersen says:
    2 years ago

    Another great video. Thank you 🙏

    Reply
  9. Yoke Boon Fong says:
    2 years ago

    3

    Reply
  10. Mirko Biljan says:
    2 years ago

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

    Reply
  11. ALINA TANASA says:
    2 years ago

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

    Reply
  12. Pankaj Maheshwari says:
    2 years ago

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

    Reply
  13. Industryserveengineers Industryserveengineers says:
    2 years ago

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

    Reply
  14. Industryserveengineers Industryserveengineers says:
    2 years ago

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

    Reply
  15. Sanjay Gupta says:
    2 years ago

    You are really nice

    Reply
  16. Soul of Chogokin says:
    2 years ago

    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!

    Reply
  17. LUCKY OSAGHAE says:
    2 years ago

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

    Reply
  18. Matthias Gollan says:
    2 years ago

    Third method is my favorite. Thx. 😀

    Reply
  19. Nadim says:
    2 years ago

    Big help! Appreciate it.

    Reply
  20. Muhammad Bilal says:
    2 years ago

    Nice Work

    Reply
  21. sakhi mohammad hamidy says:
    2 years ago

    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.

    Reply
  22. Sibendu Jena says:
    2 years ago

    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.

    Reply
  23. nohaynombrelibreeeee says:
    2 years ago

    Thank you Leila! The third one is my favorite 🙂

    Reply
  24. Ayo Awosoji says:
    2 years ago

    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

    Reply
  25. Nicholas Matthews says:
    2 years ago

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

    Reply
  26. Dennis Hena says:
    2 years ago

    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.

    Reply
  27. Jon Meals says:
    2 years ago

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

    Reply
  28. Kavitha Jayakumar says:
    2 years ago

    First one is easy….but 3rd is super

    Reply
  29. Dimitri Adhikary says:
    2 years ago

    Third one is the best!

    Reply
  30. Bhikaji Gawade says:
    2 years ago

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

    Reply
  31. ubaidur hadi says:
    2 years ago

    Thanks you very much very use full information

    Reply
  32. jojo colquitt says:
    2 years ago

    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.

    Reply
  33. prince gautam says:
    2 years ago

    We could use alt + OHU

    Reply
  34. Vicky Ca says:
    2 years ago

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

    Reply
  35. Sha Mangar says:
    2 years ago

    Nice and useful, thank you

    Reply
  36. Veasna Skg says:
    2 years ago

    good video

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Xem Thêm

Ở đâu bán bật lửa chính hãng và chất lượng tại khu vực Hà Nội?

Ở đâu bán bật lửa zippo chất lượng nhất tại khu vực Hà Nội

April 25, 2021
quan-pho-ngon-1

Top 5 quán phở ngon nhất Quy Nhơn bạn nên thử

April 30, 2021
Món đồ bày trí phòng ngủ ý nghĩa

Tác dụng của những món đồ trang trí phòng ngủ theo phong thuỷ

June 4, 2021
Dòng máy ép chân không công suất lớn

3 lý do cần mua máy hút chân không công suất lớn

June 17, 2021
Máy xay giò chả mini có giá dưới 10 triệu đồng

Tư vấn chọn mua máy xay giò chả hợp túi tiền 

June 19, 2021
Máy vặt lông gà vịt tốt nhất tại NEWSUN

Nên mua máy nhổ lông gà vịt của Viễn Đông hay NEWSUN?

June 19, 2021
  • Liên Hệ
  • Chính Sách Bảo Mật

© 2022 JNews - Premium WordPress news & magazine theme by Jegtheme.

No Result
View All Result
  • Home
  • Công Nghệ
  • Ẩm Thực
  • Kinh Doanh

© 2022 JNews - Premium WordPress news & magazine theme by Jegtheme.