How to Unprotect a Worksheet with Password

When working with Excel, you may need to unprotect your worksheet to edit a worksheet. If you have the password please follow steps below:

Step 1: Click anywhere in the worksheet you want to unprotect;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Format" in the Cells section, and select "Unprotect Sheet" from the list;

Step 3: In the "Unprotect Sheet" window, type in the password and click "OK" at the bottom;

Alternatively, right-click on the worksheet name, select "Unprotect Sheet" from the list.

You can also bring up "Unprotect Sheet" window by clicking the Review Tab in the Ribbon.

Step 1: Click the Review Tab from the ribbon;

Step 2: Click Unprotect Sheet in the Protect section.

Leave a Reply