Whenever I run Microsoft 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. Today I will show you one way to embed an existing Excel worksheet into a Word document.
- Open the Microsoft Word document you wish to include the Excel data within
- Place your cursor in the position you wish to add the Excel content
- Click the Insert tab and select the Object button which is located within the Text group of icons
- The Object dialog box will appear:
- 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
- Select the Create from File tab
- Click the Browse button
- Navigate and locate the Excel worksheet you wish to include
- Click Insert
- You will now see the file path and file name displayed in the File name box
- There are two additional options within the dialog box: the Link to file check box 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 will be displayed as a simple Excel icon within the document rather than the actual file content.
- Click OK to embed the Excel file within the document
- The Excel data should now be displayed within the Word document
- The embedded Excel worksheet is editable by double-clicking on the data
- You can also resize the data to fit neatly within your document
- Your Excel data is now embedded within the Word document
- Save your document (Ctrl + S) (click here for a list of great keyboard shortcuts for Word)
If you have any questions, please contact me. If you have not yet subscribed to my monthly newsletter you can do so here.