Prev: need a formula to find "*" in s string and multiply by preceding and following values
Next: How do I create a feedback form?
From: james on 19 Apr 2010 16:53
I know its basic but how do i protect a sheet so that when i delete an entry
i dont delete the formula?
Thanks
James

From: JLatham on 19 Apr 2010 17:19
All cells on a worksheet are "Locked" by default. When you apply Protection
to the sheet, with or without a password, you can no longer make changes to
Locked cells.

So begin by selecting and using Format --> Cells --> Protection to "Unlock"
the cells you DO want to be able to make changes to, as in deleting some user
input. Leave the ones with formulas in them locked. Then apply Protection
to the sheet.

You can select more than one cell at a time to unlock, but I usually make a
boo-boo somewhere, so I'll grab a few at a time and unlock them and then
choose some more and repeat until I'm all done. You can also choose entire
rows or columns to unlock/lock.

"james" wrote:

> I know its basic but how do i protect a sheet so that when i delete an entry
> i dont delete the formula?
> Thanks
> James
>
 | 
Pages: 1
Prev: need a formula to find "*" in s string and multiply by preceding and following values
Next: How do I create a feedback form?