Excel Tip. How To Embed An Excel Table Into A Word Document.


Hello, and welcome back to another #Excel Tip. Today let’s take a look at how to embed an Excel data table into a Word Document.  If you have a Word report that is updated every month with data tables or charts from Excel then this direct link you can set up between the two documents can save a tonne of time.  The object you can embed can be a chart or graph, worksheet, Pivot Table, etc.  In this example today we will embed a data table of sales data.  You can see the data set below.

Embed An Excel Table Into A Word Document.

It is really easy to embed a linked Excel object.  Just follow the steps below:

  • First copy your Excel object.  I am copying the full Excel Table.
  • In Your Word Document, click where you want the object to be placed.
  • Hit Home Tab | Clipboard | Paste Special | Paste Link | As | Microsoft Excel Worksheet Object.
Paste Excel Table Link and Embed Into Word

Now when the data table updates our Word report also updates. Easy as that.

Automatically updating Word from an Excel table

Easy isn’t it?. Make your Word documents dynamic by embedding and linking your Chart or Table. This means that your reports can automatically update every time your Excel document is updated with your latest data.

th

More Excel Tips_New1

What Next? Want More Tips?

1

So, if you want more top tips then sign up for my Monthly Newsletter where I share 3 Tips on the first Wednesday of the month and receive my free Ebook.

 

 

Learn Excel With Our Excel Online Courses

Do You Need Help With An Excel Problem?.

Finally, I am pleased to announce I have teamed up with Excel Rescue,  where you can get help FAST.

ExcelRescue.net

Udemy.com Home page 125x125

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts