Showing or Hiding a Sheet

Home > Cells > Format > Hide & Show

 

 

If you have more than one sheet in the DataBook, you can hide a sheet so that it is not displayed to the user. Even though it is not displayed, it is not removed from the DataBook.

Hiding a sheet does not change the default sheet names provided to the other sheets. For example, a DataBook with three sheets would by default name them Sheet1, Sheet2, and Sheet3. If you hide the second sheet, the names for the remaining sheets are Sheet1 and Sheet3.

Hiding a sheet does not remove it and does not affect formulas on that sheet or references to that sheet. For more information on removing the sheet completely, refer to Removing a Sheet.