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".

Hiding Workbooks

At times, you might need to keep a workbook open so you can access the information it contains but not want it to be visible. When several open workbooks clutter your workspace, you can click the Hide button on the View tab to conceal some of them. Office Excel 2007 can still work with the information in the hidden workbooks, but they don’t take up space on your screen, and their file names don’t appear in ...

Get 2007 Microsoft® Office System Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.