Microsoft Excel Worksheet is frequently used to collect, analyze and manipulate data. We mainly use Microsoft PowerPoint to make a professional presentation in front of our colleagues to present these analysis reports such as business plans, sales data, and financial reports created from Excel. In this article you will learn how to convert Excel worksheet to PowerPoint slide with 6 ways. You can copy the data from Excel worksheet and paste them into the PowerPoint slide.
But the data in the PowerPoint by copying and pasting will not be updated automatically if the data on the original Excel spreadsheet is changed. Step 1. Open the Excel file, select the data that you want to copy by dragging the data area, go to Home and then click Copy.
Step 2. Open Microsoft PowerPoint and go to the slide that you want to paste the data, right click on the slide and then select the Paste Options from the drop-down menu.
You can move your mouse to each Paste option to see a preview effect of the template. To link an Excel spreadsheet to PowerPoint means that you insert the whole contents of the Excel file as an object to the PowerPoint. You can convert excel to PPT slide by following these steps. After Insert Object pops up on the screen, select Create from file. Step 3. Tips: You can resize and rearrange the spreadsheet snapshot by grabbing the edges to make it bigger or smaller, or clicking and dragging to move it in the slide.
If you double click on the spreadsheet, the file in Microsoft Excel will be opened. Under Paste Options , pick one of the following. Move the mouse pointer over each Paste option to see a preview of what it would look like. Use Destination Styles to copy the data as a PowerPoint table, using the format of the presentation. Keep Source Formatting to copy the Excel data as a PowerPoint table, using the format of the worksheet.
Embed to copy the data as information that can be edited in Excel later. Picture to copy the data as a picture that can't be edited in Excel. Keep Text Only to copy all the data as a single text box. Copy an Excel chart to another Office program. Important: The linked object in your presentation displays all data from the active, top worksheet in the linked Excel workbook.
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. 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.
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 the "Insert a linked selection from a worksheet" section immediately above.
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 worksheet. Select Use Destination Style s 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 PowerPoint. Select Keep Text Only if you want to copy all the data as a single text box. Import content from other applications. Insert a linked worksheet To insert and link a saved Excel worksheet onto your PowerPoint slide, do the following: Important: The linked object in your presentation displays all data from the active, top worksheet in the linked Excel workbook.
Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback?
0コメント