Insert an Excel Spreadsheet into a Word or Powerpoint Documents [2010,2013]

Can you believe that with all the articles I’ve written to this site, I’ve yet to do one specific to Word? Which is ironic, given I write and publish most of the articles from Word.

There is of course a logical reason for that – it’s just not a tool I use as much as other applications.

And, you’ll be comforted to know, this article isn’t a complete departure from my more frequent Excel related articles!

(I’ve written the article based on using Word, but the exact same approach is valid for Powerpoint as well)

Embedding Excel worksheets in Word:

If you have some information you want to display in tabular form, you may begin by inserting a table/grid from Word.

INSERTàTABLE

And entering your data from there.

And this isn’t a bad option for ‘static’ data, especially as there is now a wealth of easy-to-apply formatting options – just take a look through the ‘TABLE TOOLS’ group of tabs

But what if you want to leverage the full (pretty much) toolset of Excel? Formulas, Charts, Formatting etc?

It’s very easy. INSERTàTableàExcel Spreadsheet

This will add a ‘Spreadsheet’ object to your Word document

When selected, you should see that the toolbars change to the Excel toolbars, given you access to most feature of Excel right there in Word / Powerpoint

Work with your data as normal. When you’re done you’ll want to resize the window to show only the columns / rows you want Word to display. Or hide the surplus rows / columns as normal.

Once you click outside the Excel object, all the Excel edit tools will disappear leaving just your data

To carry on editing the Excel object, simply double-click the table.

You’re not limited to just entering data of course. Here, I’ve created a chart just as I might in Excel.

There’s little limit on what you can do. I use it to better show my Skills Matrix.