![]() ![]() ![]() Though, unlocking an Excel spreadsheet without password is no big deal either :) How to unprotect Excel sheet with password Unprotecting a spreadsheet is even easier, provided that you know the password. Done!Īs you have just seen, it's very easy to password protect a sheet in Excel. The Confirm Password dialog box will pop-up prompting you to retype the password so that an accidental misprint won't lock your Excel sheet forever.If you don't check any action, users will only be able to view the contents of your Excel sheet.To allow some other actions such as sorting, filtering, formatting cells, deleting or inserting rows and columns, check the corresponding boxes. ![]() If you leave only these two options selected, the users of your sheet, including yourself, will be able only to select cells (both locked and unlocked). By default, the following 2 options are selected: Select locked cells and Select unlocked cells.Select the actions you allow the users to perform.In this case, unprotecting the sheet takes just a single click on the Unprotect Sheet button on the ribbon or in the sheet tab's right-click menu. If the worksheet protection is nothing more than a precaution against accidental modification of the sheet contents by yourself or by the members of your local team, you may not want to bother about memorizing the password and leave the password field empty.Be sure to remember the password or store it in a safe location because you will need it later to unprotect the sheet. To password protect your Excel sheet, type a password in the corresponding field.In the Protect Sheet dialog window, do the following:.Or, click the Protect Sheet button on the Review tab, in the Changes group. Right click a worksheet tab at the bottom of your screen and select Protect Sheet… from the context menu.To protect a sheet in Excel, perform the following steps. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |