Can a cell be locked to prevent being typed over?

[debbieah]

I'm trying to lock a series of cells that have formulas so that my coworkers
cannot mess up my worksheet. I don't want to lock the entire worksheet -
just those few cells with formulas. Is there a way to do this?

 

[Paul B]

debbieah,
By default all cells in excel are protected or locked, select the cells you
want to unlock and go to format, cells, protection and uncheck locked, the
go to tools, protection, and protect sheet, enter a password if you want,
now only the cells that you unlocked can be edited.



If you only need a few locked I would select them all first, Ctrl A, then
go to format, cells, protection and uncheck locked, then select the cells
you want to lock and go to format cells and check locked, the go to tools,
protection, and protect sheet, enter a password if you want, now the cells
that you locked can not be edited
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Peo Sjoblom]

If there are a few cells that you want to lock, select the whole sheet,
do format>cells>protection, uncheck locked, while still selected prefss F5.
click special and select formulas and press enter, do format>cells protection
and cechk locked. Then protect the sheet

Regards,

Peo Sjoblom