Lock Cells

JoshuaMars

New Member
Joined
Jul 13, 2006
Messages
46
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.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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

New Member
Joined
Jul 13, 2006
Messages
46
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

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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

New Member
Joined
Jul 13, 2006
Messages
46
RichardSchollar,

Thats what I was hoping to avoid.

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

Any ideas?
 

Forum statistics

Threads
1,136,427
Messages
5,675,789
Members
419,586
Latest member
RoteichA

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top