Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell Protection
|
|
|
The UK's most regular 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. |
Cell Protection
Resolved · High Priority · Version 2007
Reply Fri 12 Jun 2009, 12:21Delegate Ariyanna said...
Ariyanna has attended:
Excel Intermediate course
Excel Advanced course
Cell Protection
Is there anyway to Lock/protect single cells with formula is a Spreadsheet without locking the whole spreadsheet?
I have a worbook whic requires other users to put in a lot of data but I don't want them to edit the formulas by mistake so need to lock these?
For upcoming training course dates see: Pricing & availability
RE: Cell Protection
Hi Ariyann, thanks for the query. To achieve this, you need to do three things.
1) Select the entire worksheet and click Format-Cells, the Protection tab and deselect the "Locked" tickbox, so all cells are unlocked.
2) Then repeat the process, but this time just select the cell you want to protect and make sure the "Locked" tickbox is selected.
3) Then Tools-Protection-Protect Sheet. Make sure that "select Locked cells" is deselected and "select unlocked cells" is selected. Hit OK and your cell will be untouchable!
You can add a password to prevent users undoing all this, and add in various other levels of security into the Protect Sheet dialog box.
Hope this helps,
Anthony
Thu 18 Jun 2009: Automatically marked as resolved.
|