Learn Latest PowerPoint: Insert Excel Worksheets to PowerPoint 2010

In a PowerPoint 2010 presentation, you can insert a linked Excel worksheet or a portion of data from a linked spreadsheet, and copy a selection of cells to a slide. Here’s a guide discussing in 3 parts:

Part 1 Insert a linked Excel worksheet to PowerPoint 2010
To insert and link a saved Excel spreadsheet onto your PowerPoint slide, do the following:

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

Part 2 Insert a linked selection from a spreadsheet to PowerPoint 2010
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.

1. In PowerPoint 2010, click the slide where you want to paste the copied worksheet data.
2. On the Home tab, in the Clipboard group, click the arrow below Paste, and select Paste Special.
3. In the Paste Special dialog box, under As, select a Microsoft Excel Worksheet Object.
4. 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.

Part 3 Copy a selection of Excel cells onto a slide in PowerPoint 2010
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.

a. Select and copy the data that you want.
Keyboard shortcut You can press CTRL + C to copy the data.

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

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

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

Related posts:

  1. How to Insert Outline Text from Word to PowerPoint 2007
  2. How to Insert iTunes Music into PowerPoint Presentation
  3. How to send a PowerPoint presentation for review
  4. 3 Don’ts with PowerPoint
  5. Insert YouTube video clips to PowerPoint presentation

Reprint Policy:
All posts on this blog are created for non-profit sharing by the blogger staff of Moyea Software. You can reprint them without any fee, but are required to quote each source link on Moyea PowerPoint E-Learning Center (http://www.dvd-ppt-slideshow.com/blog/) and keep all original hyperlinks within.