Microsoft Office Tutorials and References
In Depth Information
Protecting workbooks and worksheets
When worksheet protection is turned on, selecting the Locked check box prevents
unauthorized users from changing the contents or formatting of the locked cell, whereas selecting the
Hidden check box hides the formulas in the cell. You might want to hide the formula in a cell
if you draw sensitive data, such as customer contact information, from another workbook
and don’t want the name of the workbook in a formula to be viewed by casual users.
Finally, you can password-protect a cell range. For example, you might want to let users
enter values in most worksheet cells but also want to protect the cells by using formulas
that perform calculations based on those values. To password-protect a range of cells,
select the cells to protect, click the Review tab and then, in the Changes group, click
Allow Users To Edit Ranges. The Allow Users To Edit Ranges dialog box opens.
To create a protected range, click the New button to display the New Range dialog box.
Enter a name for the range in the Title box, and then enter a password in the Range
Password box. When you click OK, Excel asks you to confirm the password; after you do,
click OK in the Confirm Password dialog box and again in the Allow Users To Edit Ranges
dialog box to protect the range. Now, whenever users try to edit a cell in the protected
range, they are prompted for a password.
TIP Remember that a range of cells can mean just one cell.