Excel Question. I simply want to convert a column of figures [each in
different cells] into a row with a similar number of cells. Must be simple,
but can't seem to find how to do it. Thanks for any replies, guys!!
Excel Question. I simply want to convert a column of figures [each in
different cells] into a row with a similar number of cells. Must be simple,
but can't seem to find how to do it. Thanks for any replies, guys!!
Select the cells in the column you want to paste in the row. copy (control
C). Select the same number of cells in a row, click Edit > Paste Special.
Select transpose. Click ok.
- Mangesh
"Lenworth" <[email protected]> wrote in message
news:[email protected]...
> Excel Question. I simply want to convert a column of figures [each in
> different cells] into a row with a similar number of cells. Must be
simple,
> but can't seem to find how to do it. Thanks for any replies, guys!!
And note that there only 256 columns in a sheet so you cannot transpose more
than that to a row.
Gord Dibben Excel MVP
On Fri, 20 May 2005 14:54:01 +0530, "Mangesh" <[email protected]>
wrote:
>Select the cells in the column you want to paste in the row. copy (control
>C). Select the same number of cells in a row, click Edit > Paste Special.
>Select transpose. Click ok.
>
>- Mangesh
>
>
>"Lenworth" <[email protected]> wrote in message
>news:[email protected]...
>> Excel Question. I simply want to convert a column of figures [each in
>> different cells] into a row with a similar number of cells. Must be
>simple,
>> but can't seem to find how to do it. Thanks for any replies, guys!!
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks