| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i copy data and formula from a column to a row in another?
i have a worksheet that has data and formulas in a column, how do i link this
data and formulas to another worksheet but the data is now to be in a row? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i copy data and formula from a column to a row in another?
Say original data are A2:A11 and B2:B11 (formulas) (this is a 10x2
array). Say you want them transposed starting from C1. Select a 2x10 array (reverse the dimensions). Then type: =TRANSPOSE(A2:B11) Commit with Shift+Ctrl+Enter Does this help? Kostis Vezerides On Dec 11, 8:14 pm, john.laffe wrote: i have a worksheet that has data and formulas in a column, how do i link this data and formulas to another worksheet but the data is now to be in a row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a formula into a blank column only to the last data row | Excel Worksheet Functions | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Copy Sum formula to different row but use same column data | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Hybrid Mode
