Insert Excel Document Into Word Update The Excel

There are a couple of ways to do this, depending on whether or not you want to maintain a connection with the source Excel sheet.

The first is by simply copying that data from the spreadsheet, and then pasting it into the target document.

For the most part, this only works with really simple data because that data just becomes a basic table or set of columns in Word (depending on the paste option you choose).

Both are pretty similar, in that you end up inserting an actual Excel spreadsheet in your target document.

It will look like an Excel sheet, and you can use Excels tools to manipulate it.

The difference comes in how these two options treat their connection to that original Excel spreadsheet.

Insert Excel Document Into Word Update The Excel

If you update the Excel file, those updates get automatically reflected in the target document.

Updating the original Excel sheet does not automatically update the data in the target document.

One disadvantage is that the original spreadsheet file needs to stay in the same location.

And since it relies on the link to the original spreadsheet, its not so useful if you need to distribute the document to people who dont have access to that location.

For example, if youre distributing that document to people who might not have access to the original Excel sheet, or if the document needs to show that Excel sheet at a specific point in time (rather than getting updated), embedding (and breaking the connection to the original sheet) makes more sense.

Start by opening both the Excel worksheet and the Word document you want to edit at the same time.

If you would like to link or embed the entire worksheet, click on the box at the juncture of the rows and columns in the top left-hand corner to select the whole sheet.

You can also right-click any selected cell, and then choose the Copy option on the context menu.

On Home tab of the Ribbon, click the down arrow beneath the Paste button, and then choose the Paste Special command from the dropdown menu.

And its here where youll find the only functional different in the processes of linking or embedding a file.

If you want to link your spreadsheet, choose the Paste Link option instead.

And any updates you make to that original spreadsheet are then reflected in your Word document.

Double-click anywhere in the spreadsheet and youll stay in the same Word window, but the Word Ribbon gets replaced by the Excel Ribbon and you can access all the Excel functionality.

You can actually insert an Excel Spreadsheet right from the Table dropdown menu on the Ribbon.

Over the past five years, shes written hundreds of articles on everything from Microsoft Office to education to history.

Shes co-author of the book Museum Hacks Guide to Historys Fiercest Females.

Since we launched in 2006, our articles have been read more than 1 billion times.

Insert Excel Document Into Word For Mac