Toggle All Hidden Sheets to be Visible or Invisible in Excel Office 365!!
Tags: kutoolsexceltutorial, stepstotoggleallhidd, kutools
Published: 2020-10-15 12:03:51

---
title: Toggle All Hidden Sheets to be Visible or Invisible in Excel Office 365!!
published: true
date: 2020-10-15 11:50:54 UTC
tags: KutoolsExcelTutorial,StepstoToggleAllHidd,Kutools
canonical_url: https://geekexcel.com/toggle-all-hidden-sheets-to-be-visible-or-invisible-in-excel-office-365/
---

In this post, we will show how to **Toggle All Hidden Sheets to be Visible or Invisible in Excel Office 365** using **Kutools** with the example images. Let’s jump 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.

## Toggle All Hidden Sheets in Excel:

You can easily make all [hidden sheets to be visible](https://geekexcel.com/easily-unhide-sheet-in-microsoft-excel-2013/) or invisible in your workbook, please do the below steps.

- You need to [**open the workbook**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) which should contain the hidden sheets.
- We have shown the workbook sheet tabs in the below screenshot, where you can see that the **sheet 2** , **sheet 3** , and **sheet 4** are **hidden.**

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

- Next, on the **Kutools Tab, select** the **Show & Hide** option, **choose** the **Worksheets** option from the drop-down list.

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

- Now, all the **hidden sheets will be visible** as shown in the below image.

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

- If you again click the Worksheets option, previously **hidden sheets will become invisible**.
- Refer to the below image.

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

From the above image, you can see that the hidden sheets are invisible when you again click the Worksheets option. This is how you can toggle hidden worksheets to make visible or invisible.

## Closure:

In this short article, you can clearly understand the steps to **Toggle All Hidden Sheets to be Visible or Invisible in Excel Office 365** using **Kutools** with the example images. Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Insert File Name and File Path into Cell, Header, or Footer in Excel](https://geekexcel.com/insert-file-name-and-file-path-into-cell-header-or-footer-in-excel/)
- [Find Duplicate or Unique Cells/Rows in a Range](https://geekexcel.com/find-duplicate-or-unique-cells-rows-in-a-range-in-excel-365/)