Lock Cells

[JoshuaMars]

Hi there Excel users.

Is there a way to lock cells that contain a formula.

For example.

In one cell has a sum formula for a year. Can I lock that cell. Then change data in the cells that the sum is working on.

Hope its not to hard to understand.

 

[Richard Schollar]

Hi Marsy

If you right-click on the cells that the formula refers to and go Format Cells>Protection tab and uncheck the Locked checkbox, click OK. If you now go to Tools>Protection and protect the sheet, your formula should be protected, but you will still be able to make amendments to the non-Locked cells the formula refers to.

Best regards

Richard

 

[JoshuaMars]

RichardSchollar,

I see what you ment and thankyou.

But still not what im lockign for.

I'll try to explain.

I want to lock the cell and what ever the result of the formula at that time, i want it to stay there. But still use the cells that the formula refers to and change them.

 

[Richard Schollar]

You could turn calculation to manual (Tools>Options>Calculation tab and check Manual) which means your formula cell will not recalculate until you press F9 (or Shift F9 for the individual sheet). Then you can make adjustments to the cells the formula refers to without the formula cell changing.

But note: I don't think this is really what you want either - the formula value will change as soon as you recalculate.

Richard

 

[JoshuaMars]

RichardSchollar,

Thats what I was hoping to avoid.

I didnt want the formula value to change if I locked it.

Any ideas?