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.

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

On Thu, 5 Mar 2009 13:16:01 -0800, Belinda7237
<(E-Mail Removed)> wrote:

>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.