Microsoft Office Tutorials and References
In Depth Information
In the Protect Sheet dialog box, you select the Protect Worksheet And Contents Of Locked
Cells check box to protect the sheet. You can also set a password that a user must type in
before protection can be turned off again and choose which elements of the worksheet a
user can change while protection is turned on. To enable a user to change a worksheet
element without entering the password, select the check box next to that element’s name.
The check box at the top of the worksheet mentions locked cells. A locked cell is a cell that
can’t be changed when worksheet protection is turned on. You can lock or unlock a cell by
right-clicking the cell and clicking Format Cells on the shortcut menu that appears. In the
Format Cells dialog box, you click the Protection tab and select the Locked check box.
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 casual users to see the name of the workbook in a formula.
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 with 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.