That is exactly how it should be. Since you are copying down a column, the
reference to A will not change
Workaround: drag to the left. So lets say we now have =A$3, =B$3, =C$3 ...
starting in B10
Copy all these formulas except the first, move to B11 and use Paste Special
with Transpose specified
Now you have what you want but will need to delete C10, D10.....
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Luzma" wrote in message
...
I want to copy a formula that has a relative column and an absolute row
A$3
but when I try to copy it down the column doesn't change it copies the
same
A$3 and I want B$3 C$3 etc.. Can someone help me? Thanks!!