Copy Excel 2003 Data into PowerPoint 2003 December 15, 2009Posted by computertrainer in Excel Tips, PowerPoint Tips.
Tags: copy Excel to PowerPoint, Excel, PowerPoint
In my opinion, PowerPoint 2003 Tables are horrible to work with. Often I will copy data from Excel directly to PowerPoint to avoid working with the Table. Or I will use Excel in PowerPoint to create the data … it is so easy to format and do formulas in Excel versus the dreaded Table.
Last week, on the fly, I added this to a PowerPoint class and promised all the attendees that they could find the instructions here in my blog. So for them and everyone else who reads this …
- Open the PowerPoint presentation and add a new slide with Title Only layout.
- Open the Excel file that has the data you want to include.
- Select and copy the Excel data.
- Go to the PowerPoint slide.
- Click Edit on the Menu and select Paste Special.
- Select Paste then Microsoft Office Excel Worksheet Object if you want to make changes, including formatting, in Excel. With this option, when you double-click the object, you will open Excel but any changes made will be only made in the PowerPoint slide and not in the original workbook.
- Select Paste Link then Microsoft Office Excel Worksheet Object if you changes made in the original file to change in the PowerPoint slide. With this option, when you double-click on the object, you will open the original Excel workbook. Any changes made are changed in the original file and are displayed in the PowerPoint slide.
- Click OK and you are done.
- The object may be smaller than you want. Double-click the object and Excel opens.
- Change the size of the font to 24 to 32 then size the columns to fit.
- Make any other formatting changes then click outside the object and your work is done.
- Now you can move the object so it is centered on the slide. Do this by clicking on the object – getting the 4-headed arrow – and drag to the position.
I hope this helps.