close

I have numbers arranged in a column that I need to put in another application
by copy and paste. The other app only accepts data arranged in a row with a
maximum of 25 at a time. How do I convert the column into a row in excel so I
can copy and paste in a group of 25 instead of one at a time?

Thanks
Bob

You can copy and paste special gt; transpose. That should work.
Alternatively there is a TRANSPOSE command built in to excel.Hi S Davis,
I tried it . It works but numbers briefly flash and then cells go blank!

Bob

quot;S Davisquot; wrote:

gt; You can copy and paste special gt; transpose. That should work.
gt; Alternatively there is a TRANSPOSE command built in to excel.
gt;
gt;

Try ticking 'values' as well, and pasting it into a seperate sheet.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()