Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Collumns and rows
Can someone please tell me how to convert a collumn of data into a row. ie
how to copy a collumn and paste it as a row. the reason i ask is because i have two collumns of data which i am trying to create a scatter chart from but for the life of me i cant do it-i hear that rows are best for creating the chart-any thoughts? Thanks very much everyone Steve |
#2
|
|||
|
|||
smintey wrote:
Can someone please tell me how to convert a collumn of data into a row. ie how to copy a collumn and paste it as a row. the reason i ask is because i have two collumns of data which i am trying to create a scatter chart from but for the life of me i cant do it-i hear that rows are best for creating the chart-any thoughts? Thanks very much everyone Steve Copy-Paste Special-Transpose -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#3
|
|||
|
|||
Steve
If you have less than 256 rows in the column........ CopyPaste SpecialTransposeOKEsc. Note: you cannot paste onto any part of existing data range. Gord Dibben Excel MVP On Tue, 15 Feb 2005 03:49:03 -0800, "smintey" wrote: Can someone please tell me how to convert a collumn of data into a row. ie how to copy a collumn and paste it as a row. the reason i ask is because i have two collumns of data which i am trying to create a scatter chart from but for the life of me i cant do it-i hear that rows are best for creating the chart-any thoughts? Thanks very much everyone Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|