How do you unlock an excel spreadsheet

Excel offers a very interesting way to unlock an excel spreadsheet. We can cater to this problem statement by unprotecting the sheet. We can perform the below mentioned way to unlock a sheet in excel:

We’ll learn about this methodology step by step.

How do you unlock an excel spreadsheet:

Step-1: Excel workbook with a protected sheet

To do this yourself, please follow the steps described below;

– Open the desired Excel workbook with a sheet which is protected

Step-2: Exploring the Review option in the menu bar

– Now go to the Review option in the menu bar, and then click on the “Unprotect sheet” option.

Step-3 : Unprotect sheet dialogue box

– A dialogue box would appear, enter the password to unprotect the sheet and then click “OK”.

Final Image : Sheet has been unlocked

– The sheet is now unlocked. We can verify this by seeing that now instead of “Unprotect Sheet”, we have the “Protect Sheet” option available in the Review option in the menu bar, as shown in the image above.