The sheet itself however, is not gone, and formulas can still retrieve values stored on a hidden sheet. When a worksheet has a visible property of false, it is hidden, and can no longer be seen from within the standard Excel user interface. When a worksheet has a visible property value of true, it is visible and can be seen and selected by the user. In Excel however, the visible property of a worksheet object has three possible values: true, false, or….very hidden. In the real world, the visible status of an object is either true or false, it is either visible or it is not.

However, when he throws on that sweet cloak of invisibility, he is not visible. For example, Harry Potter is typically visible. In the real world, an object is either visible or it is not. A visible worksheet’s tab appears in the bottom of the Excel window, enabling the user to click the tab in order to navigate to the worksheet.

This post walks through the differences, and how to hide worksheets at each level.īy default, all new worksheets are visible. Did you know that Excel has two levels of hidden worksheets? Excel has “hidden” worksheets, and, “very hidden” worksheets.