Excel Power Point

30-04-2021
 |  [RAND-100] - Comments



Link an entire Excel worksheet to PowerPoint In PowerPoint, on the Insert tab, click or tap Object. In the Insert Object dialog box, select Create from file. Click or tap Browse, and in the Browse box, find the Excel workbook with the data you want to insert and link to. With Microsoft 365 for the web (formally Office 365) you can edit and share Word, Excel, PowerPoint, and OneNote files on your devices using a web browser.

Collaborate for free with an online version of Microsoft PowerPoint. Save presentations in OneDrive. Share them with others and work together at the same time. Copy and Paste Excel Data into PowerPoint. You can copy the data from Excel worksheet and paste. Download Microsoft Office: Word, Excel, PowerPoint and more 16.0.4 for Android for free, without any viruses, from Uptodown. Try the latest version of Microsoft Office: Word, Excel, PowerPoint and more 2021 for Android.

2020-12-21 15:05:49 • Filed to: PowerPoint Features • Proven solutions

PowerPoint and Excel are among the most powerful software that comes in a pack of Microsoft Office. While working on PowerPoint slides, you may be needing to insert an Excel file into PowerPoint or copy an Excel table to PowerPoint to increase the effectiveness of your presentations. So, if you are looking for the easiest way to insert Excel into PowerPoint, this article is for you.

How to Insert Excel into PowerPoint

The steps of adding an Excel spreadsheet to PowerPoint are similar in all the versions of PowerPoint, such as 2010, 2013, 2016, or 2019. So, you can follow the steps below.

  • Step 1. Launch PowerPoint and open the desired PPT file in which you want to add the Excel. Then click 'Insert' > 'Object' > 'Create from file'.
  • Step 2. Here, you need to locate the Excel file by clicking on the “Browse” button and selecting the destination folder. Once found, click” Open.”
  • Step 3. Now, if you want to add this Excel spreadsheet as a link, select the 'Link' checkbox, otherwise leave it blank.
  • Step 4. Now click 'OK,' and it will be importing the data from your selected excel file.

Note 1: To add specific rows and columns from an Excel Spreadsheet, select the desired cells, copy them, move back to PowerPoint, click 'Paste' > 'Paste Special,' and then select HTML Object. By doing this, you will be able to insert the selected cells from Excel to PowerPoint.

Note 2: To add a blank sheet, click 'Insert' > 'Object' and select Microsoft Excel Worksheet from the Insert Object message box. It will add a blank Excel Spreadsheet to PowerPoint, and you can add and format the data as per your requirements.

The Best PDF Editor - PDFelement

Well, we were wondering if you are also looking for the best PDF editor using which you can perform all the PDF-related tasks in the same software. So, we have brought you the best PDF software, such as PDFelement. It is the best PDF editor equipped with lots of useful and powerful features. Some of the most powerful features of PDFelement are:

  • PDF Creation – You can create PDF files with full ease and control.
  • PDF Editing – PDF editing has become a piece of cake with PDFelement, and you can edit your PDF documents easily.
  • Form Creation – It allows you to create highly customized forms with one click. You may also edit other forms or fill a form as easy as filling a form in Word format.
  • OCR (Optical Character Recognition) – OCR enables you to read and extract data from scanned documents. You can either edit this data in PDFelement or save it in several other formats, including CSV.
  • Stylizing PDF Files – It has the ability to add annotations, comments, highlights, headers, footers, images, backgrounds, colors, and much more to your PDF files.
  • Other Options – There are a plethora of other features and functionalities in PDFelement, and this powerful tool is a perfect match for any business or an individual.

How to Convert Excel into PowerPoint

When it comes to converting different file formats, PDFelement is the boss. Using this software, you can easily convert Excel to PowerPoint format. Let’s find the step-by-step tutorial below.

  • Step 1. Launch PDFelement and open the Excel file in it. While you open the file, it will automatically be converted into the PDF format. So, save the file in PDF format to move to the next step.
  • Step 2. After it is saved, you can click “Convert” > “To PPT.”
  • Step 3. Once all the processing is done, save the file and use it as per your requirements.

So, this is how you convert Excel to PowerPoint with PDFelement. Using the same method, you can convert a plethora of different file formats to others. Some of the other useful file formats supported by PDFelement are RTF, HTML, EPUB, Word, and much more. You can also run OCR to convert images to PowerPoint. So, PDFelement is a complete package that can add value to your business and increase your productivity by saving your time and cutting costs.

Free Download or Buy PDFelement right now!

Free Download or Buy PDFelement right now!

Buy PDFelement right now!

Buy PDFelement right now!

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. So it is very important to know How to Convert Excel Worksheet to PowerPoint Slide. In this article you will learn how to convert Excel worksheet to PowerPoint slide with 6 ways.

Outlines:

1. Copy and Paste Excel Data into PowerPoint

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.

Tips: There are five Paste options that you can choose: Use Destination Styles, Keep Source Formatting, Embed, Picture, Keep Text Only. You can move your mouse to each Paste option to see a preview effect of the template.

Step 3. Click Save to save changes after you complete.

2. Link an Excel Worksheet to PowerPoint

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.

Excel powerpoint training

Step 1. Open Microsoft PowerPoint and go to Insert tab, click Object button under the Text section.

Step 2. After Insert Object pops up on the screen, select Create from file.

Step 3. Click the Browse button to locate to your Excel data that you want to insert to PowerPoint, tick the Link button and then click OK.

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.

3. Link a Section of Excel Data to PowerPoint

Sometimes you don't want to link the whole content Excel data to the PowerPoint slide, you can link a section of data in Excel to PowerPoint by the following steps.

Step 1. Select and copy the data on the Excel file, open the target slide and go to Home and then click the inverted triangle under the Paste, select Paste Special (Ctrl + Alt + V).

Step 2. In the dialogue box of Paste Special, select Paste Link, and choose Microsoft Excel Worksheet Object, and then click OK.

Excel Powerpoint Word Access

Tips: If the source Excel file is renamed by you or you move the source file to another location, the linked file would be unavailable. So the changes on the source Excel file will not be reflected and updated directly on the PowerPoint slides.

4. Embed an Excel Worksheet into PowerPoint

To embed an Excel worksheet in PowerPoint slide, there is no connection between each other. So updating the original Excel worksheet doesn't automatically update the data in the slide.

Step 1. Select and copy the data on Excel file, open the target slide, go to Home> Paste> Paste Special.

Step 2. In the dialogue box of Paste Special, select Paste, and choose Microsoft Excel Worksheet Object, and then click OK.

5. Export Excel Data into PowerPoint as an Image

If you don't want to change or update the data in the slide from the Excel file anymore, you can choose to convert Excel to PPT slide as a picture. Any change on the original Excel file will not be reflected on the PowerPoint slide.

Step 1. Select and copy the needed Excel data, locate to Home> Paste> Paste Special on the target PowerPoint slide.

Step 2. In the dialogue of Paste Special, select Paste, choose Picture (Enhanced Metafile), and then click OK.

Excel Powerpoint

6. Reproduce Excel Worksheet in PowerPoint

You can insert Excel data into PowerPoint by reproducing Excel data in PowerPoint.

Excel Powerpoint Word

Step 1. Open Microsoft PowerPoint and go to the target slide.

Excel Powerpoint

Step 2. Go to the Insert tab and click the inverted triangle under the Table tab to define the table size.

Excel In Powerpoint Presentation

Step 3. Select and copy the data on the Excel file, and then go back to PowerPoint slide and paste these data to the new table on it.

Related Articles: