#Excel forgot password for protection code#
#Excel forgot password for protection windows#

You will be asked to re-enter the password, if you entered one initially. Fill in a password, if desired and click the OK button.

#Excel forgot password for protection windows#

The workbooks in those versions use the Single Document Interface to allow the windows to be adjusted so you cannot lock that part. If you are working in Excel 2013 or 2016, then your Windows box will be ghosted (or unavailable). On the Review tab, click the Protect Workbook button. To keep users from deleting, moving, or renaming worksheets or from seeing hidden worksheets, you can protect the workbook. See Figure 5.Д®nter your password in the Unprotect Sheet dialog box that appears. Choose вЂњUnprotect SheetвЂќ from the right-click menu that appears. Right-click the sheet tab of the sheet you want to unprotect. If you need to be able to access all the features of your sheet again, you can turn off the protection of your sheet using the password your set up in the previous section. Click OK when you have finished making your choices.Д®xcel will ask you to re-enter your password if you chose to enter one. You can choose to leave the password field blank if you do not need that level of security but just want to prevent accidental tampering. Next, enter a password to use when you need to unprotect the sheet. (Note: if you leave вЂњSelect locked cellsвЂќ and вЂњSelect unlocked cellsвЂќ checked, then someone can copy the contents to another worksheet and potentially have access to what you have locked.) In the Protect Sheet dialog box that opens, choose what you would like the users of the worksheet to be able to do. To turn on this protection, go to the Review tab and click the Protect Sheet button. In order to turn on this protection, you set a password, so that users have to enter a password to turn off the sheet protection.

The next level of protection available is to assign which tasks users can perform on the worksheet. Click on the Protection tab and uncheck the вЂњLockedвЂќ checkbox. Right-click any of the selected cells and choose вЂњFormat CellsвЂќ from the menu. You can use hold down the CTRL key on your keyboard while you click to select cells or ranges that are not next to each other. Select the cells where you want to allow others to be able to add, edit, and delete data. Unlock Your CellsД«efore you set up passwords to protect the file or workbook structure, you first want to figure out which cells you want to allow users to edit.

Should you even spend the time to set up protection? Yes! Any deterrent to someone who opens the wrong book or to prevent accidental damage is worth the short time it takes to set up any of ExcelвЂ™s safeguards.

#Excel forgot password for protection code#

There are add-ins and even VBA code that will help recover your password, if you lose it, open the file bypassing the password, or remove the password completely.

Using a password can be a deterrent for most people who arenвЂ™t looking to steal your data but simply shouldnвЂ™t have access to the file or who might accidentally move or delete your contents, if they are new to your company or to Excel.Д®xcel 20 are better in regards to keeping your worksheet data safe, but if someone really wants to get the file open, even with password protection, they can do it. However, the encryption for an Excel spreadsheet is very easy to work around, especially in versions prior to Excel 2010. Setting up a password to be able to use or modify an Excel file is a good idea. You can lock your data in the worksheet structure or in a workbook, or even set a password. If you donвЂ™t want someone to delete your formulas or information, there are a few ways to protect your work. Whether you share your Excel file internally or externally, you may want to prevent someone from accidentally changing or overwriting your data.