Microsoft Office Tutorials and References
In Depth Information
To create a protected range, click the New button to display the New Range dialog
box. Type a name for the range in the Title box, and then type 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!
In this exercise, you’ll password-protect a workbook, a worksheet, and a range of cells.
You will also hide the formula in a cell.
SET UP You need the SecureInfo_start workbook located in your Chapter14 practice
file folder to complete this exercise. Open the SecureInfo_start workbook, and save it
as SecureInfo . Then follow the steps.
1. Click the File tab, and then, if necessary, click Info .
The Info page of the Backstage view is displayed.
2. Click the Protect Workbook button, and then click Encrypt with Password .
The Encrypt Document dialog box opens.