Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am doing a budget spreadsheet that will always need editing but I don't
want anyone to remove the formulas from cells where the final totals appear. If I protect the worksheet, I can't edit anything. How can I lock only those 5 cells and still work on the other. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
First select the whole sheet using the select all button at the intersection
of column header A and row header 1, then do formatcellsprotection, deselect hidden, now select the 5 cells you want to protect and do the same but check locked, finally do toolsprotectionprotect sheet and protect the sheet. This will leave all other cells open and protect only the 5 cells you selected -- Regards, Peo Sjoblom "Lock MY Cells" <Lock MY wrote in message ... I am doing a budget spreadsheet that will always need editing but I don't want anyone to remove the formulas from cells where the final totals appear. If I protect the worksheet, I can't edit anything. How can I lock only those 5 cells and still work on the other. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Protection is really your only option.
To make things a little easier Click Tools|Customize - Commands Tab - Format and then drag the lock icont to one of your toolbars. This will make locking and unlocking cells a lot easier. Hightlight all of the cells in the entire spreadsheet and click the Lock icon. Now all of your cells are unlocked. Hit F5 - Special - Formulas - Ok. Now every cell that contains a formula is selected. Click the lock icon again to lock these cells. Now protect the sheet. Everything on the sheet should be open for editing except your formulas which are the only thing that is locked by the protection... -- HTH... Jim Thomlinson "Lock MY Cells" wrote: I am doing a budget spreadsheet that will always need editing but I don't want anyone to remove the formulas from cells where the final totals appear. If I protect the worksheet, I can't edit anything. How can I lock only those 5 cells and still work on the other. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I lock unclock cells to protect the data entered? | Excel Worksheet Functions | |||
How do I lock/protect cells so they can't be changed | Excel Worksheet Functions | |||
how do I protect formula's only, not entire sheet or book? | Setting up and Configuration of Excel | |||
Protect/Lock Specific Cells | Excel Discussion (Misc queries) | |||
Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) |