How to Use Excel selected range rows and columns in PowerPoint slide


B

BAB

Im using excel 2010 and have graphs/charts in excel sheet and needs to bring it in Powerpoint by automated script or click of a button? How to do in VBA script/macro?

BAB
 
Ad

Advertisements

N

namadany

Im using excel 2010 and have graphs/charts in excel sheet and needs to bring it in Powerpoint by automated script or click of a button? How to do in VBA script/macro?



BAB

1To insert and link a selection of data from a saved Excel spreadsheet, do the following:

1. In Excel, open the workbook containing that data that you want to insert.
2. Select and copy the data that you want.
Keyboard shortcut You can press CTRL + C to copy the data.

1. In PowerPoint 2010, click the slide where you want to paste the copied worksheet data.
2. On the Home tab, in the Clipboard group, click the arrow below Paste, and select Paste Special.
3. In the Paste Special dialog box, under As, select a Microsoft Excel Worksheet Object.
4. Select the Paste link check box and click OK.

To edit a selection of cells from a linked Excel spreadsheet, do one of the following:

* To edit the data from within Excel, right-click the object on the slide, point to Linked Worksheet Object, and select Edit.
* To update the data on the slide to match the data in the original Excel file, right-click the object on the slide, and click Update Link.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top