To prevent other users from changing the worksheet theme or styles, select the Format Cells check box.
To prevent other users from using features that can change the worksheet, such as sorting or filtering data, or using pivot tables or pivot charts, select the Windows check box.To prevent other users from changing the structure of the worksheet, such as adding or deleting worksheets, select the Structure check box.To prevent other users from inserting or deleting rows, columns, or cells, select the Insert Rows, Insert Columns, or Insert Cells check box.To prevent other users from accidentally or deliberately changing data in cells, select the Locked check box.In the Protect Sheet dialog box, do one or more of the following:.Click the Format button on the Home tab, and then click the Protect Sheet button in the Cells group.To protect a worksheet, do the following:
You can protect a worksheet so that only unlocked cells can be changed, and you can specify a password that must be entered to unprotect the worksheet.