One of the benefits of using an office suite like Microsoft Office is that the programs in the suite all interact with each other well. For example, you can easily embed an Excel worksheet into a Word document and be able to edit the spreadsheet in Word.

Note that even though the screenshots below are from an older version of Word, the same procedure will work on all versions of Word, including Word 2016, 2013, 2010, etc.

Insert Excel Spreadsheet into Word

To embed a new, empty Excel spreadsheet into Word, put the insertion point where you want to embed the spreadsheet in your Word document. Click the Insert tab on the ribbon.

Clicking the Insert tab on the ribbon

In the Text section of the Insert tab, click the Object button.

Clicking the Object button

The Object dialog box displays. On the Create New tab, select Microsoft Office Excel Worksheet from the Object type list and click OK.

Selecting Microsoft Office Excel Worksheet as the object type

A blank worksheet is inserted into Word at the insertion point and activated. You can enter data into this worksheet just as you would if you were working in Excel. The ribbon bar changes from the Word ribbon to the Excel ribbon, providing you with the Excel tools.

Excel ribbon in Word

To get the Word ribbon back, click anywhere in the Word document off the embedded Excel worksheet. To edit the embedded Excel worksheet again, double-click on the embedded object.

You can accomplish the same task using an existing Excel worksheet, embedding a worksheet containing data into a Word document. To do this, first click off any other embedded Excel spreadsheets you may have already inserted to get the Word ribbon back.

Put the insertion point where you want to insert the existing Excel worksheet. Make sure the Insert tab on the Word ribbon is active and click the Object button again. This time, click the Create from File tab. Click the Browse button.

Object dialog box - Create from File tab

On the Browse dialog box, locate the Excel spreadsheet file you want to insert, select it, and click Insert.

06_selecting_excel_file

The path to the selected file is inserted into the File name edit box. Click OK.

File path inserted

The example table from our sample Excel worksheet file is inserted at the insertion point and activated. Again, the Word ribbon becomes the Excel ribbon while you are editing the embedded Excel worksheet. When you click off the worksheet object, the Word ribbon returns.

Editing inserted Excel table

You can also embed Excel worksheets in PowerPoint presentations, which is useful to easily display charts and graphs generated in Excel in your presentations. Enjoy!