Often users of Microsoft Office applications need to transfer a spreadsheet with numerical data created in an MS Excel spreadsheet to a MS Word text file editor document. For example, you prepare a progress report document in Word, and form digital readings in Excel in the form of a table, and you need to insert this table into the report text in Word. Often many people try to manually create a table in a text document (Word gives this opportunity) and transfer data from Excel cells to the table manually in Word. But it will still be more correct to transfer the table already prepared in Excel to the text in Word. At the same time, many not too experienced users have a question about how to transfer the table from Excel to Word. Consider the possible answers to this question in more detail.
Simple Copy Method
It would seem that the solution to the question of how to insert an Excel into a word lies on the surface. It is enough in Excel to select the table area you want to paste, select the "Copy" command on the toolbar, the table will be saved in the clipboard, then go to the document in the Word, put the cursor in the place where the table should be pasted, and click "Paste" . A table will appear in the Word document from the
clipboard , and all the data that was in the cells in Excel will also be copied and pasted, the job is done. However, in reality, as a rule, everything happens a little more complicated. After all, as a result of the usual “Copy / Paste” actions, tables from Excel are simply ugly inserted into the Word: the sizes of the wide table can significantly go beyond the text page of the Word, and the data format in the cells as a result differs from the text format in the Word. Therefore, the task - how to transfer the table from Excel to Word - should be performed somewhat differently.
Insert a table into a text document as a graphic object
Consider copying a table to a word as a graphic object. It should be noted that the Excel table in Word will be inserted as a picture, that is, when editing data in the cells of the original table in Excel, the table inserted in the form of a picture in the Word will not change. The advantage of this method is that such a drawing table can be moved within the document, freely copied and pasted in the same form to another place in the text, and resized if necessary. There are some nuances of this method, which vary depending on which version of MS Word you have installed.
How to transfer a table from Excel to Word version of MS Word 2003
Move the cursor to the place of the text where you want to insert the table. On the toolbar in the "Insert" pop-up menu, select the "Object" command. In the dialog box, you need to click "Create from file" and by clicking the "Browse" button, select the exel file in which the original table prepared for the transfer is located. Next, click "Ok." As a result, the table from the file will be inserted into your text document as a graphic object.
MS Word 2007
Next, we will tell you how to transfer a table from Excel to Word if you are using the 2007 office suite version. We also place the cursor in the text in the right place. On the top toolbar, select the "Insert" tab, find the "Insert Object" button in the "Text" subsection and select the "Create from File" tab in the dialog box. Further, also through the "Overview", open the desired Excel table and click "Ok".
Linking tables in Excel and Word
How to transfer excel to Word so that the data in the cells of the table inserted into the document in the Word automatically changes if it is planned to frequently update the data in the cells of the original table in Excel. You can use the method of linking tables when pasting from Excel to text in Word. To do this, you must first copy the desired table in the Excel
file. Further in the Word, being the cursor at the place you want to insert, on the toolbar in the "Home" tab, select the "Paste Special" command, switch to the "Link" item, in the "How to" window, select "Microsoft Excel worksheet (object)". As a result, the related insertion of the table will occur. When you double-click on a table in Word, there will be an automatic transition to this table in Excel, and editing will appear. Also, if necessary, it will be possible to forcefully update the data in the cells, for this you need to right-click on the table in the Word and select the "Update Communication" command.
When choosing this method, you need to consider one important point. In the event that the structure of the linked table subsequently changes (for example, the number of rows is changed, columns are deleted, etc.), then in the transferred table in Word its integrity will be violated, it will simply “float”. Therefore, it is important that the source table in Excel be compiled before copying and linking with clearly defined sizes - with a specific number of cells (columns and rows), and only after bringing the table to the required form can we start copying and pasting by linking. Now you know how to transfer excel to Word.