Home > Resources > Office Password > Excel 2016 Password Protection Add/Remove

How to Add or Remove Password Protection in Excel 2016

This article will introduce excel 2016 workbook/worksheet password protection add or remove in two parts.

  1. Part 1: How to add password to protect Excel 2016 spreadsheet
  2. Part 2: How to remove Excel 2016 spreadsheet protection

How to add password to protect Excel 2016 spreadsheet

In this part, open password and modify password will be set to protect excel 2016 workbook or spreadsheet.

protect excel 2016 workbook

Section 1: Add open password to encrypt Excel 2016 spreadsheet

Just like Word/PowerPoint 2016, you can also set a password to restrict access to Excel workbook/worksheet.
After making sure Excel 2016 worksheet is finished editing, turn to File > Info > Protect Workbook, where you can choose an option Encrypt with Password to set open password to this excel workbook, protecting all of worksheets in it.

choose encrypt workbook with password

1. Type a powerful password in following Encrypt Document dialog, and click OK.

encrypt excel workbook with password

2. Reenter the same password and press Enter to confirm encrypting excel 2016 workbook.

confirm password to encrypt excel workbook

3. Then you could see a password is required to open this workbook.

protect excel 2016 workbook with open password successfully

Section 2: Set modify password to restrict editing on excel 2016 worksheet

Excel 2016 worksheet modify password is a little different from Word 2016. You cannot find "Restrict Editing" option in Protect Workbook, but you can select Protect Current Sheet option to prevent this worksheet from editing.

1. Navigate to File > Info > Protect Workbook > Protect Current Sheet.

choose protect current sheet option

2. In following Protect Sheet dialog, check Protect worksheet and contents of locked cells. Set a password to protect/unprotect this worksheet, and under Allow all users of this worksheet to option, choose what you want to allow users to do. Click OK at last to protect this worksheet.

set password to protect worksheet

3. Type password again to confirm worksheet password protection.

confirm password to protect excel worksheet

From then on, everyone who wants to open workbook or edit worksheet, should type correct password to open excel 2016 workbook, and then enter modify password to unprotect excel 2016 worksheet.

protect excel 2016 worksheet with modify password successfully

If you don’t like password protecting excel 2016 workbook or spreadsheet any longer, you can remove password protection from excel 2016 when you know password.

How to remove Excel 2016 spreadsheet password protection

When you have open or modify password, follow article below to remove excel 2016 password protection.

Section 1: Remove Excel 2016 open password protection

While you try to open password protected excel 2016 workbook, and a password dialog appears, type open password you know and click OK to open excel workbook. Then you could remove excel 2016 open password.

open password protected excel workbook with open password

1. Go to File > Info > Protect Workbook, and choose Encrypt with Password option again, just like when you encrypt excel workbook.

select encrypt with password on encrypted excel workbook

2. Clear password in pop-up dialog Encrypt the contents of this file. Click OK.

clear excel 2016 workbook open password

Tips: If you don’t know password to open excel workbook, remove excel password protection would not be so easily. But if excel open password really forgot or lost, how can you do? In my experience, you can get Office Password Genius Advanced to fast recover excel password, and then you can remove open password from excel workbook like above introduction.

Section 2: Remove Excel 2016 spreadsheet modify password.

Choose File > Info, next to Protect Workbook, you can see whether your excel worksheet is restrict editing.
If you see there is a message "One or more sheets in this workbook have been locked to prevent unwanted changes to the data", click Unprotect button after it. Type modify password you know in Unprotect Sheet dialog, and click OK.

remove excel worksheet password protection

At this moment, you have successfully removed Excel 2016 open and modify password protection if you see following screen.

remove excel password protection successfully

Related Articles:

Hot Categories
Windows Password
iTunes Password
Office Password
More +
Hot Articles
Locked Out of Office Files - How to Open
3 Ways to Remove Word Password
Forgot Excel Workbook 2010/2013/2016 Password | How to Do
How to Unlock Password Protected PowerPoint Presentation
How to Remove Forgotten Password from Access Database
More +
Latest Articles
How to Unprotect Excel Workbook without Password
How to Recover Outlook 2016 PST File Forgotten Password
Office 2016 Password Recovery after Forgot or Lost
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +