How to link a part of data in Excel Worksheet in Microsoft PowerPoint

To make a PowerPoint presentation look extra reasonable, Office customers can link an Excel worksheet in it. It has many advantages. One, it serves a helpful ability because it permits data to be introduced in a extra lucid and simple to comprehend method. Second, it helps to keep away from any mismatch of data in your report because the modifications you make are immediately mirrored in the presentation, so lengthy the recordsdata share the unique location.

If you might be curious to understand how to embed an Excel Worksheet in PowerPoint presentation, pause for a second and browse additional.

Link Excel Data in PowerPoint Presentation

Before continuing any additional and diving into the principle steps of the tutorial it is necessary to point out that the phrases ‘EMBEDING’ and ‘LINKING’, although sound comparable and interchangeable are fairly totally different.

Launch Microsoft Excel and open the saved workbook with the data you need to insert and link to.

Next, choose a part by dragging over the world of data and hit ‘Copy’ button seen underneath the ‘Home’ tab.

how to link a part of data in excel worksheet in microsoft powerpoint - How to link a part of data in Excel Worksheet in Microsoft PowerPoint

Now, change to your PowerPoint presentation and click on the slide the place you prefer to to paste the copied worksheet data.

Then, on the Home tab, click on the arrow beneath Paste, and choose Paste Special.

1533221718 273 how to link a part of data in excel worksheet in microsoft powerpoint - How to link a part of data in Excel Worksheet in Microsoft PowerPoint

When seen, select ‘Paste link’ underneath ‘Paste Special’ heading, after which, underneath ‘As’, choose Microsoft Excel Worksheet Object.

1533221718 118 how to link a part of data in excel worksheet in microsoft powerpoint - How to link a part of data in Excel Worksheet in Microsoft PowerPoint

Also, if you need to link a complete Excel worksheet to PowerPoint, go to a PowerPoint presentation, select the Insert tab and click on or faucet Object.

In the Insert Object dialog field that opens, choose Create from file possibility.

1533221718 810 how to link a part of data in excel worksheet in microsoft powerpoint - How to link a part of data in Excel Worksheet in Microsoft PowerPoint

Thereafter, click on or faucet Browse, and in the Browse field, discover the Excel workbook with the data you need to insert and link to. Check the ‘Link’ possibility adjoining to the ‘Browse’ button.

That’s it!

Leave a Comment