Insert excel data in powerpoint

If you are using PowerPoint 2013 or a newer version, you can link data from a saved Excel worksheet to your PowerPoint presentation. That way, if data in the worksheet changes, you can easily update it in your PowerPoint presentation.

Newer versions 2010



Link an entire Excel worksheet to PowerPoint

1. In PowerPoint, on the Insert tab, click or tap Object.

   

2. In the Insert Object dialog box, select Create from file.

   

3. Click or tap Browse, and in the Browse box, find the Excel workbook with the data you want to insert and link to.

4. Before you close the Insert Object box, select Link, and click OK.

   

   Important: The linked object in your presentation displays all the data from the active, top worksheet in the linked Excel workbook. When you save the Excel workbook, make sure the worksheet you want in your presentation is the one you see when you first open the workbook.

Link a section of data in Excel to PowerPoint

1. In Excel, open the saved workbook with the data you want to insert and link to.

2. Drag over the area of data you want to link to in PowerPoint, and on the Home tab, click or tap Copy.

3. In PowerPoint, click the slide where you want to paste the copied worksheet data.

4. On the Home tab, click the arrow below Paste, and select Paste Special.

   

5. In the Paste Special box, click Paste link, and then, under As, select Microsoft Excel Worksheet Object.

   

Copy and paste (unlinked) Excel data in PowerPoint

In this case, the Excel data will not be linked to your PowerPoint presentation. You copy the data from an Excel worksheet and paste it into your presentation. The worksheet does not send automatic updates to PowerPoint.

1. In Excel, open the workbook with the data you want to copy.

2. Drag over the area of data you want to copy, and on the Home tab, click or tap Copy.

3. In PowerPoint, click the slide where you want to paste the copied worksheet data.

4. On the Home tab, in the Clipboard group, click the arrow below Paste.

5. Under Paste Options, pick one of the following. Move the mouse pointer over each Paste option to see a preview of what it would look like.

   	Use Destination Styles to copy the data as a PowerPoint table, using the format of the presentation
   	Keep Source Formatting to copy the Excel data as a PowerPoint table, using the format of the worksheet
   	Embed to copy the data as information that can be edited in Excel later
   	Picture to copy the data as a picture that can't be edited in Excel
   	Keep Text Only to copy all the data as a single text box

See Also

Copy an Excel chart to another Office program

Insert a linked worksheet

To insert and link a saved Excel worksheet onto your PowerPoint slide, do the following:

Important: The linked object in your presentation displays all data from the active, top worksheet in the linked Excel workbook.

1. In PowerPoint 2010, on the Insert tab, in the Text group, click Object.

2. In the Insert Object dialog box, select Create from file.

3. Click Browse, and in the Browse dialog box, browse to and then select the Excel workbook that contains the information that you want to insert, and then click OK.

4. In the Insert Object dialog box, select Link and then click OK.

To edit a linked Excel worksheet, do one of the following:

• To edit the data from within Excel, right-click the object on the slide, point to Linked Worksheet Object, and select Edit.

• To update the data on the slide to match the data in the original Excel file, right-click the object on the slide, and click Update Link.

Insert a linked selection from a worksheet

To insert and link a selection of data from a saved Excel worksheet, do the following:

1. In Excel, open the workbook containing that data that you want to insert.

2. Select and copy the data that you want.

   Keyboard shortcut    You can press CTRL+C to copy the data.

3. In PowerPoint 2010, click the slide where you want to paste the copied worksheet data.

4. On the Home tab, in the Clipboard group, click the arrow below Paste, and select Paste Special.

5. In the Paste Special dialog box, under As, select a Microsoft Excel Worksheet Object.

6. Select the Paste link check box and click OK.

To edit a selection of cells from a linked Excel worksheet, do one of the following:

• To edit the data from within Excel, right-click the object on the slide, point to Linked Worksheet Object, and select Edit.

• To update the data on the slide to match the data in the original Excel file, right-click the object on the slide, and click Update Link.

Copy a selection of cells onto a slide

To paste a copy a selection of Excel data onto your PowerPoint slide, do the following:

Note: Data copied and pasted onto a PowerPoint slide does not automatically update when the data is changed in the Excel workbook. To link the data on the PowerPoint slide to the original Excel data source, see the "Insert a linked selection from a worksheet" section immediately above.

1. In Excel, open the workbook that contains the information that you want to copy.

2. Select and copy the data that you want.

   Keyboard shortcut    You can press CTRL+C to copy the data.

3. In PowerPoint 2010, click the slide where you want to paste the copied worksheet data.

4. On the Home tab, in the Clipboard group, click the arrow below Paste.

5. Under Paste Options, do one of the following:

   1. Select Keep Source Formatting if you want to copy the data as a PowerPoint table, but want it keep the appearance of the original Excel worksheet.

   2. Select Use Destination Styles if you want to copy the data as a PowerPoint table, but want it to assume the appearance of the PowerPoint presentation.

   3. Select Embed if you want to copy the data as information that can be edited in PowerPoint.

   4. Select Picture if you want to copy the data as an un-editable picture.

   5. Select Keep Text Only if you want to copy all the data as a single text box.

See Also

Import content from other applications

Copy an Excel chart to another Office program