• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Using Excel in a Workgroup > Protecting a Worksheet

Protecting a Worksheet

If you store Excel workbooks only on your own PC, you can control exactly how and when you change the data and structure of each worksheet. In a typical workgroup environment, however, you'll often save a workbook to a shared folder on your company's network. How do you maintain the confidentiality of sensitive data? And how do you allow coworkers to view the contents of a workbook without changing crucial data or formulas, either deliberately or by accident?

If you must store sensitive workbook files in shared network folders that are accessible to everyone, lock them up with passwords. Excel lets you create two levels of access to limit unauthorized users from opening or modifying a workbook. For finer control over the contents of a workbook, you can lock down individual cells, hide formulas, and prevent changes to your workbook.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint