How to Show All Hidden Worksheets with One Click in Excel 365?
Tags: kutoolsexceltutorial, stepstoshowallhidden, kutools
Published: 2020-10-22 12:16:08

---
title: How to Show All Hidden Worksheets with One Click in Excel 365?
published: true
date: 2020-10-22 07:12:28 UTC
tags: KutoolsExcelTutorial,StepstoShowAllHidden,Kutools
canonical_url: https://geekexcel.com/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](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) 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](https://geekexcel.com/how-to-unhide-a-worksheet-in-microsoft-excel-365/) 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-25.png)<figcaption id="caption-attachment-16200">Example</figcaption>

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

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Kutools-Tab-1.png)<figcaption id="caption-attachment-16201">Kutools Tab</figcaption>

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

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-34.png)<figcaption id="caption-attachment-16202">Result</figcaption>

### Added Information:

- If you want to [**Unhide All Hidden Workbook Windows**  ](https://geekexcel.com/unhide-all-hidden-workbook-windows-with-one-click-in-excel-365/)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.](https://geekexcel.com/how-to-delete-all-hidden-worksheets-with-one-click-in-excel-365/)**
- To **[toggle Hidden sheets to be visible and invisible](https://geekexcel.com/toggle-all-hidden-sheets-to-be-visible-or-invisible-in-excel-office-365/),** 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.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Convert Days to Years, Months, and Days in Excel 365?](https://geekexcel.com/how-to-convert-days-to-years-months-and-days-in-excel-365/)
- [How to Select All Unlocked Cells in Excel Office 365? – [with Example]](https://geekexcel.com/how-to-select-all-unlocked-cells-in-excel-office-365-with-example/)