How to Show All Hidden Worksheets with One Click in Excel 365?

In this article, we are going to see how to Show All Hidden Worksheets with One Click in Excel Office 365 using Kutools. Let’s step into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

Show All Hidden Sheets:

To show all hidden sheets in your Excel workbook, you need to follow the below simple steps.

• Open the workbook which contains some hidden sheets.
• The below example image has shown the workbook with two hidden sheets ( Sheet 2 & Sheet 3 ).

Example

• Then, go to the Kutools Tab, select the Show & Hide option, Unhide All Hidden Sheets option from the drop-down list.

Kutools Tab

• At last, you can see that all the hidden sheets will be displayed in your workbook as shown in the below screenshot.

Result

Added Information:

• If you want to Unhide All Hidden Workbook Windows with one click in Excel, refer to this article.
• You can remove all the hidden sheets in Excel. To do this, keep reading on Delete All Hidden Worksheets.
• To toggle Hidden sheets to be visible and invisible, read this post.

Wrap-Up:

From the above article, you can understand the steps to Show All Hidden Worksheets with One Click in Excel Office 365 using Kutools. Kindly, share your feedback in the below comment section. Thanks for visiting Geek Excel. Keep Learning!

Read Also:

• How to Convert Days to Years, Months, and Days in Excel 365?
• How to Select All Unlocked Cells in Excel Office 365? – [with Example]