Often, users of Microsoft Office applications need to transfer a large-format spreadsheet with numerical data created in an MS Excel spreadsheet to a text file editor in MS Word. For example, you prepare a paper for the report on the work done in the Word, and form the digital indications in the Excel as a table, and you need to insert this table into the text of the report in the Word. Often, many people try to manually create a table in a text document (the Word gives this possibility) and data from Excel cells can also be transferred to the table in the Word manually. But more correctly still will transfer already ready in an Excel table in the text in a Word. At the same time, many not very experienced users are faced with the question of how to transfer the table from the Excel to the Word. Consider the possible options for answering this question in more detail.
Simple copying method
It would seem that the solution to the question of how to insert an excel into a Word is on the surface. It's enough to select the area of the table you need to insert in the excel, select the command "Copy" on the toolbar, the table will be saved in the clipboard, go to the document in the Word, place the cursor on the place where the table should be inserted, and click "Paste" . In the Word document, a table appears from the clipboard , and all the data that was in the cells in the Excel will also be copied and pasted, the work is done. However, in practice, as a rule, everything happens a little more complicated. After all, as a result of the usual "Copy / Paste" actions, tables from the Excel are inserted into the Word simply "ugly": the size of the large-format spreadsheet can drastically exceed the boundaries of the text page of the Word, and the format of the data in the cells ultimately differs from the text format in the Word. Therefore, the task - how to transfer the table from the Excel to the Word - should be done somewhat differently.
Inserting a table into a text document as a graphic object
Consider the option of copying a table into a Word as a graphic object. It should be noted that the Excel spreadsheet into the Word will be inserted as a picture, that is, when you edit the data in the cells of the source table in the Excel, the inserted table in the Word does 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 of text, changing the size of the drawing, if necessary. There are some nuances of this method, differing depending on what version of MS Word you have installed.
How to transfer the table from Excel to Word 2003 version of Word
Point the cursor at the place of the text where you want to insert the table. On the toolbar in the drop-down menu "Insert" you must select the "Object" command. In the dialog box, click "Create from file" and click on the "Browse" button to select the excel file in which the original, prepared for the transfer table is placed. Then click "Ok". As a result, a table from the file will be inserted into your text document as a graphic object.
MS Word 2007
Next, we'll tell you how to move the table from Excel to Word if you use the 2007 Office suite version. Also, place the cursor in the text in the right place. On the top toolbar select the "Insert" tab, we find the "Insert object" button in the "Text" sub-section and select the "Create from file" tab in the dialog box. Further, also through the "Browse" open the desired spreadsheet and click "Ok".
Linking a table in Excel and Word
How to move Excel to Word, so that the data in the cells inserted into the document in the Word of the table automatically changed, if you plan to frequently update the data in the cells of the source table in the Excel. You can use the method of linking tables when inserting from the Excel into the text in the Word. To do this, you first need to copy the required table in the excel file. Next, in the Word, using the cursor on the insertion point, select the "Special Paste" command on the toolbar in the "Home" tab, switch to "Link", and select "Microsoft Excel sheet (object)" in the "How" window. As a result, a related insertion of the table occurs. Double-clicking the mouse on the table in the Word will automatically switch to this table in the Excel, you will be able to edit. Also, if necessary, you can forcefully update the data in the cells, you need to right-click on the table in the Word and select the "Update link" command.
When choosing this method, one important point needs to be considered. In the event that the structure of the linked table will subsequently change (for example, the number of rows will be changed, the columns will be deleted, etc.), then in the transferred table in the Word its integrity will be violated, it simply "floats". Therefore, it is important that the source table in the Excel before the copying and linking is composed with clearly defined sizes - with a specific number of cells (columns and rows), and only after the table is brought into the required form, you can start copying and pasting by binding. Now you know how to move an Excel to a Word.