Sunday, February 24, 2013

How to Convert a Workbook in Excel 2007 to a PowerPoint Slide


1. Open the Excel workbook you want to copy to PowerPoint. On the first worksheet press 'Ctrl A' then 'Ctrl C' on the keyboard.
2. Open a PowerPoint presentation. Click on the slide where you want to insert the worksheet. Don't click in a text box, but just a blank area on the slide. Press 'Ctrl V' to paste the table into PowerPoint. Press 'Ctrl M' to create a new slide.
3. Switch back to Excel then click the tab for the next worksheet in the workbook.
4. Select and copy the contents of that sheet and paste them into the new slide in PowerPoint. Repeat this process for each worksheet in the workbook to convert the entire workbook into a PowerPoint presentation.
5. Paste a chart or graph into PowerPoint from Excel by clicking the chart in Excel and pressing 'Ctrl C' to copy it.
6. Switch back to PowerPoint and create a new slide.
7. Press 'Ctrl V' to paste in the chart.
8. Click the 'Paste Options' link next to the chart and choose to link the data or to link to the entire Excel workbook.

Blogger news