Hide Sheet

To temporarily hide a sheet, follow these steps:

  1. Click on the sheet menu and select "Hide".

  2. The sheet will be hidden from the list on the sheet tabs.

Once hidden, the sheet can be made visible again from the menu on the right side of the sheet tab.

Alternatively, you can also select hidden sheets and set them to be visible from Book Settings > Sheets tab.

Even hidden sheets can be used to refer to values in the sheet as reference values for filters or as calculation targets for formulas. Therefore, intermediate sheets for data retrieval can be hidden from the user to prevent unnecessary access to the original data.

Last updated