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.