What Is Protect Sheet In Excel. Suppose you are sending a report to management and then the management knowingly or by mistake changes the parameters or values through the report. Click review > protect sheet to protect current worksheet.
You can do it by clicking on the file icon, it will open a list of options, select the info tab and click on the protect workbook. As soon as you click on unprotect, it will ask you to enter the same password which you have typed while protecting the sheet. In the protect sheet dialog box, specify a password in the password to unprotect sheet box, and check the edit objects box in the allow all users of this worksheet to box, then click the ok button.