Hide multiple Excel worksheets

How to hide multiple Excel worksheets at the same time using Excel, VBA and Shortcut methods

METHOD 1. Hide multiple Excel worksheets using the sheet option

EXCEL

Select multiple worksheets > Right-click on one of the selected worksheets > Hide

1. Press and hold the Shift key and select the worksheets that you want to hide.
Note: in this example we are hiding three worksheets (Sheet1, Sheet2 and Sheet3).		 Select multiple sheets - Excel

2. Right-click on any of the selected worksheets.
3. Click Hide.		 Right-click on one of the selected worksheets and select Hide - Excel

METHOD 2. Hide multiple Excel worksheets using the ribbon option

EXCEL

Select multiple worksheets > Home tab > Cells group >  Format > Hide & Unhide > Hide Sheet

1. Press and hold the Shift key and select the worksheets that you want to hide.
Note: in this example we are hiding three worksheets (Sheet1, Sheet2 and Sheet3).		 Select multiple sheets - Excel

2. Select the Home tab. Select Home tab - Excel

3. Click Format in the Cells group.
4. Click Hide & Unhide and then click on Hide Sheet.		 Select Format, select Hide and Unhide and select Hide Sheet - Excel

METHOD 1. Hide multiple Excel worksheets using VBA

VBA

Sub Hide_Multiple_Excel_Worksheets()
'declare variables
Dim ws1 As Worksheet
Dim ws2 As Worksheet
Dim ws3 As Worksheet
Set ws1 = Worksheets("Sheet1")
Set ws2 = Worksheets("Sheet2")
Set ws3 = Worksheets("Sheet3")
'hide three worksheets at the same time
ws1.Visible = False
ws2.Visible = False
ws3.Visible = False

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Minimum Number of Worksheets: Have at least three worksheets in a workbook
Worksheet Names: Have three worksheets named Sheet1, Sheet2 and Sheet3.

ADJUSTABLE PARAMETERS
Worksheets to Hide: Select worksheets that you want to hide by changing Sheet1, Sheet2 and Sheet3 worksheet names in the VBA code to any worksheets in the workbook.

METHOD 2. Hide multiple Excel worksheets from a list using VBA

VBA

Sub Hide_Multiple_Excel_Worksheets()
Set ws1 = Worksheets("Parameters").Range("D2")
Set ws2 = Worksheets("Parameters").Range("D3")
Set ws3 = Worksheets("Parameters").Range("D4")
'hide three worksheets at the same time
Worksheets(ws1.Value).Visible = False
Worksheets(ws2.Value).Visible = False
Worksheets(ws3.Value).Visible = False

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
PREREQUISITES
Minimum Number of Worksheets: Have at least four worksheets in the workbook, including the Parameters worksheet.
Worksheet Names: Have four worksheets named Parameters, Sheet1, Sheet2 and Sheet3.
Worksheets Selection: Cells ("D2"), ("D3") and ("D4") in the Parameters worksheet need to be populated with the names of the worksheets that you want to hide.

ADJUSTABLE PARAMETERS
Worksheets to Hide: Select the worksheets that you want to hide by changing the worksheet names in cells ("D2"), ("D3") and ("D4") in the Parameters worksheet.

METHOD 3. Hide multiple Excel worksheets from a list of names with a For Loop using VBA

VBA

Sub Hide_Multiple_Excel_Worksheets()
On Error Resume Next
For Each hidews In ThisWorkbook.Worksheets("Parameters").Range("D2:D4")
ThisWorkbook.Worksheets(hidews.Value).Visible = False
Next

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Range: The Range object is a representation of a single cell or a range of cells in a worksheet.
PREREQUISITES
Minimum Number of Worksheets: Have at least four worksheets in the workbook, including the Parameters worksheet.
Worksheet Names: Have four worksheets named Parameters, Sheet1, Sheet2 and Sheet3.
Worksheets Selection: Cells ("D2"), ("D3") and ("D4") in the Parameters worksheet need to be populated with the names of the worksheets that you want to hide.

ADJUSTABLE PARAMETERS
Worksheets to Hide: Select the worksheets that you want to hide by changing the worksheet names in cells ("D2"), ("D3") and ("D4") in the Parameters worksheet.

METHOD 4. Hide multiple Excel worksheets from a list of names with a For Loop using VBA

VBA

Sub Hide_Multiple_Excel_Worksheets()
'declare a variable
Dim ws As Worksheet
Set ws = Worksheets("Parameters")
For x = 2 To 4
On Error Resume Next
hidews = ws.Cells(x, 4).Value
Worksheets(hidews).Visible = False
Next

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Minimum Number of Worksheets: Have at least four worksheets in the workbook, including the Parameters worksheet.
Worksheet Names: Have four worksheets named Parameters, Sheet1, Sheet2 and Sheet3.
Worksheets Selection: Cells ("D2"), ("D3") and ("D4") in the Parameters worksheet need to be populated with the names of the worksheets that you want to hide.

ADJUSTABLE PARAMETERS
Worksheets to Hide: Select the worksheets that you want to hide by changing the worksheet names in cells ("D2"), ("D3") and ("D4") in the Parameters worksheet.

Hide multiple worksheets using a Shortcut

SHORTCUT

WINDOWS SHORTCUT

Alt
H
>
O
>
U
>
S

NOTES
Select the worksheets that you want to hide and then action the shortcut. The shortcut will hide all of the selected worksheets.

Explanation about how to hide multiple worksheets

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to hide multiple worksheets using Excel, VBA and Shortcut methods.

Excel Methods: Using Excel you can hide multiple worksheet with a ribbon or sheet option.

VBA Methods: Using VBA you can hide multiple worksheets by directly entering into the VBA code the names of the worksheets that you want to hide or by referencing to cells that capture the names of the worksheets that you want to hide.

Shortcut Method: Using a Shortcut you can hide multiple selected worksheets.