Add Excel to Word

October 01, 2021 - by Bill Jelen

Add Excel to Word

Problem: My co-worker is working on a report in Word. I need to add a table and chart to Word. I hate Word.

This image shows some text in Microsoft Word. Right after Paragraph two, you inserted an Excel workbook. The ribbon at the top of Word changes the the Excel ribbon as long as you are working inside the embedded Excel grid.
Figure 100. If you have to work in Word, it is better to have Excel.

Strategy: You can use the full power of Excel in Word. While you are typing the document, you can put all of the Excel ribbon tabs in the Word ribbon. Follow these steps:

  • 1. Place the insertion point where the table should start.

  • 2. Select Insert, Object. Word will display the Object dialog box.

  • 3. Choose Microsoft Excel Worksheet. Click OK. You now have Excel ribbon tabs at the top of Word!

  • 4. Build your worksheet in the frame. You can use the resize handles in the corner of the frame to make the worksheet as wide and tall as necessary.

  • 5. Consider using View, Show, and uncheck Gridlines. This will hide the gridlines when the worksheet is embedded in Word.

  • 6. Click outside the spreadsheet frame. The worksheet appears in Word.

Additional Details: It seems bizarre, but if you need to put a Word paragraph in Excel, you can use the same trick in Excel. Choose Insert, Object, Microsoft Word.

This article is an excerpt from Power Excel With MrExcel

Title photo by Adam Solomon on Unsplash

Bill Jelen is the author / co-author of:
Excel Dynamic Arrays Straight to the Point 2nd Edition

Fifteen months after Dynamic Arrays debuted for Office Insiders, the functions are being released to General Availability. This second edition of the book has been updated with new examples: see how Dynamic Arrays make XLOOKUP better. The chapter on the logic behind arrays has been expanded.