Auto fill

P

phil2006

When you copy a formula from cell to cell is there a way in which yo
can keep the formula identical. I.e. When you copy a formula from cel
a1 to a2 any other cell references increase proportionately. Can I sto
this?

Thanks very much

Phi
 
Z

Zygan

you can lock the formula by adding dollar signs e.g
=a1+a2
if you move it it will change


=$a$1 + $a$2

will lock the formula

if you add only a $ in front of the column e.g $a1 then it will loc
the column only vice versa



good luc
 
M

MartinW

Hi Phil,

As well if you click on the cell reference in the formula bar and hit
the F4 key it will put the dollar signs in for you. Keep hitting F4
and it will cycle through the 4 options, e.g. $A$1, $A1, A$1 + A1

HTH
Martin
 
Top