Cell

A

Ashok Sabne

I want to protect a cell after entering formula. But at the same time the entire worksheet except that cell should be unprotected/Open for edit.

Kindly suggest solution for the same.
 
J

jeff

Hi,

It's easy. Select all the cells you want to allow
access, Ctl-click on the cell you wish to protect.
Go to menu, format>cells choose Protection,
uncheck "locked". and OK.

you're done.

jeff

-----Original Message-----
I want to protect a cell after entering formula. But at
Click to expand...
the same time the entire worksheet except that cell
should be unprotected/Open for edit.
 
Top