How to Insert an Excel File into PowerPoint as an Icon (2 Methods)

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.

how to insert an excel file into powerpoint as an icon

  • 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).

Selecting Create from File to Insert Excel File

  • 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.

change icon for inserting excel into powerpoint

  • Drag the icon to the required position and reshape it with corner handles. Just double click on the icon to access the data.

inserted Icon

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.

excel dataset

  • 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.

selecting paste special

  • 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.

changing Icon

  • Drag the icon to your desired position and double-click to view or edit the file.

inserted Icon

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

<< Go Back to Excel to PowerPoint | Export Data from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sourav Kundu
Sourav Kundu

Sourav Kundu, BSc, Naval Architecture & Marine Engineering, Bangladesh University of Engineering and Technology, is a dedicated technical content creator of the ExcelDemy project. He has a keen interest in Excel and he leverages his problem-solving skills to provide solutions on user interface with Excel. In his position as an Excel & VBA Content Developer at ExcelDemy, Sourav Kundu not only adeptly addresses challenging issues but also demonstrates enthusiasm and expertise in navigating complex situations. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo