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

446 Protecting the Spreadsheet
Figure 1-5:
Assigning the range title, address, and password in the New Range dialog box.
Note that the Allow Users to Edit Ranges command button is grayed out and unavailable if the worksheet is currently protected. In that case, you must remove protection by clicking the Unprotect Sheet command button on the Review tab before you retry Step 1.
Excel opens the Allow Users to Edit Ranges dialog box, where you can add the ranges you want to assign, as shown in Figure 1-4.
Figure 1-4:
Designating the range to be unlocked bya password in a protected worksheet.
2. Click the New button.
Doing this opens the New Range dialog box where you give the range a title, define its cell selection, and provide the range password, as shown in Figure 1-5.
3. If you wish, type a name for the range in the Title text box; otherwise, Excel assigns a name such as Range1, Range2, and so on.
Next, you designate the cell range or nonadjacent cell selection to which access is restricted.