Skip to main content

How to hide all inactive worksheets in Excel? (Full guide)

Author: Zhoumandy Last Modified: 2024-05-27

Managing multiple worksheets in an Excel workbook can become cumbersome, especially when dealing with numerous inactive sheets. Hiding these inactive worksheets can help streamline your workflow and make navigating the active sheets easier. In this article, we’ll explore four different methods to hide all inactive worksheets in Excel.


Hide all inactive worksheets with right click in Excel

Step 1: Select inactive worksheets

Hold down the Ctrl key and click on the tabs of all other worksheets that you want to hide. You can also use the Shift key to select a consecutive group of sheets.

Step 2: Right click to hide inactive worksheets

Right click the selected sheets, and click Hide from the drop-down menu.

Result

Tip: This method is quick and effective but can be tedious if you have a large number of inactive sheets. If you would like to get an easier way, please use the Kutools for Excel method.


🌟 Instantly toggle all hidden sheets to be visible or invisible! 🌟

Save time and effort with Kutools for Excel's Toggle Hidden Worksheet Visibility feature! πŸš€

With the handy Toggle Hidden Worksheet Visibility button provided by Kutools for Excel, you can use one click to show all hidden worksheets in the active workbook and click it again to toggle all hidden worksheets to be invisible. It's as quick as lightning! ⚑

πŸ“Š Kutools for Excel: Supercharge Excel with over 300 essential tools. Enjoy a full-featured 30-day FREE trial with no credit card required! πŸš€

Download Now

One click to hide all inactive worksheet with Kutools for Excel

Kutools for Excel is a powerful add-in that provides advanced features to simplify many tasks in Excel, including hiding inactive worksheets. With just one click, all inactive worksheets will be hidden, leaving only the active one visible. It can save a lot of time and effort, especially with workbooks containing many sheets.

After installing Kutools for Excel, click Kutools > View > Hide Unselected Sheets to hide all sheets except the active sheet.

Result

All inactive worksheets are hidden at once.

Tip: To use this feature, you should install Kutools for Excel first, please click to download and have a 30-day free trial now.


Hide all inactive worksheet by using Format feature in Excel

Excel’s Format feature also allows you to hide inactive worksheets.

Step 1: Select inactive worksheets

Hold down the Ctrl key and click on the tabs of all other worksheets that you want to hide. You can also use the Shift key to select a consecutive group of sheets.

Step 2: Access Format feature to hide inactive worksheets

On the Home tab, click on Format in the Cells group. Under Visibility, select Hide/Unhide, then Hide Sheet.

Result

Tip: This method is quick and effective but can be tedious if you have a large number of inactive sheets. If you would like to get an easier way, please use the Kutools for Excel method.


Hide all inactive worksheets with VBA in Excel

For those comfortable with VBA (Visual Basic for Applications), creating a macro to hide all inactive worksheets can be an efficient method.

Step 1: Open the VBA module editor and copy the code
  1. Hold down the ALT + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.
  2. Click Insert > Module and paste the following code in the Module Window.
  3. VBA code: Hide all inactive worksheets
    Sub HideInactiveSheets()
     'Updateby Extendoffice
     
        Dim ws As Worksheet
      
        For Each ws In ThisWorkbook.Worksheets
            If ws.Name <> ActiveSheet.Name Then
                ws.Visible = xlSheetHidden
            End If
        Next ws
    End Sub
    
Step 2: Execute the code to get the result

After pasting this code, please press F5 key to run this code. All worksheets, except for the active (current) sheet, are hidden simultaneously.

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations