Import data from Excel into PowerPoint

You can link data from a saved Excel spreadsheet or copy cells from an Excel spreadsheet into your Microsoft PowerPoint 2010 presentation.

What do you want to do?

Insert a linked spreadsheet

Insert a linked selection from a spreadsheet

Copy a selection of cells onto a slide

Insert a linked spreadsheet

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

Important:  The linked object in your presentation displays all data from the active, top spreadsheet 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 spreadsheet, 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.

Top of Page

Insert a linked selection from a spreadsheet

To insert and link a selection of data from a saved Excel spreadsheet, 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 spreadsheet, 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.

Top of Page

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 Insert a linked selection from a spreadsheet.

1. In Excel, open the Excel 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 spreadsheet.

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

   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.

Top of Page