Method 1 – Embedding Method to Insert as an Icon
- Open PowerPoint and select the slide where you want to insert the Excel file as an icon.
- Go to the Insert tab and click on Object in the Text section.
- Choose Create from file and browse to select the desired Excel file. If you want to create a new data set, click on Create new. You can also link the Excel file to the PPT file (explained in the conclusion).
- Select Display as icon. If you check the Link option, any changes to the original Excel file will automatically update the file in PowerPoint. Leave it unchecked if you don’t want that.
- Customize the icon by clicking Change Icon. Once you’ve selected the desired icon, click OK in both windows.
- Drag the icon to the required position and reshape it with corner handles. Just double click on the icon to access the data.
Read More: How to Embed an Excel File in PowerPoint
Method 2 – Paste Option to Insert into PowerPoint
- Open the Excel workbook where you want to insert and copy the data table.
- Open your PPT file and select the slide where you want to insert the Excel file.
- Click on the Paste bar and choose Paste Special from the options.
- Click on the Paste bar again and select Display as icon. You can also change the icon’s shape by clicking Change Icon. Click OK to insert the Excel icon on the slide.
- Drag the icon to your desired position and double-click to view or edit the file.
Read More: How to Perform Excel to PowerPoint Automation
Things to Remember
- Linking the data set to the PPT file is possible in both methods by clicking the link bar.
- If you link the files, changes in the original Excel file will affect the data in the PPT file. Deleting the original file will also remove the Excel file from the PPT.
- In the first method, you can create a completely new Excel file by selecting Create new instead of Create from file in step 2.
Download Practice Workbook
You can download the practice workbooks from here:
Related Articles
- How to Insert Excel Chart into PowerPoint
- How to Copy Chart from Excel to PowerPoint Without Link
- Automatically Create PowerPoint Slides from Excel
- How to Update Charts in PowerPoint from Excel Automatically
- How to Copy Table from Excel to Powerpoint with Formatting
<< Go Back to Excel to PowerPoint | Export Data from Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!