One way

=INDEX($1:$1,ROWS($A$1:A1))

copy down

You need to put this in A2, once you are done you can copy the formula and
paste special as values and delete the first row or else you will get a
circular reference error





--
Regards,

Peo Sjoblom



"RLind" wrote in message
...
Is there a way to drag cells down that reference cells across. Here is an
example:

Column
A B C
Dog Cat Mouse

I would like to make a cell = A1 (Dog), then drag DOWN (across is
standard)
so that A2 would equal Cat and A3 would equal Mouse.

A
Dog
Cat
Mouse

Thanks!