No matter whether Microsoft Word or Excel, they work as necessary in our daily work and study. But some users want to make their Word has as professional a display as Excel to show their work. So is that possible to finish? Of course yes. this article on MiniTool Website will show you how to insert Excel into Word.
Insert a Chart from an Excel Spreadsheet into Word
To insert Excel into Word, the easiest way is to copy and paste. You even can redesign and update the chart without leaving Word and if the data on Excel changes, the Word will follow.
Step 1: You can use the shortcut – Ctrl + C – to copy the chart.
Step 2: Click on the place you want to create the chart and then press Ctrl + V.
To update the chart
Step 1: Choose the chart in Word and then Chart Design.
Step 2: Click on Data and then Refresh Data.
To edit the chart
Note: If your chart is inserted as a picture, you are not allowed to edit it but only adjust it by Picture Format.
Step 1: Choose the chart in Word and in Chart Design, choose Data, and then Edit Data.
Step 2: Then you are allowed to edit the data in Word or Excel.
Link or Embed Excel to Word
Before we start this guide, you can be clear about the difference between linked objects and embedded objects.
Linked objects can be the first choice recommended for it can update with the modified data source while embedded objects won’t change anymore even when you modify the data source.
Link an Excel Worksheet
To link Excel to Word, you can do it as follows.
Step 1: Click on the place where the worksheet will display in Word and in Excel, select and copy the cell range.
Step 2: Go to Word and right-click to choose Link & Use Destination Styles or Link & Keep Source Formatting from the drop-down menu.
There is something you need to pay attention to.
- If the Excel file moves, the link to the Word document needs to be re-established.
- If you want to transport the Word file, you must transport the Excel file along with it.
Embed an Excel Worksheet as an Object
To embed an Excel spreadsheet in Word as an object, you can do it as follows.
Step 1: In the Word document, go to the Insert tab and choose Object and then Object again.
Step 2: Choose Create from file and then Browse.
Step 3: Choose the file you want to insert into the Word document and choose Display as icon and select OK.
Embed an Excel Worksheet as a Table
To insert the Excel worksheet as a table, you can follow the next steps.
Step 1: Open your Word document and place the cursor where you want to insert the Excel worksheet.
Step 2: Go to the Insert tab and click on Table.
Step 3: Choose Excel Spreadsheet from the drop-down menu.
Then you need to fill this blank chart by entering or pasting data from another spreadsheet.
Bottom Line:
This article has a detailed description of inserting Excel into Word and you can follow the above methods to finish your planned work. To do that, your Word document will look more professional.
User Comments :