Drag to fill row with column values

[michaelberrier]

In the sheet "Stats", there are columns of numbers, we'll say A1:A10,
that I would like to automatically put in a single row, we'll say
A15:J15,using "=A1" and so on, and I'd like to do this many times.

In A15 I put "=A1"....is there a keyboard shortcut that, when pressed
while I drag to the right will put "=A2" in B15 instead of B2, and so
on?

Thanks to all.

 

[Ragdyer]

This works as long as you *don't start* the copying in Column A:

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

Drag right to copy as needed.


If you must start copying in Column A, then you need to define the ranges:

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