Copy formula question

[Belinda7237]

I have a workbook that contains a formula in many cells:

=$A$1 next cell says = $A$2...etc

Ech month i insert a row and although there are $ the fomula when i cut and
paste updates prooperly to $b$1 - however this time - it held its A1$A2 -

normally i know the dollar signs should mean to hold that cell position but
i want to be able to copy into an newly inserted row - without having to
remove the $ as i have lots of formulas.

 

[Gord Dibben]

You have to watch the $ signs that "fix" the column or row reference.

=$A$1 will stay fixed copying across or down.

=A$1 will copy across changing just the Column reference but stay the same
copying down.

=$A1 will copy down changing the row reference but stay the same copying
across.

Play with it..................you'll get it.


Gord Dibben MS Excel MVP