Insert Excel table in Word
Inserting an Excel spreadsheet in Word is child's play once you have the trick out. There are two different ways to copy your spreadsheet into Word. Read here where the differences are and what you need to consider in this process.
Insert the Excel table as an Excel table in Word
It is possible to copy an Excel spreadsheet into your Word document and have it linked to the source file. This means that further changes in the source file (Excel table) are also updated in the Word document. And this is how it works:
- Copy the table from your Excel document by selecting it and copying it with the key combination Ctrl + C or via the menu bar "Start" and "Copy".
- Now open your Word document and place the cursor where you want the Excel table to be inserted.
- Then, as shown in the screenshot, go to "Start" and click on the arrow under "Paste".
- An info box called "Insert content" opens. Place a checkmark in "Insert link:" and mark the first line "Microsoft Excel workbook object". Confirm the new setting with "OK". If you now make changes to the original Excel document, they will also be transferred to your Word table at the same time.
However, you should note that you can no longer make any changes to the content of the table using Word. The overall size of the table alone can still be changed - nothing can be changed in terms of style or font color or style. You have to solve this using the Excel document.
Insert Excel table as Word table
Here is the easiest way to take a spreadsheet from Excel to Word. This can be subsequently changed in terms of style and content in the Word document, but if you change something in the original Excel document, these changes will not be adopted in Word.
- Select the Excel table and copy it either with the shortcut Ctrl + C or the menu bar "Start" and "Copy".
- Place the cursor on the location of your Word page where you want the table to be later and then insert it with the keyboard shortcut Ctrl + V or by clicking on the clipboard above the "Insert" button in Word.
These instructions refer to Microsoft Word 2010 and Microsoft Excel 2010.