 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / January 2007Copy/ Paste Problem
When I attempt to copy and paste a table from the internet into excel it automatically pastes the whol table into 1 cell. It is unreadable and in 1 long line. I must have switched a setting as I used to be able to paste a table from the internet and Excel would arrange the table into columns and rows. Does anyone know what setting I might have changed? Maybe... Close excel and reopen it. Then copy your table and paste it into excel. If that worked ok, then you can do the same thing by closing excel and reopening or... Put some text in an unused cell data|text to columns delimited by tab Then clean up that cell. Then try copy|pasting from the internets once more. > When I attempt to copy and paste a table from the internet into excel it > automatically pastes the whol table into 1 cell. It is unreadable and in 1 > long line. I must have switched a setting as I used to be able to paste a > table from the internet and Excel would arrange the table into columns and > rows. Does anyone know what setting I might have changed?  SignatureDave Peterson Did what you said, didn't work. It still pastes the whole table into 1 cell. Very wierd. Thanks for trying. > Maybe... > [quoted text clipped - 19 lines] > > table from the internet and Excel would arrange the table into columns and > > rows. Does anyone know what setting I might have changed? Maybe using Data|Import external data|New Web Query would work better? And an untested thought... If you paste into MSWord, you may get table that you can copy|paste into excel. Might be worth a try??? > Did what you said, didn't work. It still pastes the whole table into 1 cell. > Very wierd. Thanks for trying. [quoted text clipped - 26 lines] > > > > Dave Peterson SignatureDave Peterson It worked. It didn't copy the hyperlinks over just turned it all into text. No biggie. Thank you for the help. > Maybe using > Data|Import external data|New Web Query [quoted text clipped - 36 lines] > > > > > > Dave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.