How to quickly Hide Excel Workbooks in Excel?

Managing multiple open workbooks in Excel can clutter your workspace, especially when you need to concentrate on a particular dataset. Hiding workbooks you are not actively working on can streamline your screen and help maintain focus. This tutorial will discuss the methods available in Excel to easily hide and manage your workbooks.

• Hide workbooks one by one in Excel
• Hide workbooks in one click with Kutools for Excel
• Hide workbooks by using VBA

Hide workbooks one by one in Excel

For a few workbooks that you need to hide individually, the process is straightforward.

Click on the the workbook you want to hide. Go to the View tab, click on Hide button in the Windows group, then you may see the workbook has been hide. See screenshot

Hide workbooks in one click with Kutools for Excel

Kutools for Excel is a comprehensive toolkit that enhances the functionality of Excel through its powerful add-ins, designed to simplify complex tasks. One such feature is the Interactive Hide/Unhide utility, which allows users to efficiently manage the visibility of multiple workbooks and worksheets with ease. This tool is particularly useful for users who work with extensive data across various tabs and need a quick way to declutter their workspace.

After installing Kutools for Excel, you can apply Hide /Unhide Workbooks and Sheets to quickly hide all workbooks at once.

Step 1. Click Kutools > View > Hide / Unhide Workbooks and Sheets. See screenshot:

Step 2: The Hide / Unhide Workbooks and Sheets dialog box pops up, and you can flexibly hide or unhide workbooks and worksheets.

• To hide a workbook, uncheck it in the left pane. Check a workbook to unhide it.
• Similarly, you can hide or unhide individual worksheets from the right pane by checking or unchecking them.

 Hide workbooks by using VBA

For advanced users comfortable with VBA, hiding workbooks programmatically can be a powerful option

Sub HideWorkbook()
  'Update 20140717
    Application.Visible = False
End Sub

Related Article:

Quickly hide other workbooks (all inactive windows) in Excel.