Columns in Excel display vertically instead of across the page.

P

panayoti

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
 
G

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
 
P

panayoti

Gord Dibben said:
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?
Click to expand...

Many thanks,
Pete
 
Top