How to Unprotect Excel 2016

/ Posted by Jenefey Aaron to Office Tips Follow @JenefeyAaron

Excel 2016 has a password protect feature that protects the entire workbook, the workbook structure and the worksheets. Without these passwords, you cannot make changes to the respective Excel subsets. It is therefore, important to know how to perform Excel 2016 unprotect procedure in the different scenarios. This is a handy guide to help you unprotect Excel workbooks, their structures and the worksheets therein.

Way 1. Unprotect Excel 2016 Workbook with Password

All workbooks that have been protected with passwords cannot be accessed without entering the password. Excel 2016 unprotect workbook procedure is as detailed below.

  • Step 1: Navigate to the location of the Excel file and open the workbook.
  • Step 2: Click the File tab locate in the ribbon then select Info.
  • excel 2013 info options
  • Step 3: Click the arrow next to the Protect Workbook button.
  • Step 4: Click “Encrypt with password” option.
  • encrypt with password
  • Step 5: A pop-up window will be displayed. Clear the black dots that represent the password in the password section and click Ok.
  • clear password
  • Step 6: Save the document by clicking the Save icon that resembles a floppy disk.
  • You will not be prompted to enter a password when you open the file.

Way 2. Unprotect Excel 2016 Workbook without Knowing Password

The simplest way to unprotect Excel 2016 is by using PassFb Toolkit. It is a great tool that enables users to remove password protection on the Excel File. It guarantees 100% decryption of workbooks and supports decryption of multilingual Excel files.

  • Step 1: Download install and run the free trial version of Excel Password recovery on your computer.
  • Step 2: Click Add button on the main interface.
  • import file
  • Step 3: Navigate to the location of the file you wish to remove or recover the password and add it. Choose one of the password attck types.
  • import file
  • Step 4. Click Start button and the document will be unprotected.
  • searching file password

Way 3. Unprotect Excel 2016 Workbook Structure with password

A workbook structure includes the worksheets and cells. Users cannot add worksheets to a file that has its workbook protected. To unprotect a workbook structure, follow the procedure below.

  • Step 1: Navigate to the location of the Excel file and open the workbook.
  • Step 2: Click Review located in the ribbon then, under the Changes group, click Protect Workbook.
  • Step 3: A small dialog box titled Unprotect Workbook will pop-up, enter the password and click Ok.
  • unprotect workbook structure
  • You will have unprotected the Workbook structure: users can now make changes to it.

Way 4. Unprotect Excel 2016 Workbook Structure without password

In case you do not have or have forgotten the password that protected the workbook structure, follow the procedure below.

  • Step 1: Navigate to the location of the Excel file and open the workbook.
  • Step 2: Hit the Alt + F11 keys simultaneously to launch Microsoft Visual Basic for Applications.
  • Step 3: Click Insert located in the main menu on the top bar and select Module.
  • unprotect workbook with vba code
  • Step 4: Enter the VBA code in the Module.
  • Step 5: Click the Run button or press F5 to execute it.
  • Wait for it to run. It may take some time to respond. You can edit the workbook structure when the process is complete.

Way 5. Unprotect Excel 2016 Sheet with password

To edit the contents of the cells, you have to unprotect sheet Excel 2016. To do so, follow the procedure below.

  • Step 1: Navigate to the location of the Excel file and open the Excel file.
  • Step 2: Click Review located in the ribbon then, under the Changes group, click Unprotect Sheet.
  • select unprotect sheet
  • Step 3: Enter the Unprotect Sheet password in the dialog box that appears and click Ok.
  • unprotect sheet

You can now make changes to the worksheet.

Way 6. Unprotect Excel 2016 Sheet without password

If you do not have or have lost the worksheet password, you cannot make changes to it. Excel 2016 unprotect sheet procedure is as detailed below.

  • Step 1: Navigate to the location of the Excel file and open the workbook.
  • Step 2: Hit the Alt + F11 keys simultaneously to launch Microsoft Visual Basic for Applications.
  • Step 3: Click Insert located in the main menu on the top bar and select Module.
  • unprotect excel spreadsheet with vba code
  • Step 4: Enter the VBA code in the Module.
  • Step 5: Click the Run button or press F5 to execute it.

Though it may take some time to complete the process, you will be able to make changes to the data in the worksheet.

Way 7: Copy Protected Excel Contents to Another Worksheet

A great workaround to access the content of a protected Excel file is by simply copying it to another worksheet by following the procedure below.

  • Step 1: Open the protected Excel file.
  • Note: You can only view the contents of Read Only protected files and not those that have been protected by a password

  • Step 2: Hit the Ctrl + A buttons to select the contents of the worksheet then press Ctrl + C to copy.
  • Step 3: Open a blank Excel file and press Ctrl + V.

Summary

The only way to access content of protected Excel workbook, workbook structure and worksheet is by unprotecting them respectively. A workbook consists of the workbook structure; a workbook structure consists of the worksheet and the cells. This article has detailed all the procedures of unprotecting the three subsets. In case you have forgotten the password to your workbook, we recommend using PassFab Toolkit to remove it.

Comment

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