1. Switch to the protected worksheet.
2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
3. If prompted type the current password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.
4. On the Tools menu, point to Protection, and then click Protect Sheet.
5. In the Allow all users of this worksheet to list, make any changes you want to the elements users will be able to change.
6. Type the password in the Password to unprotect sheet box.
7. Click OK, and if prompted retype the password.

Note  It is very important that you remember the password that you set. Without the password, there is no way to unprotect the workbook or worksheet.

Important  Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

1. Switch to the protected worksheet.
2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
3. If prompted, type the worksheet password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.
4. On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
5. In the Ranges unlocked by a password when sheet is protected list, click the range for which you want to change the password.
6. Click Modify, and then click Password.
7. Type the new password for the range in the New password box.
8. Type the same password in the Confirm new password box, and then click OK twice.
9. Click Protect Sheet.
10. Type the worksheet password in the Password to unprotect sheet box.
11. Click OK, and then retype the worksheet password to confirm it.

Important  Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

1. Open the workbook and switch to the protected worksheet.
2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
3. If prompted type the worksheet password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.
4. On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
5. Do one or more of the following:

   Change which users are allowed to edit a range

   1. In the Ranges unlocked by a password when sheet is protected box, click the range for which you want to change the users.
   2. Click Modify, and then click Permissions.
   3. Do one or more of the following:
      • To block a user temporarily from editing the range, click the user in the Name list, and then select the Deny check box for the user.
      • To unblock a user, click the user in the Name list, and then select the Allow check box for the user.
      • To remove a user permanently, click the user in the Name list, and then click Remove.
      • To add a new user, click Add, locate and select the new user, click Add, and then click OK.
   4. Click OK, click Yes if prompted about denying users, and then click OK again.

   Change which cells are included in a range

   1. In the Ranges unlocked by a password when sheet is protected box, click the range for which you want to change the included cells.
   2. Click Modify.
   3. In the Refers to cells box, type or select the new range, and then click OK.

   Remove protection for a range

   1. In the Ranges unlocked by a password when sheet is protected box, click the range you want to delete.
   2. Click Delete.
6. When you are finished making changes in the Allow Users to Edit Ranges dialog box, click OK.
7. On the Tools menu, point to Protection, and then click Protect Sheet.
8. Type the worksheet password in the Password to unprotect sheet box.
9. Click OK, and then retype the worksheet password to confirm it.

1. Open the protected workbook.
2. On the Tools menu, point to Protection, and then click Unprotect Workbook.
3. If prompted type the current password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.
4. On the Tools menu, point to Protection, and then click Protect Workbook.
5. If you want to change the protection, select the Structure or Windows check box, or both check boxes.
6. Do one of the following:
   • To keep the same password, type it in the Password box.
   • To change the password, type a new password instead.
7. Click OK. If prompted, retype the password to confirm it.

Note  It is very important that you remember the password that you set. Without the password, there is no way to unprotect the workbook or worksheet.

Important  Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

1. Switch to the protected worksheet.
2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
3. If prompted, enter the protection password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) for the worksheet.

1. Switch to the protected worksheet.
2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
3. If prompted, enter the protection password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) for the worksheet.
4. On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
5. In the Ranges unlocked by a password when cell is protected list, click the range for which you want to remove permissions.
6. Click Delete.

1. Open the protected workbook.
2. On the Tools menu, point to Protection, and then click Unprotect Workbook.
3. If prompted, enter the protection password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) for the workbook.

Removing protection when a password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) is in use also unshares the workbook, disconnecting other users from the workbook and erasing the change history (change history: In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed.). If no password is in effect, the workbook remains shared (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) after you unprotect it.

1. Open the protected workbook
2. On the Tools menu, point to Protection, and then click Unprotect Shared Workbook.
3. If prompted, enter the password for the workbook.
4. If prompted about the effects on other users of removing protection, click Yes.