Click OK at last to protect this worksheet.ģ.
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. In following Protect Sheet dialog, check Protect worksheet and contents of locked cells. Navigate to File Info Protect Workbook Protect Current Sheet.Ģ. You cannot find "Restrict Editing" option in Protect Workbook, but you can select Protect Current Sheet option to prevent this worksheet from editing.ġ. Section 2: Set modify password to restrict editing on excel 2016 worksheetĮxcel 2016 worksheet modify password is a little different from Word 2016. Then you could see a password is required to open this workbook. Reenter the same password and press Enter to confirm encrypting excel 2016 workbook.ģ. Type a powerful password in following Encrypt Document dialog, and click OK.Ģ. Just like Word/PowerPoint 2016, you can also set a password to restrict access to Excel workbook/worksheet.Īfter 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.ġ. Section 1: Add open password to encrypt Excel 2016 spreadsheet In this part, open password and modify password will be set to protect excel 2016 workbook or spreadsheet. Section 2: Set modify password to restrict editing on excel 2016 worksheet.
How to add password to protect Excel 2016 spreadsheet
0 kommentar(er)
