If you want to take data from an Excel spreadsheet and put it into a PowerPoint presentation, you can do so with built-in controls available in both programs. To paste Excel data into PowerPoint, select the data and copy it. Select a slide in PowerPoint, and then select Paste. This wikiHow shows you how to put Excel data into PowerPoint slides using these features.
Transferring Excel Data to PowerPoint
To convert Excel data into PowerPoint, highlight the cells you want to copy, select the Home tab, and then click Copy . Open PowerPoint and click Paste . You can also link to an Excel document by 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
-
Open an Excel file you want to use. Open your file explorer and navigate to the folder where your file is stored.
-
Click on the box in the top left to select data. You can select all of the data or only the data you want.Advertisement
-
Click Edit and select Copy to copy the data.
-
Open Microsoft PowerPoint. You can minimize the Excel file's window or exit Excel and navigate to PowerPoint.
-
Click File in the top left. This pulls up a drop-down list of more options for that PowerPoint file.
-
Click New . You can also open an existing presentation.
-
Click on the slide that you want to use. You can also format the slide for displaying data by picking the slide template.
-
Right click and select Paste . This pastes the Excel data into your chosen slide.
-
Click on the clipboard icon in the bottom right. This changes presentation options for your slide.
-
Select a mode for presentation from the drop-down menu. Save your work after you're satisfied with the changes you've made.
-
Open your PowerPoint file. Navigate to the folder where it's saved from your file explorer.
-
Click Insert in the menu bar.
-
Select Object .
-
Select Create from file .
-
Locate your Excel file. Once you've opened the dialog window, navigate to the Excel file you want to insert into your PowerPoint slide.
-
Select your file and click Insert . This will insert the file into the slide you've selected.
-
Resize and rearrange the spreadsheet snapshot as desired. You can grab the edges to make it bigger or smaller, or click and drag to move it. When you double-click on the actual spreadsheet, it'll open the file in Excel.
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 .