Hide an Excel worksheet
How to hide a single Excel worksheet using Excel, VBA and Shortcut methods
Right-click on a worksheet > Hide
| 1. Right-click on a worksheet that you want to hide. 2. Click Hide. Note: in this example we are hiding Sheet2. |
 |
METHOD 2. Hide an Excel worksheet using the ribbon option
EXCEL
Select a worksheet > Home tab > Cells group > Format > Hide & Unhide > Hide Sheet
| 1. Select the worksheet that you want to hide. Note: in this example we will be hiding Sheet2. |
 |
| 2. Select the Home tab. |  |
| 3. Click Format in the Cells group. 4. Click Hide & Unhide and then click on Hide Sheet. |
 |
Sub Hide_a_Worksheet()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("Sheet2")
'hide a worksheet named Sheet2
ws.Visible = False
ws.Visible = False
End Sub
OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Worksheet Name: Have a worksheet named Sheet2.
Worksheet Name: Have a worksheet named Sheet2.
ADJUSTABLE PARAMETERS
Hide Worksheet: Select the worksheet that is to be hidden by changing the Sheet2 worksheet name to any worksheet in the workbook.
METHOD 2. Hide an Excel worksheet using VBA
VBA
Sub Hide_Worksheet()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("Sheet2")
'hide a worksheet named Sheet2
ws.Visible = xlSheetHidden
ws.Visible = xlSheetHidden
End Sub
OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Worksheet Name: Have a worksheet named Sheet2.
Worksheet Name: Have a worksheet named Sheet2.
ADJUSTABLE PARAMETERS
Hide Worksheet: Select the worksheet that is to be hidden by changing the Sheet2 worksheet name to any worksheet in the workbook.
WINDOWS SHORTCUT
Alt
H
>
O
>
U
>
S
NOTES
Select the worksheet you want to hide and then action the shortcut. This shortcut hides an active worksheet.
EXPLANATION
This tutorial explains and provides step by step instructions on how to hide a single worksheet using Excel, VBA and Shortcut methods.
This tutorial explains and provides step by step instructions on how to hide a single worksheet using Excel, VBA and Shortcut methods.
Excel Methods: Using Excel you can hide a worksheet with a ribbon or sheet option.
VBA Methods: Using VBA you can hide a worksheet by referencing to a worksheet that you want to hide.
Shortcut Method: Using a Shortcut you can hide an active worksheet.