Get Access Now

Learn How To Insert Table From Excel Spreadsheet In PowerPoint

Mar 10, 2023
how-to-insert-table-from-excel-spreadsheet-in-PowerPoint

Do you need to transfer final data reports from an Excel spreadsheet to a PowerPoint presentation?

Don't miss this! We'll share how to insert tables from an Excel spreadsheet into a PowerPoint presentation.

In this article, we will walk through the following:

  • Copy and paste Excel data to a PowerPoint presentation

  • Use the "Paste Special" feature

  • Use the Object option

  • Answer frequently asked questions about inserting tables from Excel spreadsheets in PowerPoint.

https://www.simpleslides.co/freebie-offer-1

Discover the Different Ways of Adding Tables from Excel Spreadsheets to PowerPoint Presentations

Copy and paste Excel data to a PowerPoint presentation

To quickly transfer Excel data to a PowerPoint presentation, follow these steps:

  1. Open the Microsoft Excel worksheet containing the data you want to insert in PowerPoint.

    Open an Excel file where you have the table from your PowerPoint data.
  2. Select or highlight the Excel table, then right-click on it. A drop-down menu will appear. Select "Copy."

    Highlight your Excel data and right-click on it. in the dropdown menu select "Copy"
  3. Open your Microsoft PowerPoint and select the slide where you want to insert the table.

    Open the PowerPoint file and select a PowerPoint slide where you want to put the Excel spreadsheet.
  4. Right-click the slide and select "Paste" from the drop-down menu.

    Right-click the slide and choose paste, to insert your excel spreadsheet data.

Quick Tip: Press Ctrl+C when copying the data and Ctrl+V when pasting it.

https://www.simpleslides.co/freebie-offer-1

Using the "Paste Special" feature

If you want to use the second method in transferring your final data from Excel to your PowerPoint presentation, you must:

  1. From your Microsoft Excel worksheet, copy the data you want to transfer to your PowerPoint presentation.

    Copy your Excel spreadsheet in your Excel file.
  2. Select the slide in your Microsoft PowerPoint presentation where you want to insert the Excel data.

    Go to your presentation, and click an existing slide where you wish to inset the Excel worksheet.
  3. Navigate the "Paste Options" group, and click the arrow under the "Paste" icon. Then, in the drop-down menu, select "Paste Special."

    In the Clipboard group, click the arrow under "Paste" option and select "Paste Special" in the dropdown menu.
  4. The "Paste Special" dialog box will appear. Click "Paste link" and select the "Microsoft Excel worksheet object" option. Then, click "OK."

    In the dialog box of "Paste Special," click "Paste link" and click Microsoft Excel worksheet object." Then choose "OK"
  5. Your Excel table will now appear on your presentation slide.

    once you click ok your excel table will appear on your presentation.

Using the Object option

To use the Object option to insert a Microsoft Excel table into PowerPoint, you must do the following:

  1. In your PowerPoint presentation, select the slide where to want to insert Excel data.

    In your presentation select a PowerPoint Slide.
  2. Select the "Insert" tab, then click the "Object" option.

    In the "Insert" tab, navigate and select "Object" option.
  3. In the "Insert Object" dialog box, choose the "Create from file" option and click the "Browse" button.

    in the dialog box of "Insert Object," click "Create from file" and click "browse."
  4. A "Browse" dialog box will open. Go to the file location of your Excel tables and click it. Then, select "OK."

    once you click "Browse" look for the file location of the Excel file and click it. Then select "OK" button.
  5. Once you're back to the "Insert Object" dialog box, check the box beside "Link," then click "OK."

    check the box beside "Link" and click "Ok" button.

Final Thoughts on How to Insert Table From Excel Spreadsheet in PowerPoint Slide

If you have trouble inserting tables from Excel worksheets into your following PowerPoint presentations, our shared methods will help you.

For more how-to posts about PowerPoint presentations, subscribe to Simple Slides. Take advantage of our 80% discount and get access to 10,000+ slides, templates, and infographics!

Frequently Asked Questions on How to Insert Tables from Excel Spreadsheets in PowerPoint:

How can I copy the tables from the Excel workbook to the PowerPoint slide with source formatting?

You can access the "Keep Source Formatting" function for simple editing. You can access several formatting options whenever you copy and paste Excel data into a PowerPoint presentation.

What are the different paste options available in Microsoft PowerPoint and Microsoft 365?

There are five different paste options available in Microsoft Office, including:

  1. Use Destinations Styles

  2. Keep Source Formatting

  3. Embed

  4. Picture

  5. Keep Text Only

What are the shortcut keys in doing "Paste Special"?

The shortcut keys for the "Paste Special" dialog box are Alt+H+V+S.

https://www.simpleslides.co/freebie-offer-1 

Related Articles:

Discover How to Add Tables in PowerPoint: Everything You Need to Know

Learn How To Insert a GIF Into PowerPoint In 2 Ways

How To Flip An Image In PowerPoint In 5 Easy Steps

Get A Free Sample of Our Award-Winning PowerPoint Templates + University

Take Me To My Free Offer

Get A Free Sample of Our Award-Winning PowerPoint Templates + University

Join our mailing list to receive the latest news and updates from our team.
Don't worry, your information will not be shared.

We hate SPAM. We will never sell your information, for any reason.