How To Add Excel File In Word



Post updated on : May 2020

  1. How To Add Excel File In Word 2010
  2. Where Is Insert Object In Excel
  3. How To Insert Excel File In Word 2019
  4. How To Add Excel File In Word 2016

Adding other files into Word. So far, we have learnt how to embed Excel workbooks and ranges into Microsoft Word. That said, you are able add additional file types into your document, such as: Presentations, diagrams and another documents. Read further for ta simple example: Open your Word document. In the Ribbon, hit the Insert tab and select. The embedded spreadsheet was inserted by selecting and copying in excel and then using 'past special' in word ('paste' checkbox rather then 'paste link') and pasting it as an 'MS Excel Worksheet Object'. The effect is repeatable in the new document. In Office 97, this can be done since the editing is in place and you can expand the viewed area.

Applicability: Excel 2019, 2016 and earlier versions; Windows 7, 8& 10 and macOS.

Here’s a question from Dana:

Working on a quarterly operational report for management. I have a nice spreadsheet with some sales information that i would like to insert into a Word document that i am authoring. Any ideas?

Thanks for the question, Dana. See below for the details. I assumed you are using Windows, but just in case, i have added some pointers for MAC users below.

If you are looking at inserting Word files into Excel, take a look at our tutorial on embedding Word objects into a spreadsheet.

The entire step-by-step details can be found in the following video we created:

Embed an Excel table in Word

Note: This option will allow you to embed a screenshot of your spreadsheet, which you won’t be able to later on edit/modify. For a “live” spreadsheet option, kindly scroll down.

  • Open your Excel document.
  • Select the area / range that you would like to add into Word, right click and hit Copy or press CTRL+C.

How To Add Excel File In Word 2010

  • Now, go ahead and open the Word document in which you would like to insert the Excel range, then right click and hit paste or go ahead and press CTRL+V.

Embed a “live” spreadsheet in Word

Where is insert object in excelExcel
  • Open your Word document, where your Excel spreadsheet has to be placed.
  • Click on the Insert in the ribbon and select Object in the Text section.
  • Select the Create from file and browse to your excel document which has to be inserted.
  • Click OK.

Insert Excel file as an attachment

In a similar fashion you can embed a link to your Excel file into your Word document:

  • Navigate to the place in your document that you want to place the link to your workbook.
  • Hit Insert.
  • Then select Object.
  • Using the Browse button , navigate and point to the file stored in your computer that you would like to attach.
  • Then hit the Link to File and Display as Icon checkboxes, to embed a link to your file into your doc.
  • Hit OK.

Edit an inserted Excel range in Word

  • In your Word document, double click on the Excel table you inserted before.
  • Adjust the range height and width to fit your table into your Word page and edit the content as needed.

Adding other files into Word

So far, we have learnt how to embed Excel workbooks and ranges into Microsoft Word. That said, you are able add additional file types into your document, such as: Presentations, diagrams and another documents. Read further for ta simple example:

Add

Where Is Insert Object In Excel

  • Open your Word document.
  • In the Ribbon, hit the Insert tab and select Object.
  • In the Create New option, pick the required Object type to embed into your Word document.
  • In our case, we’ll go ahead and insert a PowerPoint presentation.
  • Once, you select the object you would like to insert, hit OK.
  • Now we can edit with the new presentation slide embedded in Word 2016.

Inserting spreadsheets in Word for macOS

If you are using Word fin your MAC, you can insert existing spreadsheets into your documents as well. Procedure is similar to the one we outlined before for Windows.

  1. Open Microsoft Word and navigate to your document.
  2. Pick the location into which you would like to add your spreadsheet content.
  3. Hit Insert, and select Object.
  4. The following dialog will be opened:

How To Insert Excel File In Word 2019

  1. Hit From file… and select the Excel workbook that has the content you would like to embed.
  2. Hit Insert.
  3. Now go ahead and adjust the placement, height and weight of your embedded worksheet.
  4. Once done, save your spreadsheet (File>>Save or Command + S).

How To Add Excel File In Word 2016

Note that on Word for MAC OSX you are not able to embed “live” PowerPoint Presentations ; however you can embed other documents into your Word files.