View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default How do I copy a word table into excel

Hi,

1. Save your Word document.
2. Select the entire table
3. Press Ctrl+H
4. Click More
5. Open Special and choose Paragraph Mark
6. Click Replace All
7. Click No to checking the rest of the document.
8. Copy the table
9. Move to Excel and Paste.
10. Close the Word document without saving.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"KF" wrote:

I'm trying to copy a word table (contains multiple paragraphs) into excel but
excel breaks each Word cell into several rows.

Is there a way to copy a Word table into Excel cell by cell.