– How to Hide a Worksheet
– How to Unhide a Worksheet
When you do not want to show the worksheet, you can follow the steps below to hide multiple worksheets:
Step 1: Click the worksheets' names by holding "Ctrl" key if the worksheets are not adjacent, or holding "Shift" key if the worksheets are adjacent;
Step 2: Right-click on the worksheets' names and select "Hide" from the dialog box.
Alternatively, please use commands in the ribbon.
Step 1: Click the worksheets' names by holding "Ctrl" key if the worksheets are not adjacent, or holding "Shift" key if the worksheets are adjacent;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Format" in Cells section, and select "Hide Sheet" from the "Hide & Unhide" command;
Step 4: The worksheet will hide.
