Protecting Worksheets from Changes
When you create a worksheet that contains sensitive data or data you don’t want changed by anyone other than yourself, you can protect the worksheet from unauthorized changes. From within the Protect Sheet dialog box, you can choose the actions you want to allow all users to be able to perform on the worksheet. The options selected by default will allow anyone to select a cell but will prevent them from deleting rows or columns, changing any formatting, or editing scenarios attached to the worksheet.
Protect a Worksheet
Click the Review tab.Click Protect Sheet.
Select the protection options you want.
Click OK. ...
Get Microsoft® Office Excel® 2007 Plain & Simple 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.
