Protect only certain Cells?

K

Katee

I've tried & tried to protect only certain cells in a worksheet to protect
formulae, but can't seem to find how to do it. Any suggestions?

Katee
 
K

KC Rippstein hotmail com>

All cells are "locked" by default, but "locking" does not mean anything until
you protect the worksheet from the "Tools->Protection" menu. So your first
task is to select any cells that a user IS allowed to change (use the ctrl
button to select all of them at once), then hit Ctrl+1 and go to the
"Security" tab to unlock those cells. Then go to Tools->Protection->Protect
Sheet, and you can assign a password or not.
 
P

Prasadkakarla

Hi Katee. Its very easy
there is few steps to follow u will get answer !!!
Step I : 1st select full sheet and go to Format cell (ctrl+1), Protection
select the Locked box.
Step II : Then you go which cell u want to protect select those cells
Step III: same procedure go to formate cell (Ctrl+1), protection remove the
selection in Locked box.
Step IV: Go to TOOLS - PROTECTION - Protection sheet - select the unlocked
cell box only.
Then enter OK

try this and give me reply
--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI
 
Top