Columns in Excel display vertically instead of across the page.

[Guest]

When I copy data from a web site and try to paste it into Excel, the
spreadsheet displays the data vertically down the sheet, not horizontally
across the sheet. I've tried formatting cells using the alignment options,
but to no avail. Help!!

Thanks,
Pete

 

[Gord Dibben]

Any website or a particular one you have in mind and could direct us to so's we
might test the copy/paste issues?


Gord Dibben MS Excel MVP

 

[Guest]

Any website or a particular one you have in mind and could direct us to so's we
might test the copy/paste issues?


Gord Dibben MS Excel MVP




I copied from my watch portfolio on yahoo finance......there are five columns that display....trade, symbol, change, %change, and name. When I copy them and try to paste into Excel, they display in column A of the spreadsheet vertically down the page instead of the way they are displayed in yahoo ( left to right and down the page vertically). When I tried all 3 paste special options, the text option works the best, though the data needs two rows to display. As you suggest, it is probably best that you "see" the data. Could I send you the link that shows you what I'm talking about?

Many thanks,
Pete

 

[Gord Dibben]

Copy and paste the link into your next reply.


Gord

Many thanks,
Pete

Gord Dibben MS Excel MVP