Workbooks or Worksheets can be protected to prevent the manipulation of data either intentionally or accidentally. Passwords can be put in place to ensure only those employees who have the password can access the workbook or worksheet.
The following will article will detail how to unprotect a workbook that is not password protected, unprotect a workbook that is password protected, and how to save the information in a password protected workbook when the password is forgotten or lost.
understand a Protected worksheet limits
But first understand a Protected worksheet limits the users’ ability to edit within a single worksheet and a Protected workbook prevents users from making structural changes like moving, deleting or adding sheets to the workbook.
Neither of these protections will prevent someone from opening the Excel workbook they only limit the freedom within the workbook or worksheet. That being said, protecting a workbook or worksheet should be used when you want to prevent the tampering of your data or structure of your workbook.
But should not be used as a security measure to protect sensitive data.
How to Unprotect A Workbook And Worksheet In Excel Unprotect a Worksheet or Workbook:
A protected worksheet limits the ability to edit.
Go to the REVIEW Tab in the Ribbon and select Unprotect Sheet or Unprotect Workbook. You will now be free to make changes within the worksheet and just remember to protect it again once all work has been completed.
Unprotect a password protected Worksheet or Workbook:
If the worksheet or workbook is password protected when you click on Unprotect Sheet or Unprotect Workbook a dialog box will open asking you to enter the password. Once the password has been entered the worksheet or workbook will be unprotected you will once again be able to make changes or edit.
How to Unprotect A Workbook And Worksheet In Excel Save the data from a password protected Worksheet or Workbook:
If you have forgotten the password to a workbook or worksheet there is an easy way to retrieve your information and once again be able to edit or make changes.
- Select all the data within the first worksheet by clicking the select all button in the top left corner (highlighted).
- Control + C to copy or Right-Click and select Copy
- Open a new Excel Workbook (Control + N)
- Click anywhere within the new Workbook and Control +V to paste or Right-Click and select Paste Special (to ensure any custom formatting is withheld).
- Continue this process with each Worksheet within the Workbook
- This method will only work if when protecting the worksheet, the boxes remained checked to allow users to select locked cells and select unlocked cells.
Other ways to unprotect worksheets and workbooks:
How to Unprotect A Workbook And Worksheet In Excel, Above are the easiest ways to unprotect worksheets and workbooks but there are several other ways to get unprotect them.
You can right click on the Worksheet Tab and select Unprotect Sheet.
From the HOME Tab in the Ribbon select, Click Format and Select Unprotect Sheet.
Click the FILE Tab in the Ribbon or from the Home Screen you can also click Unprotect to Unprotect the Workbook or the Worksheet.