Easy Ways to Insert Microsoft Word Files into Excel
There may be times when you need to add a Word document to a Microsoft Excel spreadsheet, whether it’s an image, a table or a full document. Fortunately, the process is easy and can be done quickly. Here’s how:
Step 1: Open the Excel file where you want to insert the Word document
Open the Excel file where you want to insert the Word document. On the “Insert” tab, select “Object” in the “Text” group; this will open the “Object” dialog box. Select “Create from file” and click on “Browse.”
Step 2: Browse for the Microsoft Word File
Locate and select the Word file that you want to insert, and click “OK.”
Step 3: Set your Word Document Display Preferences
If you want the Word document to display as an icon, select “Display as icon” from the “Object type” box. Then select the display icon from the “Icon” list. If you want the document to display as an image, select “Display as icon” and “Change icon.” After that, choose the preferred image from the available options.
Step 4: Link or Embed the Word Document
You have the option to link or embed the Word document. Linking the Word document into the Excel sheet is advisable when the Word document undergoes changes frequently. In this case, the changes automatically update on the Excel sheet. To link the Word document, select “Link to file” option in the “Object dialog box.”
On the other hand, embedding a Word document into an Excel sheet is useful when portability is paramount. With an embedded document, you’ll only need to move the Excel sheet without worrying about the Word document’s location. To embed the Word document, select the “Embed” option in the Object dialog box. Once you’ve selected the appropriate option, click “OK.”
Step 5: Arrange the Word Document
You can adjust the size of the document to fit your preferences by clicking and dragging the Word document to fit your preferred space on the Excel sheet.
Inserting Excel Data into Your Word Document
There are also times where you need to insert Excel data into your Word document. Here’s how to do this:
Step 1: In Word, click where you want the Excel data to be inserted.
Be sure to place your cursor at the exact point where you want the data to be inserted.
Step 2: In Word, click on “Insert” tab, then “Object.”
This will open the “Object” dialog box. You’ll see a few tabs at the top of the box. Select the “Create from file” tab.
Step 3: Locate the Excel File
You can easily locate your Excel file by clicking the “Browse” button. Once you’ve found the Excel file, click “OK.”
Step 4: Adjust Your Excel Data Display Preferences
You’ll see a few display options. You can choose to either embed the Excel sheet into the Word document or link to the Excel document.
If you choose the “Link to file” option, the Excel data in your Word document will not be static (unless it is saved as a PDF). If the source Excel file changes in any way, some changes may not be apparent when viewing the Excel data in the “Insert Object” window. However, when you click “OK,” your original Excel sheet will be linked to the Word document.
If you choose the “Embed” option, the entire Excel sheet will be added to the Word document and edits made in Excel will not carry over to the Word document automatically. However, embedding an Excel document creates a “snapshot” of that Excel file within your Word document, meaning you can present a specific Excel sheet as a report within a larger document.
Step 5: Modify Your Excel Data and Save the Changes
You can modify the size of the embedded Excel sheet by dragging either its right border or its bottom edge accordingly. Make sure any formatting changes are complete before saving your documents.
Note that any changes made to the original Excel sheet will not appear in the Word document if you choose the “Embed” option. To incorporate any changes you made to the original Excel sheet, you must delete the embedded worksheet from your Word document and start over at Step 1, with an updated version of the Excel document.”
FAQ
Question 1: Can you add multiple Word documents to an Excel file?
Answer: Yes, you can add multiple Word documents to an Excel file following the same process mentioned above for individual documents. Make sure to select “Insert Object” for each document and follow the aforementioned steps.
Question 2: Can you insert Excel data into a Word table?
Answer: Yes, you can insert Excel data into a Word table by following these steps:
- Select the cell or cells that you want to link to Excel.
- Click the “Insert” tab and then click “Table.”
- Select “Excel Spreadsheet” and select the “Create from File” tab. Browse for an Excel file.
- Use the available options to choose the data that you want to display, such as formatting and more.
- Click “OK” when done.
Video Tutorial
To learn more about inserting Word documents into Excel, check out this video tutorial:
