Hiding and Protecting Workbooks

Sometimes you might want to keep certain information out of sight or protect it from inadvertent modification. You can conceal and protect your data by hiding windows, workbooks, or individual worksheets from view.


For information about protecting individual cells, see Protecting Worksheets on page 170.

Hiding Workbooks

image with no caption

At times you might need to keep a workbook open so you can access the information it contains, but you don’t want it to be visible, either for convenience or for security. When several open workbooks clutter your workspace, you can click the Hide button on the View tab to conceal some of them. Excel ...

Get Microsoft® Excel® 2010 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.