Want to create impressive presentations that really capture your audience’s attention? Learn how to insert Excel data into a PowerPoint presentation. You can display charts, graphs, and other content in your presentations to help make them more engaging and informative. This tutorial provides three easy ways to do it.
Page Contents
Inserting and linking an Excel spreadsheet in PowerPoint
If you need to display data from an Excel spreadsheet in your PowerPoint presentation, you can embed it as a linked object. That way, if the data changes in the spreadsheet, it will automatically update in PowerPoint as well. This ensures that your presentation always has the most up-to-date and accurate information. Additionally, you can click on the embedded spreadsheet in PowerPoint to open it in Excel.
Don’t worry, embedding and linking an Excel spreadsheet in a PowerPoint presentation is simple. Just follow these steps:
- In PowerPoint, click Insert on the ribbon.
- Click Object (located in the Text group) to open a dialog box.
- In the Insert Object dialog box, click the Create from file radio button, then click Browse.
- In the Browse box, find the Excel worksheet you want to embed. Select it, then Click OK.
- Before closing the Insert Object dialog box, check the Link radio button, then click OK.
Note: When you link an Excel workbook to PowerPoint, only the active, top worksheet in the workbook is displayed in the presentation. When saving the workbook, make sure that the worksheet you want displayed in the presentation is the top sheet (i.e., the one you see when you first open the workbook).
Inserting and linking a section of Excel data in PowerPoint
Sometimes, you need to insert and link only a portion of data from an Excel worksheet into your PowerPoint presentation. To do this, follow these steps:
- Open both PowerPoint and Excel.
- In Excel, open the saved workbook that contains the data you want to insert.
- Hover the mouse pointer over the starting cell of the section of data you want to use until you see a white cross icon.
- Hold down the left mouse button and drag to the last cell of the section to select it.
- Right click anywhere on the selected section to access a context menu.
- On the context menu, click Copy.
- In PowerPoint, select the slide you want to paste the copied worksheet data into.
- On the Home ribbon, click Paste, and select Paste Special.
- In the Paste Special box, click Paste link, and then, under As, select Microsoft Excel Worksheet Object, then click OK.
- Use the mouse pointer to resize and move the embedded data to where you want it in your presentation.
Inserting unlinked Excel data in PowerPoint
You can copy and paste data from an Excel worksheet into your presentation without linking it. In this case, the worksheet will not send automatic updates to PowerPoint.
- In Excel, open the workbook with the data you want to copy.
- Drag over the area of data you want to copy, and on the Home tab, click or tap Copy.
- In PowerPoint, select the slide you want to use, then place the mouse pointer on the slide where you want the copied worksheet data to display, and right click to access a menu.
- In the context menu, under Paste Options, move the mouse pointer over each option to see a preview of what it would look like. Select the one you want.
Inserting Excel data into a PowerPoint presentation is a straightforward process that can be done in a few simple steps. By doing this, you can create impressive presentations that really capture your audience’s attention.