Locking Cells?

[Krefty]

I can not for the life of me remember how to lock specific
cells from users overwriting data. Can you help?

Thanks in Advance...

Krefty

 

[Andy Brown]

Krefty,

Select the whole sheet (CTRL+A). Then Format -- Cells -- Protection. Uncheck
Locked, click OK. Select the cells or ranges you want to lock (use CTRL to
multi-select if necessary) and re-lock. Then protect the sheet via Tools --
Protection.

Tip -- throw in Hidden to prevent formulas from showing in the formula bar.

Warning -- sheet and book protection is easily broken with a little
know-how.

Rgds,
Andy

 

[stro]

right click in cells you want to not be locked, and click
format cells, then protection tab, deselect locked. After
you have done this to all cells users can alter, go to
tools, protection, and protect the document.