Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002
I am trying to copy cells from one worksheet to another but I want to
transpose them so that the same data shows horizontally rather than vertically on the new sheet. I want the data to be linked to the first sheet so that if I change the info on the first sheet it will automatically change on the second sheet. There are a large number of cells involved. I've done the normal Paste Special, transpose but it doesn't seem to work. Any suggestions? Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2002
Select your horizontal destination range on the second sheet.
Enter = TRANSPOSE() then with the cursor between the parentheses select your vertical source range on the first sheet. Ensure that the horizontal size of the destination array is the same as the vertical size of the source array, and vice versa. Commit the transaction with Control Shift Enter, and it will surround your formula with braces to denote an array formula, such as {=TRANSPOSE(Sheet1!A1:A10)} -- David Biddulph "rubyc" wrote in message ... I am trying to copy cells from one worksheet to another but I want to transpose them so that the same data shows horizontally rather than vertically on the new sheet. I want the data to be linked to the first sheet so that if I change the info on the first sheet it will automatically change on the second sheet. There are a large number of cells involved. I've done the normal Paste Special, transpose but it doesn't seem to work. Any suggestions? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 | Excel Worksheet Functions | |||
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
Excel 2002 | Excel Discussion (Misc queries) | |||
Atomatic file name in excell 2002 from cel A1 (like in word 2002) | New Users to Excel | |||
Can you print labels using Excel 2002 in a Word 2002 mail merge? | Excel Discussion (Misc queries) |