locking the cell

F

Frank Kabel

Hi
- first select all cells for which you want to ALLOW data entries
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- Protect your worksheet ('Tools - Protection')
 
F

Freemini

Under format cell choose the protection tab, check the locked option
repeat this for all cells to be protected.

Under the Tools menu chose Protection, Protect sheet.

Now all Locked cells will be protected from over writing.

hth

Mik
 
A

Anderson Lee

You could download the third party tool: AddinTools Assist from
http://www.addintools.com. It will temporarily display unlocked cells and
locked cells with different background colors. You will find out which are
locked cells, which are unlocked cells immediately. The "To Lock" button and
"To Unlock" button could lock or unlock the selected cell immediately. In
this way, you can decide fast which part of spreadsheet allows changing, and
which part disallows.
The function is very useful when you have forgotten which cells are locked
in a workbook or sheet.
 
Top