98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Protecting sheet
Protecting sheet
Resolved · Low Priority · Version 2003
Marie has attended:
Excel Intermediate course
Excel Advanced course
Protecting sheet
how do you protect only some cells!!
RE: protecting sheet
Hi Marie
Thank you for your question.
The first thing you need to do is unlock the cells you want to allow people to change/edit in your spreadsheet.
To do this:
Select the cells, then go to Format - Cells - Protection and uncheck the Locked tickbox. Click OK.
Then apply protection to the sheet:
Tools - Protection - Protect Sheet (and enter a password if you wish). Click OK.
You should be able to change/edit data in the cells that you unlocked, even once protection has been applied.
I hope this helps.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Generate randon numbersSome types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it: |