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.
Copy Entire Worksheet
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.
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.
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
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.
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.
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 & 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.
How to Insert a Graph into your Excel Spreadsheet
When reporting data or to get a better idea of what direction you company is heading, a graph is the easiest way...
How to Use VBA & Macro to Change Fonts
Microsoft Visual Basic for Applications (VBA) is a programming application that's included with every copy of Microsoft Office. VBA assists you with...
Excel Point Reduction
Microsoft Excel is a versatile program for handling a wide variety of data. Its complex formulas and functions allow for extensive analysis...