In PowerPoint, you can embed tables and worksheets from Excel in your presentation slides.
Select New Slide.
In Excel, click and drag to highlight the cells you want to copy.
Right-click the copied cells and select Copy.
In your PowerPoint presentation, right-click and select the Paste Options you want:
Use Destination Styles – Choose to edit your copied cells like a PowerPoint table, but with PowerPoint's color scheme and fonts.
Keep Source Formatting – Choose to keep your table editable in PowerPoint while maintaining the same source formatting from Excel.
Embed – Choose to keep a copy of your table in PowerPoint in case you want to edit the data, which will open in Excel.
Note: If you're working with a large Excel file, it'll inflate your PowerPoint presentation to a big size. You may also unintentionally be giving more access to your Excel file than you intend to.
Picture – Choose to paste your table as a picture to get the same benefits as embedding except you can format your cells like a picture and add effects to it. You won’t be able to edit data once it’s been pasted though.
Keep Text Only – Choose to paste your table as straight text and to do all formatting in PowerPoint.
If you pasted as a picture, on the Picture Tools Format tab, select the quick picture style you want to use. Adjust the table to your liking.
While the ability to create tables directly in PowerPoint directly is great, why reinvent the wheel?
When most of the time, you'll probably be pulling data you already have in an Excel file.
I'm going to create a New Slide.
I'll make it Title Only.
I'll add my title.
Now let's go into our Assets folder.
In the Assets folder, there's an Excel file called Average Stay Data.
It contains some cells filled with data.
I'll click and drag to highlight those cells.
Right-click and choose Copy.
I'll come back to my presentation.
Right-click and here I have some Paste Options.
I can paste using destination styles, which will give me the ability to edit this, like a PowerPoint table.
However, the color scheme and fonts will be that of the PowerPoint theme.
I can choose to keep the source formatting, which will again make my table editable in PowerPoint, and will keep the source formatting the way it looked in Excel.
I can Embed the Excel file.
This will leave a copy of it in my PowerPoint file, so that if I want to edit the data, it's going to open up in Excel.
There is something you need to know about this.
One, if the Excel file is large, it will inflate your PowerPoint presentation to a very large file size.
It can also pose a security risk.
If you're sharing this PowerPoint file with somebody else, or distributing it on the internet, everybody will have access to the entire contents that are in that Excel file.
I can also paste it as a Picture.
Pasting it as a picture gives me the benefits, and then I can format it like a picture, such as adding effects to it, but it won't let me edit the data once it's been pasted.
Finally, I can paste it as straight text, and do all my formatting in PowerPoint.
I'm going to choose to paste it in as a picture.
From here, I can enlarge it, move it around anywhere on my slide, and click the Picture ToolsFormat tab, and create a quick picture style.
I can move it around, enlarge it, make it smaller, and do anything I want to make it a great looking table on my slide.
Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today at linkedin.com/learning.
Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.
Get unlimited access to over 4,000 video courses.
Receive personal recommendations based on your LinkedIn profile.
Stream courses from your computer or mobile device.
Take courses for every level – beginner to advanced.
Practice while you learn with quizzes, exercise files, and coding windows.
Choose a plan for yourself or your entire team.