Go: Excel table converted to Word

We often encounter this situation in the work, sometimes in Excel to edit the good document, want to put the data inside the word in the intact. The most common use is in the way of replication, but the method of copying can move the data to the past, but it will confuse the formatting in Excel. Copying the past will be messy, there is no overall sense, if you re-adjust the format, not only time-consuming and laborious, then we have to consider how to convert the Excel document into Word format.

Baidu Experience: jingyan.baidu.com

Tools/Materials

• word2007

• excel2007

Baidu Experience: jingyan.baidu.com

Method/Step

2. 1

   First we open the Excel document that we need to convert to Word, the document we need to convert to Word, and we can see that there is a Microsoft Office icon in the upper-left corner of the table, and click the Icon drop-down option.

   
   
4. 2

   In the dropdown option we move the mouse over the "Save as" and drop down again, and then we click the "other Format" button.

   
   
6. 3

   When clicked, the dialog pops up and we click on the small inverted triangle after "save type" and click the drop-down option, then we click on "Single File page (*mht:*mhtml)" in the dropdown option.

   
   
8. 4

   When clicked, we select the "SELECT (E) sheet" option at the rear and click the "Save" button below.

   
   
10. 5

    After clicking the "Save" button, we launch the Excel worksheet and then go to the document that we just saved as "single File page (*mht:*mhtml)" and then select the file, and then right-click to see what happens.

    
    
12. 6

    Right-click after we move the mouse to "open with" and then drop down options, in the dropdown option we select "Microsoft Office Word".

    
    
14. 7

    When you click to open the worksheet, we have clicked the Microsoft Office icon in the upper-left corner of the worksheet, moved the mouse to save as, and selected Word document in the drop-down option.

    
    
16. 8

    Click will pop up the dialog box, when we want to change the file name, you can directly in the "file name" in the input box after entering the file name you want to change, but remember, the rear "docx" can not delete Oh! Once the modification is complete, click on the "Save" button directly below.

    
    
18. 9

    After clicking the "Save" button, we will find that it has been saved as Word type, open the document, you can see that the format is not changed, or the same as in Excel. Similarly, if Word is to be converted into an Excel document format, this method is also possible!

    Transferred from: http://jingyan.baidu.com/article/4dc4084887d6bbc8d946f1c7.html

Go: Excel table converted to Word