Export Word table to Excel

  • Thread starter Thread starter Cornelius Dale
  • Start date Start date
C

Cornelius Dale

I created a table in Word 2002 which I now want to export
to Excel 2002. I want to keep the cells of the table
intact in Excel so I can sort the table. How can I
accomplish this?
 
You can copy the table by the copy and paste method. Hold down Alt, double
click on any cell in Word to select the entire table, then hit Ctrl C to
copy. Open a new Excel workbook or sheet tab in an existing workbook; click
on cell A1 and hit Ctrl V to copy. Save your work before proceeding. You may
have to do some reformatting, and may have to rework any formulas that
appeared in the Word table. You will also have to adjust column widths and
row heights, wrap cells, fix number formats, etc.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Data From Excel to SQL 1
Seam-Excel error when exporting file 1
exporting images from table 1
How to Export Gmail Emails to PST Format? 4
Exporting Excel Tables 1
export/copy excel cells to Word 1
Word to Excel: Export comments with text and line number 0
Export Pivot table 1

Back
Top