Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I lock a formula in a cell in an Excel worksheet?
I created a disbursement worksheet which is simple to use, just involves
plugging in numbers and it figures everything out for us. However my coworker keeps erasing her formulas wehn entering info. Is there a way to lock a formula while still allowing numbers to be entered in the cell? Thanks for your help. Kathie |
#2
|
|||
|
|||
Sure, ensure the formulas cells are locked and the other cells unlocked.
When you password protect the sheet, make sure the section "Allow all users of this worksheet ti:" to not have Select locked cells checked. HTH |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't get a formula to work in each row of an Excel sheet. | Excel Worksheet Functions | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Need help to set-up a formula on Excel work sheet? | New Users to Excel | |||
looking for a formula | Excel Worksheet Functions | |||
What is the formula for adding mulitple numbers in one excel cell. | Excel Discussion (Misc queries) |