Hi,

In cell A1, you may enter the following formula

=INDIRECT(ADDRESS(1,ROW()+2))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Ana via OfficeKB.com" u51486@uwe wrote in message
news:a8f8094c7f08b@uwe...
Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
corner of a cell. I will automaticly link
A1 - C1
A2 - C2
A3 - C3 ect

My question is if it is possible to drag horisonal and link vertically???

A1 - C1
A2 - D1
A3 - E1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/201006/1