An Easy Guide to Unprotect Cells in Excel

/ Posted by Shirley Howard to Excel / Follow @Shirley Howard

Worksheet protection is not a security feature in Excel. It is not actually intended to prevent people from accessing data in a protected sheet. Because Microsoft Excel uses a very simple encryption innovation for worksheet protection so does this means that Excel protection is useless? Not at all! It is made to lock your worksheet to protect from accidental changes in the content. Now, here in this article, we will show you the detailed steps to unprotect cells in Excel.

Why People Want to Unprotect Excel Cells?

Protecting cells in Excel is very easy to eliminate the chances of any data changes or any loss of important content but unprotecting a cell in Microsoft Excel is even easier. The question why people want to unprotect the cells in Excel has the answer to view the document, to make changes in the document or to fix an error in the document. In Excel, the cells are locked by default to protect a worksheet from being altered or edited by someone else. But, if you want to unprotect a cell in Excel it is not a big deal. There are some methods to unprotect cells in excel either you came up with a password protected sheet or a non-password protected sheet.

How to Unprotect Cells in Excel File?

Solution 1: Unprotect Excel Cells with Known Password

In Microsoft Excel, you set a password to prevent others from opening and modifying your documents, workbooks, and presentations. But you can easily unprotect specific range of cells in your documents and presentation when read-only is not the option anymore. After setting the password for your file, that password has to be entered before anybody else can open the file.

Following is an easy guide on how to unprotect selected cells in Excel:

  • Select the cell you wish to modify. To highlight a range of cells, hold down the “Control” key while selecting the additional cells.
  • Click the “Home” button.
  • In the “Cells” area, select “Format” > “Format Cells”.
  • excel format cell option
  • Select the “Protection” tab, and then clear the check mark from the “Locked” box.
  • As the dialog box says, locking cells or hiding formulas has no effect until you protect the worksheet. You can do so under the “Review” tab by selecting “Protect Sheet”. Click “OK”.
  • Right click the sheet tab at the bottom of the screen, select “Protect Sheet” and then click “OK”. The entire sheet is now protected except the cells you unlocked.
  • cell protection

If you want to edit a password protected sheet but you have forgotten the password, try to unprotect the sheet by using the following methods:

Solution 2: Unprotect Excel Cells with Zip Software

This way only works for Excel file in .xlsx format. Hence, if your Excel workbook is in .xls format, just open it and then save it as .xlsx format.

  • Change the Excel file name extension from .xlsx to .zip. Just click on “Yes” to make sure when prompted.
  • rename extension
  • Open the ZIP archive with 7-ZIP. Open the folder xl->worksheets and you can see sheet1.xml, sheet2.xml, sheet3.xml file. If you want to unprotect the sheet1, select the sheet1.xml file. Right click on it, select Edit, and open it with Notepad.
  • open xml
  • Delete the tag beginning with sheet Protection. Then save and close the sheet1.xml file.
  • delete tag
  • Update the modified sheet1.xml file in the ZIP archive when prompted. Then close the ZIP archive.
  • update archive
  • Change the ZIP fie name extension back to .xlsx. At this point, the Excel sheet has been unprotected. Open it and you can edit the sheet without password.

Solution 3: Unprotect Excel Cells with VBA Software (For 2010 and lower)

  • Open your Excel document and switch to the password-protected sheet.
  • Press Alt + F11 to open the Visual Basic Editor.
  • Right-click on the workbook name on the left pane (Project-VBA Project pane) and select Insert > Module from the context menu.
  • protect sheet merge cells
  • In the window that appears, paste the following code that appears.
  • select excel sheet in vba to unprotect
  • Press F5 or click the Run button on the toolbar and wait for some minutes.
  • The macro will report a cracked password, which is not the original one (always some combination of A’s and B’s), but it works. Simply click OK and the sheet is unprotected.

But remember that, if your file contains more than one protected sheets than you have to run the macro individually for each sheet.

To unprotect Excel sheet without password in the modern versions of Excel 2013 and Excel 2016, you can save the document as Excel 97-2003 workbook (*.xls) first, run the macro to unprotect it, and then save the workbook back as an .xlsx file. Alternatively, you can use one of free tools, for example Password Protection Remover add-in for Excel.

Solution 4: Unprotect Excel Cells with PassFab Software

The quickest and most efficient way is to use the PassFab for Excel software. If you’re locked out of the Excel file and would like to open the file without password, that’s not a worry anymore, because you got the PassFab software. This password recovery software can easily recover lost password with powerful brute force attack.

  • Free download this Excel xls/xlsx password recovery on your computer first.
  • Free Try PassFab for Excel Now:
    Free Download For Win 10/8.1/8/7/XP
    Secure Download
  • Open the software and see the interface of the software. Then click “Add” to import the locked Excel spreadsheet whose password you want to recover.
  • add file
  • There are 3 types of attack available: Brute-force Attack, Brute-force with Mask and Dictionary Attack. Choose Attack Type and Set its parameters accordingly.
  • dictionary attack
  •  Start to recover the lost protected password for your Excel file. Click “Start”.
  • dictionary attack

    Summary

    This article is about unprotected cells in Excel worksheets. Unprotecting cells is easy when you know the password. But when you forget the password, it seems a little complicated. The solutions described above really work. A program named PassFab for Excel can be used in situations when you wish to unprotect cells in Excel but you don’t remember. Use the PassFab for Excel software which user brute force to recover the lost protected password.

    Free Try PassFab for Excel Now:
    Free Download For Win 10/8.1/8/7/XP
    Secure Download
Comment

Product-related questions? Speak directly to our Support Team >>