Word and Excel table interchange how to get

are the tables in Word and Excel trying to exchange each other so hard? is not simple copy, paste can be done? Yes, a simple table is absolutely fine, but a table with function formulas is not easily copied or pasted.

To solve the above problems, a simple way is through the form of a Web page to relay. First, make any table in Excel.

then click "file → save As → browse".

In the Open Save dialog box, select the Save type as a single File Web page (*.mht;*.mhtml) and click Select (E): sheet below.

After you click Publish, if you have more than one table in the workbook, you can select it in the Open Publishing window, or you can specify a range of cells for the table. The bigger advantage of this approach is that it can export all the tables in the entire workbook at once.

In the previous step, if you check the "open a published page in the browser" below, click the "Publish" button to automatically start the browser, open the published form page. If you chose to export the entire workbook in the previous step, you can see multiple labels such as Sheet1 below the page.

In the Web page, press CTRL + A to select the full table, then press CTRL + C to copy, and then press CTRL + V in Word to paste it. This will maximize the original state of the table, eliminating the hassle of a realignment.

The above process is the same in turn. The forms that you make in Word are also saved by the "file → Save As → Browse" command, in the "Single File Web page (*.mht;*.mhtml)" format, then open in the browser, and then pasted into Excel after copying.

However, it should be noted that the resulting web page files, need to be in the Microsoft IE browser to open normally. Other browsers, based on Chrome, may not display the table properly.