Insert an Excel worksheet in PowerPoint

You can link data from a saved Excel spreadsheet into your Microsoft PowerPoint 2013 presentation. This means if the data changes on the Excel spreadsheet, you can update it in your PowerPoint presentation with just a few clicks. If you don’t want the data in your presentation to update, copy the spreadsheet cells and paste them into your presentation.

If you want the Excel data to update in PowerPoint

Linking the data means changes to the linked data in Excel are updated in the PowerPoint presentation. You can link an entire spreadsheet or a selected portion of a spreadsheet.

Insert a linked Excel spreadsheet

  1. In PowerPoint, 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 Excel and then select the 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.

 Important    The linked object in your presentation displays all data from the active, top spreadsheet in the linked Excel workbook. When you save the Excel workbook, make sure that the spreadsheet that you want in your presentation is the one showing on top.

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.

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

If you don’t expect the data to change

Copy and paste a selection of cells as a PowerPoint table if you don’t expect to change the Excel data in your presentation. You can edit the data manually in PowerPoint, but any changes in Excel will not update in PowerPoint.

  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, 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:
  • Select Keep Source Formatting if you want to copy the data as a PowerPoint table, but want it to keep the appearance of the original Excel spreadsheet.
  • 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.
  • Select Embed if you want to copy the data as information that can be edited in Excel.
  • Select Picture if you want to copy the data as a picture that cannot be edited.
  • Select Keep Text Only if you want to copy all the data as a single text box.

 Tip    Move the mouse pointer over each option to see a preview of what the pasted selection would look like.

Top of Page Top of Page
 
 
Applies to:
PowerPoint 2013