transfer excel data powerpoint

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Transfer excel data to powerpoint document for a presentation

Transfer excel data to powerpoint document for a presentation

resolvedResolved · Low Priority · Version 2003

Paula has attended:
Excel Introduction course

Transfer excel data to powerpoint document for a presentation

can complex data ( ie a timetable, etc) be transferred from an excel document to a powerpoint presentation and how would you make it fit?

RE: transfer excel data to powerpoint document for a presentati

Hello Paula

Thank you for your question and welcome to the forum.

You can do this, within reason. Obviously in PowerPoint you are confined by the amount of space you have available on a slide.

If you select the Excel data that you want to put into the PowerPoint presentation and copy it, go into PowerPoint and paste the data, you should see a little picture of a clipboard appear underneath the data you pasted into PowerPoint.

If you click on the clipboard, it will give you options of how to paste the data. Probably the Excel Table or Picture of Table options would be best.

If you select the Excel Table option, you will be able to double-click on the data and edit it using Excel, so if you wanted to adjust column or row sizes for example you would be able to do this.

The other way to do this is instead of pasting a copy of the data into PowerPoint, you could link to the spreadsheet instead.

I hope this helps.
Amanda


 

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips


Server loaded in 0.08 secs.