Protect only certain Cells?
 

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

Protect only certain Cells?
 

I forgot to ask for notification of reply.

"Katee" wrote:

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

Protect only certain Cells?
 

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.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Katee" wrote:

I forgot to ask for notification of reply.

"Katee" wrote:

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

Protect only certain Cells?
 

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



"Katee" wrote:

I forgot to ask for notification of reply.

"Katee" wrote:

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