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 Easy Ways to UNHIDE ALL SHEETS in Excel (with & without VBA)

admin by admin
July 19, 2020
in Tổng Hợp
14
3 Easy Ways to UNHIDE ALL SHEETS in Excel (with & without VBA)



In this video, I will show you how to unhide worksheets in Excel (with or without VBA).

In Excel, you can hide multiple worksheets at one go but you can not unhide multiple sheets at one go. If you use the inbuilt functionality to unhide sheets, it will only unhide one sheet at a time.

However, there are a couple of methods you can use to unhide all sheets at one go in Excel.

This video covers the following methods to unhide sheets:
— Manually Unhide one sheet at a time
— Unhide all sheets using VBA code in the immediate window
— Unhide all sheets by using a VBA macro code and adding it to the quick access toolbar
— Unhide sheets using custom view option.

With VBA immediate window, you can quickly run a line of code by simply adding it in the immediate window and hitting the enter key.

Below is the line of code to use in the immediate window in the VB Editor:

For each Sheet in Thisworkbook.Sheets: Sheet.Visible=True: Next Sheet

As soon as you hit the enter key (after placing the cursor at the end of the line), it will instantly unhide all the hidden sheets.

The good thing about this is that you don’t need to save the Excel workbook as a macro-enabled workbook.

Another method is by saving a VBA macro code to unhide sheets in the personal macro workbook and then adding that code to the Quick Access Toolbar (QAT)

Doing this would allow you to work on any workbook and instantly unhide sheets with a click of a button.

Below is the VBA code to save in the personal macro workbook:

Sub UnhideAllSheets()
For Each Sheet In Sheets
Sheet.Visible = True
Next Sheet
End Sub

The third method to unhide sheets is by using custom views. You can save a custom view when all the sheets are visible and then when you have to unhide all the worksheets, you can go back to that view.

This method to unhide sheets is not suited in all situations but can be useful if you’re using custom views anyway.

Free Excel Course –
Paid Online Training –
Best Excel Books:

⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –

Subscribe to get awesome Excel Tips every week:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

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

Bảng Thống Kê Đặc Biệt XSMB Xo so mien bac 08/6/18

Next Post

Tìm số trung bình cộng - Bài Toán Trung Bình Cộng - Toán nâng cao lớp 4 - Liên hệ 0932393956

Next Post
Tìm số trung bình cộng – Bài Toán Trung Bình Cộng – Toán nâng cao lớp 4 – Liên hệ 0932393956

Tìm số trung bình cộng - Bài Toán Trung Bình Cộng - Toán nâng cao lớp 4 - Liên hệ 0932393956

Comments 14

  1. Subrata Dutta says:
    2 years ago

    Very Nice

    Reply
  2. Munendra Rathore says:
    2 years ago

    Great initiative sumit….

    Reply
  3. sharad gupta says:
    2 years ago

    found many video similar to liela gharani.

    Reply
  4. Mustafe Salaat says:
    2 years ago

    hello sumit

    thanks for your video.

    using userform. can add – + for example. sumit to paid 100, sumit have paid 100.
    to paid have paid to paid
    sumit 100 – 100 0
    can do so when using userform?

    Reply
  5. Ray Noland says:
    2 years ago

    Un-hiding several worksheets are a real pain. Thanks for the tip.

    Reply
  6. Bill Palmer says:
    2 years ago

    Thanks for sharing, Sumit.

    Reply
  7. Kul Bhushan Gupta says:
    2 years ago

    Your tips are really useful.

    Reply
  8. Brian Dennehy says:
    2 years ago

    Very nice solution to a very annoying problem 👌

    Reply
  9. Michel Baudoin says:
    2 years ago

    Great Trick !

    Reply
  10. Roufai Ouma says:
    2 years ago

    Very usefull

    Reply
  11. Anil Kumar says:
    2 years ago

    Y DNT you start VBA programming sir…ur explaining super

    Reply
  12. Wayne Edmondson says:
    2 years ago

    Hi Sumit.. thanks for the video. Love the Immediate Window in the VBE and VB in general.. gives so many ways to solve simple problems on the fly and also complex problems, as well. Thanks for sharing your tips. Thumbs up!

    Reply
  13. Hany Maslouh says:
    2 years ago

    Thank you

    Reply
  14. Gazi Afzal says:
    2 years ago

    Good one!

    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.