We usually protect Excel sheets for security. When we protect a sheet, some features become disabled like editing, formatting, inserting, etc. If we want to enable any of those features, we need to unlock the Excel Sheet. In this article, we will discuss how to unlock Excel sheet for editing them.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article. This worksheet is password protected and the password is 12345.
Steps to Unlock a Password-Protected Excel Sheet for Editing
In this section, we will show the way to unlock a protected Excel Sheet for editing. When a worksheet is in protected mode, we will see the Unprotect Sheet button appear in the Review tab.
And also, if we want to edit or insert anything in a protected sheet the warming window will appear.
Here, we will show how to unlock a password-protected Excel sheet. For a password-protected sheet, we must know the password to unlock it. Follow the steps below.
- Go to the Review tab.
- Then click on the Unprotect Sheet option from the Protect group.
- Now, a window will appear to input the password. We write the password on the box and then press OK.
- We can also avail of this option from the Sheet Name.
- Press the right button of the mouse and get the Unprotect Sheet option from the Context Menu.
The keyboard shortcut for unprotecting sheet is: Alt+H+O+P
There is one more option for unlocking. Choose the Format option from the Cells group of the Home tab.
More Ways to Enable Excel Sheet for Editing
Sometimes, it happens that the Excel sheet is not locked, but still, you cannot edit anything in it. In the following section, we will discuss the probable solution along with the reasons for causing such problems.
Sometimes it happens that we share an Excel file with other people. Now, if any of them opens the shared file, the other users will see a warning that the file is locked for editing by other users. The other users can open the Excel file in the Read-Only mode, they cannot edit that Excel sheet.
In such a situation, other users can make a copy of that file and edit the sheets, or they have to wait until the present user closes the Excel file.
2. Close Microsoft Excel App Running in Background
Sometimes we find ourselves unable to edit sheets when the Excel sheet is not in shared mode or no user is currently using that file. One reason for that may be the Microsoft Office or Excel application is running in the background. In such a case, we need to close the Office or Excel file from the task manager. After that, we will be able to edit our desired worksheet.
3. Ignore ‘Marked As Final’ Tag and Edit Anyway
If the author discourages editing a workbook using the Mark As Final feature, you can still edit the file. Just open the Excel file and click on the Edit Anyway button. Now you can edit your Excel file as you need…
4. Copy Data from a Protected Sheet to Another for Editing
If a worksheet is protected, you can still see it in protected mode. We will copy the information to another sheet and will be able to edit the data.
- First, select the whole dataset. Then, copy the data from the Data Set sheet by pressing Ctrl+C.
- Then, go to Cell B1 of the New Sheet.
- Press Ctrl+V to paste the data.
Now, we can edit data from the New Sheet.
In this article, we explained how to unlock a protected Excel sheet for editing. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.