How to Unprotect Excel Sheets and Workbooks | 3 Ways to Unprotect Excel File with Password

In this video, we will show you how to unprotect excel spreadsheets and workbooks easily.

This tutorial is for basic users getting started with excel and want to understand how to unlock protected sheets or workbooks in excel.

Over here, we have an excel file opened up, and as you can see that we can’t change anything in the spreadsheet. Excel gives us a prompt that the sheet is protected. Similarly, we are also unable to add a new worksheet. This means both the spreadsheet and the entire workbook is protected.

To unprotect a worksheet, you can right click on the sheet tab at the bottom over here and select the Unprotect Sheet option. You can also open up the Format dropdown menu in the Cells section under the home tab, and from here, you can unprotect the sheet as well. Lastly, you can also move to the review tab, and from here, you can click on the Unprotect Sheet option.

If the sheet is password protected, you would be required to enter the password to unprotect the sheet. Now you can see that the spreadsheet is unprotected and changes can be made on the spreadsheet.

To unlock the workbook, simply click on the Protect Workbook option. If the workbook is password protected, you would be required to enter the password to unlock the workbook.

Once done, you can see here that now we can freely add more sheets in the workbook.

It’s important to remember and store the password if the excel spreadsheet or workbook is password protected.

That’s all.

❓💬 What would you like to know about Excel functions? Let us know in the comments below.

#HowTech #Excel
--------------------------------------------------------------------------------------------------------------

[llalbwansingh]

I have problem with Excel Workbook Password Removal or Recovery to Open. Not excel Sheet password...! Can you help ...?

[MissPurplePotato]

I need to know how to remove the password protection for my entire Workbook containing 5 tabbed sheets. This video explained how to unprotected sheets but not the entire workbook. Frustrated.

[ceryp]

I have the same problem, to prevent to forget my password on excel workbook, no more game. But there are no any way to let me to remove my password. Please help, thank you

[peoples.say.masoom]

The last and even the only option which can save your data is just go and create a new excel file than copy the whole data to the new file and that's it you're good to go. Just pray for me If you got the Solution

[GreystonePortables]

I remembered the password, I wouldn't be here.