spot_img

How To Link Objects In Excel

Follow the steps below to learn how to create linked objects in Excel.

Open both Word and Excel document hat contains the data that you want to create a linked object.

In Excel select the range of cells (containing data) or the charts that you want and copy them (CTRL + C)

Next go to Word and then click where you want the information to appear. On the Home tab click on Paste and select Paste Special. In the As list select Microsoft Office Excel Object.

 

paste special

Click Paste or Paste Link.

paste object

(Optional) To create a new worksheet within a document.

Click on the Insert tab and then click on Table and then click on Excel Spreadsheet. Fill in the worksheet with the information you want.

Excel spreadsheet

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell