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
Note: kutools for Excel 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.
- 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.
- 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.
- 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. Keep Learning!
Top comments (0)