How to Delete All Hidden Worksheets with One Click in Excel 365?
Tags: deleteallhiddenworks, kutoolsexceltutorial, kutools
Published: 2020-10-17 07:30:00

---
title: How to Delete All Hidden Worksheets with One Click in Excel 365?
published: true
date: 2020-10-17 07:24:39 UTC
tags: DeleteAllHiddenWorks,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-delete-all-hidden-worksheets-with-one-click-in-excel-365/
---

In this tutorial, we will guide you to learn the steps to **Delete All Hidden Worksheets with One Click in Excel**  **Office 365** using **Kutools.** Let’s get 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.

## Delete All Hidden Worksheets:

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

- [**Open the workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) which contains the hidden worksheets.

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

- Then, go to the **Kutools Plus Tab, select** the **Worksheet** option, **choose** the **Delete All Hidden Sheets** option from the drop-down list.

![Select Delete All Hidden Sheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Delete-All-Hidden-Sheets-option.png)<figcaption id="caption-attachment-15917">Select Delete All Hidden Sheets option</figcaption>

- Now, **Kutools for Excel dialog box** will pop out to ask you whether you want to delete the hidden sheets or not.

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

- You need to **click Yes** to delete all the hidden sheets and it will open the prompt box to tell you how many sheets have been deleted successfully.

![Kutools for Excel prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Kutools-for-Excel-prompt-box.png)<figcaption id="caption-attachment-15919">Kutools for Excel prompt box</figcaption>

- You need to **click OK** to close this prompt box and you can see that the hidden sheets are deleted from your workbook as shown in the below screenshot.

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

## Verdict:

In this short article, you can clearly learn the steps to **Delete All Hidden Worksheets with One Click in Excel**  **Office 365** using **Kutools ** with an example. Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Toggle All Hidden Columns to be Visible or Invisible in Excel](https://geekexcel.com/toggle-all-hidden-columns-to-be-visible-or-invisible-in-excel-365/)
- [Prevent Duplicate Entries in a Column](https://geekexcel.com/how-to-prevent-duplicate-entries-in-a-column-in-excel-office-365/)