To apply different passwords to two ranges in a worksheet, follow these steps:
Start Excel, and then open a blank worksheet.
On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
Note If you are running Microsoft Office Excel 2007, click Allow Users to Edit Ranges on the Review menu in the Changes group.
In the Allow Users to Edit Ranges dialog box, click New.
In the New Range dialog box, click the Collapse Dialog button. Select the range B2:B6, and then click the Collapse Dialog button again.
In the Range password box, type rangeone, then type it again in the Confirm Password dialog box, and then click OK.
Repeat steps 3 through 5, selecting the range D2:D6 and typing rangetwo as the password for that range.
In the Allow Users to Edit Ranges dialog box, click Protect sheet. In the Password to unprotect sheet box, type ranger, and then click OK two times. When prompted, retype the password.
Select cell B3, and then start to type Dataone.
Notice that as soon as you type D, the Unlock Range dialog box appears.
Type rangeone in the Enter the password to change this cell box, and then press ENTER.
You can now enter data in cell B3 as well as any other cell in the range B2:B6, but you cannot enter data in any of the cells D2:D6 without first providing the correct password for that range.
The range that you protect with a password does not have to consist of adjacent cells. If you want the ranges B2:B6 and D2:D6 to share a password, you can select B2:B6 as described in step 4 earlier in this article, type a comma in the New Range dialog box, and then select the range D2:D6 before you assign the password.