How to Hide or Unhide Workbooks and Sheets in Excel Office 365?
Tags: kutoolsexceltutorial, stepstohideorunhidew, kutools
Published: 2020-10-27 12:21:34

---
title: How to Hide or Unhide Workbooks and Sheets in Excel Office 365?
published: true
date: 2020-10-27 11:59:49 UTC
tags: KutoolsExcelTutorial,StepstoHideorUnhideW,Kutools
canonical_url: https://geekexcel.com/how-to-hide-or-unhide-workbooks-and-sheets-in-excel-office-365/
---

In this article, we will discuss how to **Hide or Unhide Workbooks and sheets 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.
## Hide/Unhide Workbook and Sheets:

To do this, Kutools has a specific feature that can help to do the following actions.

- Hide or unhide all open workbooks with one click.
- You can quickly hide or [unhide all sheets](https://geekexcel.com/how-to-show-all-hidden-worksheets-with-one-click-in-excel-365/).
- To make a worksheet very hidden.

Do as below instructions to complete the task.

- Go to the **Kutools Tab, select** the **Show**  **& Hide** option, then **choose** the **Hide/Unhide Workbooks And Sheets** option from the drop-down list.

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

- It will open the **Hide/Unhide Workbooks And Sheets Dialog Box.**
- **Workbook windows –** In this section, you can see the checked or unchecked workbooks. **Checked** workbooks will be **unhidden** and the **unchecked** workbooks will be **hidden.**
- You can also hide some worksheets from your workbook, to do that **click** the **Visible** drop-down list to **choose** the **Visible, Hidden,** or **Very Hidden** option after the workbook that you need.

![Hide/Unhide Workbooks And Sheets Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-22.png)<figcaption id="caption-attachment-16350">Hide/Unhide Workbooks And Sheets Dialog Box</figcaption>

- **Hidden –** This option will help you to hide the selected sheet.
- **Very Hidden** – It can hide the sheets absolutely that others cannot display or open.

### Additional Info:

- **Hide all button –** It will hide all workbooks.
- **Unhide all button –** With this option, you will unhide all workbooks.
- **Hide all but –** This option will hide all the inactive worksheets.
- You cannot hide all worksheets in a workbook but you can hide a whole workbook.

## Summary:

In this article, you can clearly understand the instructions to **Hide or Unhide Workbooks and sheets in Excel Office 365** using **Kutools.** Leave your valuable **queries/suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [How to Delete All Hidden Worksheets with One Click in Excel 365?](https://geekexcel.com/how-to-delete-all-hidden-worksheets-with-one-click-in-excel-365/)
- [Toggle All Hidden Columns to be Visible or Invisible in Excel 365!!](https://geekexcel.com/toggle-all-hidden-columns-to-be-visible-or-invisible-in-excel-365/)