| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link and transpose? | Excel Discussion (Misc queries) | |||
| Transpose and Paste Link | Excel Worksheet Functions | |||
| How can I transpose a paste link? | Excel Discussion (Misc queries) | |||
| How can I transpose a paste link? | Excel Discussion (Misc queries) | |||
| Transpose and link at the same time? | Excel Discussion (Misc queries) | |||
Hybrid Mode
