I think you need to explain more, give an example of a formula
and what you mean by copying down from left to right?
My guess is that you want to copy a formula to the right in the same row but
somehow use the cells going down in a column

=INDEX($A:$A,COLUMNS($A:A))

will return what's in A1, A2, A3 and so on when copied to the right

Post back if that's not the case

--
Regards,

Peo Sjoblom


"Holly" wrote in message
...
Try to copy down formulars into a column from a row from left to right