Page 465 - Excel 2013 All-in-One For Dummies

Protecting the Spreadsheet 447
4. Click the Refers to Cells text box and then type in the address of the cell range (without removing the = sign) or select the range or ranges in the worksheet.
Next, you need to enter a password that’s required to get access to the range. Like all other passwords in Excel, this one can be up to 255 char- acters long, mixing letters, numbers, and spaces. Pay attention to the use of upper- and lowercase letters because the range password is case- sensitive.
5. Type in the password for accessing the range in the Range Password dialog box.
You need to use the Permissions button in the New Range dialog box to open the Permissions dialog box for the range you’re setting.
6. Click the Permissions button in the Range Password dialog box. Next, you need to add the users who are to have access to this range.
7. Click the Add button in the Permissions dialog box.
Doing this opens the Select Users or Groups dialog box, where you des-
ignate the names of the users to have access to the range.
8. Click the name of the user in the Enter the Object Names to Select list box at the bottom of the Select Users or Groups dialog box. To select multiple users from this list, hold down the Ctrl key as you click each username.
If this list box is empty, click the Advanced button to expand the Select Users or Groups dialog box and then click the Find Now button to locate all users for your location. You can then click the name or Ctrl+click the names you want to add from this list, and then when you click OK, Excel returns you to the original form of the Select Users or Groups dialog box and adds these names to its Enter the Object Names to Select list box.
9. Click OK in the Select Users or Groups dialog box.
Doing this returns you to the Permissions dialog box where the names you’ve selected are now listed in the Group or User Names list box. Now you need to set the permissions for each user. When you first add users, each one is permitted to edit the range without a password. To restrict the editing to only those who have the range password, you need to click each name and then select the Deny check box.
10. Click the name of the first user who must know the password and then select the Deny check box in the Permissions For list box.
You need to repeat this step for each person in the Group or User Names list box that you want to restrict in this manner. (See Figure 1-6.)
Book IV Chapter 1
Protecting Workbooks and Worksheet Data