Locking Cells?

  • Thread starter Thread starter Krefty
  • Start date Start date
K

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
 
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
 
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.
 
Back
Top