Convert my formula to indirect???

Hi All,

I have been wracking my brains for ages and am not getting anywhere.

I have data in my spreadsheet and I want to add like this =c1+f1

I need to insert cells all over the place to make my work balance but I want these formulas to always stay as =C1+f1 and not auto update to eg =c1+f2

Anyone know how to do this?

i'm not 100% sure on the question, but i think i have the gist of it.

Im thinking what you want is an absolute cell reference.
This makes sure that the cell reference the formula is referring to does not change.

Using your example

Normal cell reference:=c1+f1
when dragged down:=c2+f2

Absolute cell reference:=$c$1+$f$1
when dragged down:=$c$1+$f$1

just put a "$" sign before the letter and the number in the formula.

May not be what your looking for but it might help.