Question

Insert Excel table into Word - this is how it works

Answer 1

Insert Excel table into Word document
Link Word document with Excel table
1st step:
2nd step:
3rd step:
Brief instructions: Linking a Word document with an Excel spreadsheet

---

Would you like to insert an Excel table in Word or even link both documents? We'll show you how it's done..

There are two ways you can paste an Excel spreadsheet into a Word document: either you just copy the spreadsheet, or you create a link. In this case, you can continue to edit the Excel table and all changes made are automatically adopted in the Word document. In the following we explain both options to you:

• Insert Excel table into Word document
• Link Word document with Excel table

Insert Excel table into Word document

If you just want to paste a created Excel spreadsheet into a Word document, that's quick and easy: Simply mark the crucial part and copy the spreadsheet with the key combination [Ctrl] + [C] or with a right-click -> "Copy" " . Then go to the Word document and click where you want to insert the table.

Then use the key combination [Ctrl] + [V] or right-click -> "Paste" . The Excel table has now been inserted into your Word document. You can edit them there, but Excel functions are not available to you.

Link Word document with Excel table

If you don't just want to transfer your Excel spreadsheet into a Word document, you can also create a link between the two files. Then any changes you make in the Excel spreadsheet will also be transferred to your Word document.

Follow our step-by-step instructions or take a look at the brief instructions ..

1st step:

Move the Excel spreadsheet to the clipboard by selecting them Mark and then the key combination [Ctrl] + [C] key. Alternatively, you can right-click and select " Copy " from the menu .

2nd step:

Now go to the Word document and click where you want to insert the Excel table. Then click on " Insert " on the far left under the " Start " tab . Select " Insert content ... " from the drop -down menu .

3rd step:

To create a link between the Excel table and the Word document, select " Insert link " on the left and select " Microsoft Excel workbook object ". Confirm your settings with " OK ". The Excel table will then appear in your Word document. All changes that you make to the table in Excel and save are automatically updated in your Word document. Note: Changes that you make to the table using Word are not transferred to the original Excel table. Only changes to the source file in Excel are updated.

Brief instructions: Linking a Word document with an Excel spreadsheet

1. Move the part of the Excel table that you want to link with your Word document to the clipboard ( highlight -> [Ctrl] + [C] ).
2. Now switch to the Word document and click where the table should be inserted.
3. Then go to " Insert " under the " Start " tab and select " Insert content ... " from the menu .
4. Now mark " Insert link " on the left and select " Microsoft Excel workbook object ". Finally click on " OK " and the Excel table will be inserted as a link in your Word document. Changes that you now make in Excel are automatically adopted in Word - but not the other way around.

---