Hi Ravinder,
Protect First Row: Select the cells to be protected
Right Click on them and Select Format Cells
Click Protection tab, Check if Locked property is selected or not.
It should be checked/selected.
Unprotect Rest Rows: Now Select rest of the cells to be unprotected.
Right Click on them
Hi Ravinder,
1) Select the entire worksheet and then removed the "Locked" Property from
the cell properties.
2) Select the cells you want to be locked and then reset the "Locked"
Property from the cell properties.
3) Select protect sheet and put a password.
Regards,
Andy
On Thu, Apr 30, 2009 at