If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Transpose link
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 |
#2
|
|||
|
|||
Transpose link
Hi,
Try in "a1" =INDIRECT(ADDRESS(1,ROW(A3))) And Fill/Drag the formula down. Regards Steve "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 |
#3
|
|||
|
|||
Transpose link
Put this in B1:
=INDEX(C$1:M$1,ROW(A1)) and copy down. Adjust the range C1:M1 to suit how far you want to copy it down. Hope this helps. Pete On Jun 3, 11:20*am, "Ana via OfficeKB.com" u51486@uwe wrote: 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.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/201006/1 |
#4
|
|||
|
|||
Transpose link
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 |
#5
|
|||
|
|||
Transpose link
Try this…
Copy and paste the below formula in A1 cell. =INDIRECT(ADDRESS(1,COLUMN(B1)+ROW())) Drag it to the remaining cells of A column. -------------------- (Ms-Exl-Learner) -------------------- "Ana via OfficeKB.com" wrote: 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 . |
#6
|
|||
|
|||
Transpose link
Another way ..In cell A1 and copy down
=OFFSET($B$1,,ROW()) -- Jacob (MVP - Excel) "Ana via OfficeKB.com" wrote: 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 . |
Thread Tools | |
Display Modes | |
|
|