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

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.

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.

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.

Related articles