Protect Workbook or Protect Sheet are made to prevent the workbook structure or sheet data from any unwanted change. You can add a password also to open the Workbook.
You have to go to Review tab and click on Protect Workbook in the Changes group.
There this small window will appear. Here you can add a password to open the workbook. This will prevent the workbook structure from any unwanted change.
Now what is Protect Sheet? Obviously it protect a particular sheet. You can go to Review tab and click on Protect sheet in the Changes group.
There are another way to go to Protect Sheet. Click on any sheet tab below the sheet. Right click on it and click Protect Sheet.
You can put a password to access the sheet editing. By default the sheet will allow the other users to select the locked or unlocked cells only.
But you can allow users to make these changes also if you ticked the options below.
- Select locked cells
- Select unlocked cells
- Format cells
- Format columns
- Format rows
- Insert columns
- Insert rows
- Insert hyperlinks
- Delete columns
- Delete rows
- Use AutoFilter
- Use PivotTable and PivotChart
- Edit objects
- Edit Scenarios