Share MS Excel Data in Word Documents





You can share the MS Excel Data with
  • Word documents and
  • You can also share the workbook with multiple users to work at same time. For this workbook have to be saved to a network location where multiple users can access the file
Here we will learn , How to share MS excel data with Word documents 
How to share MS Excel Data with Word documents 
Sharing data with word Documents is very easy as most of the time, simple copy & paste is sufficient.
First method : Simple Copy Paste
Let's learn with Example
>> Select the Excel data you want to paste to word document.
>> Right click, and then click copy or press Ctrl+c.
>> Open Word document. Right click, and then click paste or press Ctrl+v.
>> If you want borders in your table, click the Border icon and add borders.
Result will be 


Second method : Copy & Paste Link


You can Link the source data in Excel in Word. With this, If you change the data in Excel, the data in Word is automatically updated.
Let's learn with Example
>> Select the Excel data you want to paste to word document.
>> Right click, and then click copy or press Ctrl+c.
>> Open Word document. Click paste special from paste icon.
>> Paste Special Dialog Box will appear. Click Paste Link. Select HTML Format.
>> Click OK.
Result will be 
** Now, The Excel Data is Linked with Word Document. If you make a change in Excel data the word document will automatically be updated.
Let's learn with Example
>> Here in Excel, change the Data from Operations Support to Manager.
>> And the Result in MS Word Document will be


Must read for you :