Turning on Protection

These are the steps to protect section of a Worksheet

1 Select the cells you want to unprotect.

2 From the Format menu, choose Cells then the Protection Tab.

3 Unlock the cells you want by turning off the Locked check box.

4 Choose the OK button.

NOTE: You can still edit Locked Cells if the document is unprotected.

5 From the Tools menu, choose Protection.

6 Select the Protect Sheet option.

7 In the Password box, type a password if you want to prevent others from turning off document protection.

8 Choose the OK button.

9 In the Reenter Protection Password box, type your password to confirm it.

10 Choose the OK button.

Turning off Cell Protection

1 From the Tools menu, choose Unprotect Document.

2 If the worksheet is protected with a password, type the password in the Password box.

3 Choose the OK button.


Consolidation Exercise 1 - The Boiler

You should attempt the Consolidation Exercise exercise from the Spreadsheet Exercises listed in the Topic Menu below.

Email/present your solution to your tutor for checking.