Copy and paste the link into your next reply.


Gord

On Mon, 4 Dec 2006 20:46:00 -0800, panayoti
wrote:



"Gord Dibben" wrote:

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


On Sun, 3 Dec 2006 10:31:00 -0800, panayoti
wrote:

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

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 MS Excel MVP