How to insert an Excel file into a Word document?

How to insert an Excel file into a Word document?

Inserting an Excel file into a Word document saves you from having to copy and paste updated data. In fact, the integration allows you to create a link to the original data source. Therefore, the Word document is automatically updated when the data in Excel changes. That is how.

Credit: 123rf.com

How to link an Excel file to a Word document?

Linking an Excel file to a Word document works as a one-way link flow that brings up-to-date Excel data to that Word document. This allows you to reduce the size of the Word file, since the data is not saved there. If you want to insert any part of a spreadsheet into a Word document, here’s how to do it:

  • Open the Word document where you want to insert the spreadsheet.
Document_Word – © Credit: fredzone.org
Document_Word – © Credit: fredzone.org
  • Next, open the Excel spreadsheet that contains the data to insert it into the Word document.
Sheet_Excel – © Credit: fredzone.org
Sheet_Excel – © Credit: fredzone.org
  • In the Excel file, select and copy the range of cells to include. But if you later want to include new cells in the spreadsheet, the ideal would be to select the entire sheet. To select the entire sheet, simply combine the CRTL and A keys.
Data_Range_Selection – © Credit: fredzone.org
Data_Range_Selection – © Credit: fredzone.org
  • Now go to the Word file. There, place the cursor where you want to insert the Excel sheet. Right-click and click “Link and use target styles” or “Link and keep source formatting.” These are icons located in the “Paste Options” section.
Link_data_Excel – © Credit: fredzone.org
Link_data_Excel – © Credit: fredzone.org
Content_fichier_Excel_lié_au_Word – © Credit: fredzone.org
Content_fichier_Excel_lié_au_Word – © Credit: fredzone.org

It should be noted that this mode of operation has some limitations. In fact, if you want to move the Word file to another PC to use it, you should also move the Excel file with it. Similarly, data editing should only be done at the Excel spreadsheet level.

How to embed an Excel spreadsheet in a Word document?

The embedding process is pretty much the same as linking an Excel spreadsheet to a Word document. To do this, you can choose between two methods. You can choose to embed the spreadsheet as an object or insert a table.

Insert a spreadsheet as an object

  1. Open your Word document where you want to insert the spreadsheet. There, go to the “Insert” tab.
  2. Click on “Object” in the penultimate quadrant from left to right. You can directly click on the icon or press the arrow next to it and choose “Object”.
Document_Word – © Credit: fredzone.org
Document_Word – © Credit: fredzone.org
  1. A dialog box will be displayed after this manipulation. There, choose to click on the “Create from file” tab.
  2. Within this tab, select “Browse” and then choose the Excel spreadsheet you want to embed.
  3. Once done, click “OK”.
Incorporation_sheet_Excel – © Credit: fredzone.org
Incorporation_sheet_Excel – © Credit: fredzone.org
  • You have successfully embedded the Excel spreadsheet in the Word document.
Result_incorporation – © Credit: fredzone.org
Result_incorporation – © Credit: fredzone.org

READ ALSO: HOW TO ADJUST THE BRIGHTNESS OF YOUR COMPUTER?

Embed an Excel sheet as a table in Word

Through this method, you will be able to insert the spreadsheet following the same process as if you were embedding it as an object. The difference is that this will create a blank Excel spreadsheet to fill in. This method is more suitable if you have not yet created the Excel file. Here’s how to insert a spreadsheet as a table in a Word document.

So start by opening the Word document you want to embed the spreadsheet in and place your cursor where the sheet will be inserted.

  1. Next, click the “Insert” tab on the top menu.
  2. Click on “Table”.
  3. Now locate and choose “Excel Spreadsheet”.
Insertion_feuille_calcul_Excel – © Credit: fredzone.org
Insertion_feuille_calcul_Excel – © Credit: fredzone.org
  • A blank spreadsheet will open within the Microsoft Excel program. This gives you the opportunity to fill it in later with your data.
Excel_calculation_sheet_created – © Credit: fredzone.org
Excel_calculation_sheet_created – © Credit: fredzone.org

This method allows you to have an Excel file that you can update at any time. The data in the Word table is automatically updated to match the data in the Excel file.

#insert #Excel #file #Word #document

Leave a Comment

Your email address will not be published.