Excel has three levels of worksheet visibility: visible, hidden, and very hidden. While many people know about hiding and unhiding worksheets by right-clicking the tab area at the bottom of the workbook, this is only an intermediate way to remove Excel sheets from view.

Whether you want to tidy up your workbook tabs, have a dedicated sheet for drop-down list option and other controls, leave only the most important sheets visible, or conceal information you don’t want others to see, you can make worksheets very hidden in Excel. Taking this step reduces the chances of other people making those worksheets visible again.

[mai mult...]