Step 2: Close the file and make a copy just in case you make a mistake! To find out the sheet number, right-click a sheet tab > View Code: Note: if you rearranged the sheets in your file after inserting them, the numbers will not be in sheet tab order. The second sheet called ‘Sales Data’ is the one protected. Notice there are three sheets in the file.

Step 1: The first thing you’ll want to note is which sheet in the file contains the password protection. If you enter a password here and later forget it, it’s easy to unlock the protected sheet. Remove Excel Worksheet Password ProtectionĮxcel worksheet protection is applied via the Review tab > Protect Sheet:

Unprotect Read Only Workbooks Without Password.

Unprotect Workbook Structure Without Password.

Remove Excel Worksheet Password Protection.

This post is written on the basis that you’re being ethical and only unlocking your own files where you’ve forgotten the password and not trying to hack into confidential files.

If you’re relying on it for this purpose, you might want to reconsider your approach. However, the likelihood of your success depends on which password protection method was used, as some of the four options below are more robust than others.Įxcel password protection is available for:Įach method requires a slightly different solution to remove the password.īefore we get started, keep in mind that password protection for worksheets and workbooks was designed to prevent users breaking your files, as opposed to keeping your data confidential. In most cases you can easily remove Excel password protection if you’ve forgotten the password.

Excel for Decision Making Under Uncertainty Course.

Excel for Customer Service Professionals.

Excel sheet not opening in windows 10