How to Hide All Inactive (Non-Selected) Worksheets in Excel 365?
Tags: hideallinactiveworks, kutoolsexceltutorial, kutools
Published: 2020-10-30 07:14:09

---
title: How to Hide All Inactive (Non-Selected) Worksheets in Excel 365?
published: true
date: 2020-10-29 12:14:03 UTC
tags: HideAllInactiveWorks,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-hide-all-inactive-non-selected-worksheets-in-excel-365/
---

In this post, we will discuss how to **Hide All Inactive or Non-selected Worksheets in Excel Office 365** using **Kutools.** 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.
- You can reuse anything with the help of Kutools. The most used formulas, charts, or anything else you reuse in the future.
- The Split Tools utility will help you to split the data into multiple sheets based on the values.
## Hide All Inactive Sheets:

Here are the instructions you need to follow to hide some inactive [worksheets](https://geekexcel.com/how-to-hide-or-unhide-workbooks-and-sheets-in-excel-office-365/) in the Excel workbook.

- You need to **select the worksheets** that you don’t want to hide by holding **CTRL-key**.

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

- Go to the **Kutools Tab, select** the **Show & Hide** option, then **choose** the **Hide Unselected Sheets** option from the menu.

![Select Hide Unselected Sheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-24.png)<figcaption id="caption-attachment-16476">Select Hide Unselected Sheets option</figcaption>

- Now, all the inactive or non-selected worksheets are hidden from the workbook as shown in the below image.

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

### Added Info:

- You can unhide all the hidden worksheets by using **Unhide All Sheets** option from the **Show & Hide** group.
- Check this too: [Show All Hidden Worksheets with One Click in Excel 365](https://geekexcel.com/how-to-show-all-hidden-worksheets-with-one-click-in-excel-365/)

## Verdict:

In this post, you can easily understand the steps to **Hide All Inactive or Non-selected Worksheets in Excel Office 365** using **Kutools. ** Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to Insert a Date or Formatted Date in Excel Office 365?](https://geekexcel.com/how-to-insert-a-date-or-formatted-date-in-excel-office-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/)
- [Toggle All Hidden Sheets to be Visible or Invisible in Excel Office 365!!](https://geekexcel.com/toggle-all-hidden-sheets-to-be-visible-or-invisible-in-excel-office-365/)
- [How to Remove All Macros within Worksheet or Workbook in Excel?](https://geekexcel.com/how-to-remove-all-macros-within-worksheet-or-workbook-in-excel/)