free online microsoft training

Free tips and tricks for using Microsoft Office and Windows

Embed an Excel worksheet within your Word document

Print Friendly, PDF & Email

Whenever I run Excel or Word training a common question pops up. What is the best way to add Excel data into a Word document? Like many things related to Microsoft Office, there are several different ways to achieve this. There are several benefits from being able to embed an Excel worksheet into your Word document. Firstly you remove the need to copy & paste the updated data as embedding will allow you to the link to the original data source. Secondly, it allows you to use all the usual Excel functions, all within a Word document.

Embed an existing worksheet

Today I will show you one way to embed an existing Excel worksheet into a Word document.

  1. Open the Microsoft Word document you wish to include the Excel data within
  2. Place your cursor in the position you wish to add the Excel content

Embed Excel in a Word Document

  1. Click the Insert tab and select the Object button which is located within the Text group of icons
  2. The Object dialog box will appear:

Embed Excel in a Word Document

  1. Here you have two options, the first tab called Create New, allows you to embed a new object which will allow you to enter any information you require, the second tab, Create from File, allows you to embed an existing file. You can also link to the existing file which allows updates to filter through into your document.
  2. Select the Create from File tab
  3. Click the Browse button
  4. Navigate and locate the Excel worksheet you want to embed

Embed Excel in a Word Document

  1. Click Insert
  2. You will now see the file path and file name displayed in the File name box

Embed Excel in a Word Document

To link or not to link

There are two options provided when embedding an object. The options include Link to file and Display as icon.

The Link to file checkbox allows you to insert the content of a file into your document and create a link to the original file. If the original file is updated, the changes will appear in your document.

The Display as icon allows you to have the file embedded but displayed as a simple Excel icon within the document rather than the actual file content.

  1. Choose any additional options to link the file or display as icon then click OK
  2. The Excel data should now be displayed within the Word document

Embed Excel in a Word Document

  1. The embedded Excel worksheet is editable by double-clicking on the data
  2. You can also resize the data to fit neatly within your document
  3. Your Excel data is now embedded within the Word document
  4. Save your document (Ctrl + S) (click here for a list of great keyboard shortcuts for Word)

Now be sure to take a look at the other Word and Excel articles. Comment below with your questions.

Share on facebook
Facebook
Share on google
Google+
Share on twitter
Twitter
Share on linkedin
LinkedIn
Share on pinterest
Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *

7 + 19 =

This site uses Akismet to reduce spam. Learn how your comment data is processed.