Hiding and showing sheets in Google Sheets is also very simple, similar to when we hide sheets in Excel. We can hide multiple sheets at the same time or hide sheets according to our needs. Google Sheets sheets, after being completely hidden, can be re-displayed with simple operations. The article below will guide you to hide and show sheets on Google Sheets.
Instructions for hiding sheets on Google Sheets
Step 1:
At the interface on Google Sheets, we will find the sheet we want to hide. Friend Right-click on the worksheet then select Hide sheet as shown below.
Step 2:
Immediately that sheet will be hidden on Google Sheets. You do the same with the remaining worksheets if you want to hide them.
How to hide multiple sheets on Google Sheets
Google Sheets supports you to select multiple sheets to hide multiple sheets at the same time, instead of having to manually hide each sheet.
Step 1:
To Select multiple sheets you want to hide Depending on your needs, you will have 3 different ways:
- For non-adjacent sheets on Windows, hold Ctrl and then click on the sheet you want to hide.
- For non-adjacent sheets on Mac, hold down Command as you select each sheet.
- For adjacent sheets, click to select the first sheet, hold down the Shift key and click on the last sheet to select the entire sheet.
Step 2:
Then you also press Right-click and select Hide Sheet okay. As a result, all the worksheets you selected will be hidden in Google Sheets.
Instructions for displaying sheets in Google Sheets
Whether you hide 1 sheet or many sheets in Google Sheets, there is only 1 way to show the sheet in Google Sheets.
Step 1:
We click View item then select Hidden sheet in the displayed list.
Step 2:
Now users will see all the Google Sheets sheets that you have hidden. To display the sheet again, you must click on each sheet, but you cannot display multiple sheets at the same time.
