View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default How to lock cell

By default all cells on a sheet are locked when the sheet is
protected.

Select all cells(CTRL + a...........twice in Excel 2003) then go to
formatcellsprotection and unlock all.

Now select just the cells you want locked and mark them as locked.

Protect the sheet.


Gord

On Tue, 13 Mar 2012 19:26:54 +0000, Moideen
wrote:


Hi,

How to lock a particular cell without locking the whole work sheet

Pls help me.