locking the cell

  • Thread starter Thread starter Albert Byun
  • Start date Start date
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')
 
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
 
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.
 
Back
Top