vertical columns won't paste office excel2007

May 18, 2011 at 11:16:40
Specs: Windows 7
copied from 3 vertical columns on a webpage but when pasting it goes horizontal in a continuous line of data..

See More: vertical columns wont paste office excel2007

Report •

May 18, 2011 at 11:27:22
Blame the's how it was designed.

You can try pasting it as text, but you still might have to do a Data...Text-To-Columns and then Copy/Paste Special - Transpose once it's in the spreadsheet.

I've seen some pretty strange things happen when pasting from a website into a spreadsheet...including having rows of data show up that weren't even visible on the web page.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

May 18, 2011 at 11:44:31
well I was ultimately able to paste into a Notepad document, clean it up a bit, and then it pasted into excel... thanks for your response~!

Report •

Related Solutions

Ask Question