How to Copy an Excel Spreadsheet Into PowerPoint

Written by shawn mcclain
  • Share
  • Tweet
  • Share
  • Email

Microsoft's Office productivity programs work together, offering several methods to copy a file created in one program into another and to determine its appearance. To insert an Excel spreadsheet into a PowerPoint 2010 presentation, you can simply copy a small group of cells that hold the pertinent information, or you can have PowerPoint display an entire worksheet. You can also have the embedded pieces of Excel linked to the actual Excel file, so the PowerPoint slide will update whenever the Excel spreadsheet does.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

    Copy Entire Worksheet

  1. 1

    Select the PowerPoint slide in which you want to insert the Excel worksheet. If the slide has multiple content boxes, click the content box where you want the Excel information to appear.

  2. 2

    Click the "Insert" tab at the top of the PowerPoint 2010 window. Locate the "Text" field and select the "Object" button to open the "Insert Object" window.

  3. 3

    Select the radio button next to "Create from file" on the left side of the window. Then click the "Browse" button and navigate to the Excel file that you want to add. Place a check next to "Link" if you want the image of the Excel spreadsheet to update whenever the Excel file changes. Click "OK" to add the image of the top worksheet in the Excel file to your PowerPoint slide.

    Copy Range of Cells

  1. 1

    Open the Excel 2010 file and select the worksheet that contains the information you want to add to a PowerPoint slide. Click the upper left cell in the range of information and hold down the mouse button. Move the mouse to the lower right cell and release the button. Press "Ctrl" + "C" to copy the cell information to the clipboard.

  2. 2

    Open the PowerPoint 2010 presentation and select the slide in which you want to add the Excel information. If multiple object boxes are present on the slide, select the one where you want the Excel information to go. Click the "Home" tab at the top of the screen and select the "Paste" button on the far left side of the ribbon. Five options will appear.

  3. 3

    Select "Use Destination Styles" to paste the cells as a PowerPoint table and use the same style as the current PowerPoint presentation. Select "Keep Source Formatting" to paste the cells as a PowerPoint table but keep the exact same appearance as the cells had in the Excel worksheet, including conditional formatting. Select "Embed" if you want to paste the cells as a small piece of the Excel program, which you can then edit like an Excel worksheet. Select "Picture" to paste an image of the selected cells. Select "Keep Text Only" to convert the Excel information into text and paste it into the object box. When you make your selection, the Excel information will appear on your PowerPoint slide.

Tips and warnings

  • If you choose "Embed," you must double-click the Excel image to alter any of the information in the cells.
  • You can also choose "Paste Special" under the "Paste" button to insert the cells as an Excel image that will update whenever the Excel file does.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.