cell

[shrikant sinnur]

sir,
is it possible to lock(protect)sheet except perticular cell.
in a sheet there are so many formulas and functions. these functions gives result by chnaging values of perticular cell so other cells should be protected from user.

thanks
shrikant sinnur

 

[Andrew Poulsom]

Right click the cell you want to allow changes in and choose Format Cells. On the Protection tab uncheck Locked and click OK. Now protect the worksheet (Tools|Protection|Protect Sheet).