Insert Excel table in PowerPoint
Sometimes it is useful to insert Excel tables in PowerPoint, for example if they are to contain complex functions. The PowerPoint immanent table is often not sufficient here. Find out how to get an Excel sheet into your presentation here.
Insert the Excel spreadsheet into the PowerPoint presentation
- Click on "Insert" in the menu bar.
- Now select "Table" and then "Insert Excel table ...".
- Now you will find the Excel spreadsheet in your presentation. If you have already created an Excel spreadsheet that you would like to insert, simply copy the content from the existing spreadsheet and paste it into PowerPoint. Unfortunately, Excel formulas are not adopted. Here you have to create a shortcut.
Insert Excel table as a link in PowerPoint
Do you want to insert an Excel table in PowerPoint, the changes of which should also be adopted there? Then you have to create a link between the two files. And this is how it works:
- Go to the page where you want to insert the table.
- Now select the "Object" button in the "Insert" menu tab.
- In the pop-up click on "Create from file" and enter the file path or search for the corresponding Excel file using the "Browse" command. Select the file and confirm with "OK".
- Now tick the "Link" next to the "Browse" button. And confirm again with "OK".
If you now make changes in the original Excel file, these are also adopted in the PowerPoint presentation. To see the changes, you have to open the PowerPoint file again.
The tip was carried out on a PC with Powerpoint 2010 and Excel 2010, the process may vary slightly for other versions.