How do I link my excel spread sheet contents over to a word document

Question

I need help with trying to link my excel spreadsheet contents over to a word document (such that, when I do the data entry into excel, it also updates the word document) I have taken a basic course in Excel and am comfortable with Word and excel at the basic level; I need help with interlinking Excel and Word.

Answer 1

Hello, "Asked?",

The exact steps may depend on which version of Word you have. I'll explain how to insert an Excel spreadsheet based on my Office 365 Word and Excel programs.

Assuming you only want a specific portion of a spreadsheet inserted into Word, select that portion in Excel. I give the selection a name, just to be sure. I save it but leave it open when I start Word.

In Word, go to "Insert" and select "Object."

Object

The drop down box will ask if you want to create a new file or import an existing one. Select "Create From File" and navigate to the file. If you want to transfer updates as you make changes, click "Link to File."

You can resize and change entries once the import is completed.

Bob

Answer 2

Not sure what version of MS Office you have...

I've got 2010 with no intentions to upgrade, and here is how it's done

1) Creates the spreadsheet in Excel

2) Opens up the word document

3) click INSERT menu

4) in the TEXT GROUP, click OBJECT

5) from the menu drop-down, click OBJECT

6) in the Object dialog, click the tab labeled "CREATE FROM FILE"

7) click BROWSE and locate the spreadsheet

8) click on the checkbox "LINK to FILE"

9) click OK

The spreadsheet is now in the document WHILE it is open in EXCEL.

Changes made to the spreadsheet in EXCEL will update in WORD automatically

Answer 3

If this solution was helpful, I would appreciate an upvote.

If you need help solving problems like this one, I'd like to be your tutor.

Scan the QR code in the video or use this link:

https://www.wyzant.com/Tutors/MiddleSchoolMadeEasy