Protection of a sheet or an entire MS Excel workbook is used quite often. It is common in companies that use Excel functionality related to numbers, formulas and calculations. The administrator can protect individual sheets or the entire book from accidental changes to the specified relationships.
Instructions
Step 1
In MS Excel, there are two simple options for setting up protection: sheet protection and workbook structure protection. To protect a sheet, go to the desired sheet and select any cell in it. Go to the "Service" menu and expand the "Protection" sub-item. In the drop-down list, select the "Protect Sheet" command.
Step 2
You will see a window with protection parameters. Indicate from what changes the sheet should be blocked by highlighting the appropriate options with checkmarks. Also set a password if necessary, confirm it and click "OK".
Step 3
Protect the entire book in the same way. To do this, select "Service" - "Protection" - "Protect Book …". Specify protection parameters (here there are an order of magnitude less than in sheet protection) and, if necessary, set a password. Feature of workbook protection is that you can change data in different sheets, but you will not be able to add or delete Excel sheets themselves.
Step 4
To unprotect a sheet, select the "Tools" - "Protection" - "Unprotect Sheet" command from the menu. If a password has been set in the lock settings, enter it. The full functionality of the Excel sheet will be restored.
Step 5
Similarly, you can remove protection from the entire book. Go to the menu "Service" - "Protection" - "Unprotect the book". Also enter the password. The Excel workbook structure will be fully editable again.
