Wednesday, September 25, 2013

How to Copy an Excel Spreadsheet Into PowerPoint


Copy Entire Worksheet
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. 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. 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
4. 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.
5. 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.
6. 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.

Blogger news