| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Copy/ 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? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Copy/ Paste Problem
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. DanielSP wrote: 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? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Copy/ Paste Problem
Did what you said, didn't work. It still pastes the whole table into 1 cell.
Very wierd. Thanks for trying. "Dave Peterson" wrote: 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. DanielSP wrote: 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? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Copy/ Paste Problem
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??? DanielSP wrote: Did what you said, didn't work. It still pastes the whole table into 1 cell. Very wierd. Thanks for trying. "Dave Peterson" wrote: 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. DanielSP wrote: 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? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Copy/ Paste Problem
It worked. It didn't copy the hyperlinks over just turned it all into text.
No biggie. Thank you for the help. "Dave Peterson" wrote: 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??? DanielSP wrote: Did what you said, didn't work. It still pastes the whole table into 1 cell. Very wierd. Thanks for trying. "Dave Peterson" wrote: 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. DanielSP wrote: 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? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wierd Copy and Paste | Excel Discussion (Misc queries) | |||
| How to copy & paste excel charts to Words as Windows Metafile | Charts and Charting in Excel | |||
| copy paste problem? | Excel Discussion (Misc queries) | |||
| change from copy & paste task pane (yuk) to c&p little box | Excel Discussion (Misc queries) | |||
| Can't Copy and Paste foumulas? | Excel Discussion (Misc queries) | |||
Hybrid Mode
