| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to lock 5 cells but not protect entire sheet
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Threaded Mode
