You may wish to protect single cells, sections of the worksheet or entire worksheets from change or access depending on:-
Protected cells cannot be changed, moved or copied without first being unprotected.
Protection can be secured using passwords.
However care must be taken with passwords.
If forgotten, your spreadsheet is irretrievable.
In Excel cells are LOCKED as a default setting.
However this has no effect until the worksheet itself is protected.
Properly designed worksheets usually have a combination of protected and unprotected areas.
Labels and formulas are often protected to stop users from accidently deleting or changing them.
To create a worksheet with a mix of protected and unprotected cells you must unlock the cells you wish to be able to change before protecting the worksheet.
These are the steps
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 Click 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.
You can see there are lots of options, we will just accept the defaults
7 In the Password box, type a password if you want to prevent others from turning off document protection.
8 Click the OK button.
9 In the Reenter Protection Password box, type your password to confirm it.
10 Choose the OK button.
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 Consolidation Exercise 1 from the Exercises listed in the Topic Menu below.
This exercise should allow you to practice several of the spreadsheeting skills you have been studying.
As it forms part of your assessment you should hand in your completed solution to your tutor