how can I clear a formula?

M

ManhattanRebel

I have a column that appears to have a formula in it. It is appears to
calculate figures for me automatically. How can I clear the formula out?
 
G

Gord Dibben

You use the word "appears" twice.

Is a cell with a formula nowhere to be found?

If it can be found, select the cell with the formula and hit the "delete"
button.

I would look for a formula in any cell that gives me a total of other cells.

If a formula cannot be found, perhaps some sheet event code?

Right-click on the sheet tab and have a look.


Gord Dibben MS Excel MVP
 
R

Rod

wonderful, thank you

is there any way to clear formulae in multiple cells at a time by this method?
thanks in advance.
 
F

Fred Smith

Yes.

Highlight the cells you want to change.
Right-click, Copy
Right-click, Paste Special...>Values>OK

Regards,
Fred
 
Top