Protecting and Hiding Formulas and Cells on your Excel Worksheet

1. click the tab at corner of your Excel sheet to select all the cells.

2. Press right click "Format Cells" and go to "Protection Tab".

3. Uncheck the check boxes for "Locked" and "Hidden" and press "OK".

4. From the "Edit" menu select "Go to".

5. Press the "Special" button,select the "Formulas" radio button and click "OK".

6. Hold the "Ctrl" button and click on the other cells you would want to protect.

7. Press right click "Format Cells" and go to "Protection Tab".

8. Activate the check boxes for "Locked" and "Hidden" and press "OK".

9. From the "Tools" menu, select "Protection", then "Protect Sheet".

10. Activate the "Protect worksheet and content of locked cells" checkbox. Activate other options you would want your users to access from the list. Usually "Select locked cells" and "Select unlocked cells" are activated and press "OK".

11. Inputting a password is highly recommended to ensure security of your data. However, you may also choose not to.