Share via

Linking an Excel Cell to a Word Document

Anonymous
2021-11-17T19:54:20+00:00

Is there a way to have a specific Excel Cell appear in a Word document. For example, say I have a Master Excel document that has dates and names. These dates and names are used in 10 different Word template documents. I would like to be able to change the date in in the Excel File and have that update all the word documents. Or make a changes made to a name and have that update one of the Word Document files. In Excel, something like this can be done using "=A1" function, with A1 Cell containing a Date or Name. I was wondering if there is a similar function that could be used between Excel and Word.

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Jay Freedman 205.3K Reputation points Volunteer Moderator
    2021-11-18T01:46:01+00:00

    In the Excel workbook, select the specific cell(s) that you want to use, and copy them to the clipboard. Go into the Word document, position the cursor where you want the information to appear, and click the down arrow on the Paste button. Choose either "Link & Keep Source Formatting" to have the cell appear the same as in Excel, or "Link & Use Destination Styles" to have it appear with the formatting of the current location in Word.

    The "Link" part of this means that changes in the data in Excel will appear in the Word document, assuming that the workbook is accessible from the computer where Word is running.

    106 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-11-18T02:06:50+00:00

    Fantastic! I had to make a few changes in formatting, but this worked perfectly!

    9 people found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more