Excel Table Import Word method rollup

In accomplishing some of the tasks above, we may need to import Excel tables into Word, I see many of the methods on the web, but they are useless or simple to replicate, but the copied forms are completely different from those in Excel. So how do we copy a table to copy the table in Excel correctly?

First, CTRL + C directly from the Excel table, and then CTRL + V in the Word document, it's just a table in Word format, and you can't use some advanced table functionality like Excel.

The method is very simple answer, here I use Word2003 to do demonstration for everybody.

First step, enter the Excel table, and then select the area you want to import into the Word document, press CTRL + C to copy;

Step two, open Word2003, then select Paste in edit on the menu bar, select Microsoft Office Excel Worksheet object under Form, and then determine;

At this point, the edited Excel table has been imported into the Word2003, some people will certainly say, this is not and word in the form is nothing but don't! Indeed, with the naked eye, it just looks good. What is the difference between this form and the form that is made in Word?

The difference must be some, do not believe you double click on the table to see what effect, yes, the imported table and Excel in the table is exactly the same, of course, this table can also be free to drag its long and wide, you can also use the formula in Excel!

Triple Recommendation: Click for free Download the latest version of WPS Office software "to see more computer tutorials

Excel table Import Word tool-camera

The tables that you design in Excel, the data you enter, need to be imported into Word, how do you make the form exactly the same as the original? How do you change the data in Word when the data changes in Excel? In fact, there is a very useful tool hidden in Excel--camera, using camera function, Can make the above goal perfectly possible.

① first need to find the camera. The default camera does not appear in the Excel toolbar (wonder, such a good tool, I let her hide stool that).

To open Excel, click in the following order: View-Toolbar-custom, which opens a custom toolbar dialog box. Click on the "Command" tab, find "Tools" from the "category" box on the left, and click on the "command" box on the right to list all the commands in the "Tools" name, and drag the scroll bar to find the camera (pictured).

Next use the left mouse button to click on the camera buttons, drag to Excel toolbar somewhere on the bar, let go, the camera button will always be placed here.

The use of ② cameras.

Now you can use the camera. Open the Excel table you designed, select the area where you want to import Word, and then click the Camera button on the toolbar. At this point, all the information has been copied to the Clipboard, in fact, can be in any form, text, picture editing software paste. But the most useful and achievable features are pasted into Word (the brethren of the same family).

The author here selected a ready-made table, pasted into Word, the effect is as follows:

What, does it look comfortable? As long as it's a table that's been designed in Excel, it doesn't go out of shape when you import word.

What are the characteristics of ③?

To import a table of Word with a camera, not a picture, but an object that contains all of the original table information in Excel, which you can manipulate in Word--change table size, border, shading, color, font, and so on, or in Excel's original table, with any changes to the original table. is updated to word in the first time, even if the result of a function operation is not exceptional.

Oh, yes, there is one more step to complete the above function. After pasting into Word, the Paste option button appears in the lower-right corner of the table, clicking on it and selecting "Keep Source formatting and link to excel", OK.

What about ④ without the paste option button?

Oh, this is a digression, but there is a version of Word does not have the Paste option button, in fact, is not, it is not obvious, say: open Word, tools-options-edit-show the Paste Options button.

Import Excel tables into Word

I can do the table directly in Word, but the table function is too simple. To make a table like excel in Word, you can only copy and paste Excel tables into Word, but if you are simply Ctrl + C and Crl+v, you'll only get a table that makes no difference to a word-made table. A friend who wants to import a fully functional Excel form in Word, follow me.

First, I need to open a Word document and an Excel table;

Next, I select the section in the Excel table that I want to import into the Word document, and press CTRL + C to copy it.

The third step is a key step, I go to Word, select Paste on the Edit menu below, select the form Microsoft Office Excel Worksheet Object in the dialog box, click OK, You can see that the Excel table you just copied has been imported into Word.

Although this method is a bit more than just pasting Excel, the Excel table that you import word has no difference from its original state, as you can drag to change the width of the cells in the table, and most importantly, you can use Excel formulas in this table.

Excel table import Word into multiple different envelope labels at one turn

An Address book form of Excel table has a lot of addresses, can be converted to the Envelope address label format of the file, and can print out an envelope address tag to send a letter. The last way I found it through "know": Word was used. First design the envelope format in Word, and then use the mail merge feature to be easy to implement. Set the Excel file name 1.xls,word file to 2.doc open 2.doc, tools-> Mail merge-> display mail Merge toolbar, click the Second button of the toolbar "Open Data Source", select 1.xls, then select the worksheet that you saved the content, Sixth button "insert Field , before the Word document moves the cursor to the bit you want to insert (such as "Mr."), choose to insert the name, and so on, and so on, add it all. When you're done, you can see the effect by looking at the merged data. But this printed envelope address tag is a single address above, how can you print out at the same time 4-6 different addresses? Can you arrange all hundreds of address labels at once? This is a good way to improve your work efficiency.

Best Answer

Insert field has next record, insert this field (show «next record»), and then insert the name and address, and so on, is the next name and address. So, you can insert several different addresses one page. Word defaults to the next record when the next page is