Cindy has attended:
Excel Intermediate course
Excel Introduction course
Visio Introduction course
Visio Advanced course
Excel Advanced course
Excel
Can you protect areas of a worksheet so that no one else can amend them and leave other sections free to be amended?
RE: Excel
Hi Cindy
Thank you for your question.
The answer is yes, you can.
To do this:
1. Firstly select the cells that you want people to be able to amend/edit.
2. Go to Format - Cells - Protection and uncheck the Locked box and click OK.
3. Then to apply protection to all other cells, go to Tools - Protection - Protect Sheet.
4. Enter a password if you wish. If you set a password, this means that someone has to enter the password in order to lift the protection on the spreadsheet.
5. Click OK.
You should find that you are able to edit/amend what is in the cells that you selected and unlocked in steps 1 and 2 above; but any other cells in the spreadsheet cannot be edited.
I hope this helps; and that you enjoy your next course in January.
Happy Christmas
Amanda
