Making Cells with forumlas in them uneditable

**bite_tony** · 04-25-2012, 05:18 AM

Hi,
I was wondering how I can make cells who's vaules are dependent on formulas (and not on me inputting data manually) uneditable within a worksheet?

(After having spent days lovingly nuturing my spreadsheet I'm about to give it over to other people to input data, and i don't trust 'em..not one bit)

**royUK** · 04-25-2012, 05:22 AM

Use Worksheet protection

**bite_tony** · 04-25-2012, 05:32 AM

That seems to lock up the whole sheet..
I would like it to allow data to be inputted but not formulas deleted?

**royUK** · 04-25-2012, 06:49 AM

Read it properly. You need to first select the whole sheet, then Format -> Cells & unlock the cells.

Next select the cells with formulas & Format -> Cells & lock those cells & Hide (hide prevents others viewing the formulas)

Then Protect the sheet