How do I lock a formula in a cell in an Excel worksheet?

K

katydyd

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
 
D

DNA

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I lock a formula in a cell in an Excel worksheet? 1
Copying locked cells 6
Locked cells in Excel 1
Allowing row deletion in worksheet with locked cells 2
Hide and lock cell formulas without affecting Macro? 4
Select locked cells 2
Finding and locking formula cells 2
Locking cell data from change 1

Top