Download Article
Download Article
If you want to take data from an Excel spreadsheet and put it into a PowerPoint presentation, you can do so by simply copying and pasting it. If you want to make sure your spreadsheet data stays updated throughout both programs, you can use the Object tool to insert your data into PowerPoint. Here's how to convert Excel to PowerPoint using your Windows or Mac computer.
Transferring Excel Data to PowerPoint
To convert Excel data into PowerPoint, highlight the data you want. Right-click the data and click Copy . Navigate to a slide in PowerPoint, click an empty area, and then click Paste . You can also link to an Excel file using the "Object" tool in PowerPoint. Select Create from File , and then select your Excel file.
For popular FAQs on converting Excel to PowerPoint, jump to more common questions .
Steps
Using Copy and Paste
Download Article
-
Open an Excel file. You can use copy and paste to put an Excel chart, graph, or other data into a PowerPoint presentation.
-
Select the data you want to use. You can click the box in the top-left corner of the data to select everything. If you only want to select a certain chart or graph , click and drag one corner to the other.Advertisement
-
Press Ctrl + C (Windows) or ⌘ Cmd + C (Mac) to copy. Alternatively, right-click or control-click the chart and select Copy .
-
Open your Microsoft PowerPoint presentation. Navigate to the slide where you want to paste the Excel data.
-
Press Ctrl + V (Windows) or ⌘ Cmd + V (Mac) to paste. Alternatively, right-click or control-click where you want the chart and select Paste .
- For more paste options, click the Home tab and click the arrow underneath the Paste icon. You can select: Keep Source Formatting , Use Destination Styles , Link & Keep Source Formatting , Link & Use Destination Styles , Picture , or Keep Text Only .
-
Edit the Excel data on the slide. To move the chart or graph, click the outer edge and drag it to a new location. To resize it, drag the corner circle inwards to make it smaller or drag it outwards to make it bigger.
-
Customize the chart (optional). If you want to edit the data or change its layout elements, styles, and filters, do the following:
- Select the chart.
- Click the Chart/Table Design or Chart/Table Tools Design tab.
- Click Data .
- Click Edit Data .
- Select a modification option.
Using the Object Tool
Download Article
-
Open your PowerPoint file. You can use the Object tool to link Excel data in PowerPoint if you don't want to copy and paste it. This tool will insert the Excel file into your presentation so that when you update the data in Excel, it will also update in the presentation.
-
Click Insert . This is in the top toolbar.
-
Select Object . You can find this in the Text section.
-
Select Create from file . This is the button on the left.
-
Click Browse . This is underneath the File field.
-
Select your Excel file. Use the pop-up File Explorer to find and select your file. Then, click Open or Insert .
-
Click OK . This is at the bottom-right corner of the window. The Excel file will be linked to your PowerPoint.
- If you change the data in Excel, you'll need to refresh the presentation to stay up-to-date. Right-click the data in PowerPoint and select Update Link . [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Common Questions: Converting Excel to PPT
Can I copy from Excel to PowerPoint and keep formatting?
When you paste Excel data into PowerPoint, you can choose to keep the original formatting or change it to match PowerPoint's. With the Paste menu open, select the icon for the option you want.
How do I transfer an Excel chart to PowerPoint?
Click the chart you want to transfer and click Ctrl + C to copy it. Select a slide in PowerPoint, and then press Ctrl + V to paste it.
Can I link an Excel file in PowerPoint?
You can link an Excel file in PowerPoint by using the "Object" tool. Select it from the toolbar. Select Create from file , select the Excel file, and then select OK .
