How to Copy Table from Excel to Powerpoint with Formatting

Get FREE Advanced Excel Exercises with Solutions!

While working in Microsoft Excel sometimes we need to copy table from Excel to PowerPoint with formatting. You can do it easily by copying and pasting it to PowerPoint as a table or image. Today, in this article, I am sharing with you how to copy table from Excel to PowerPoint with formatting. Stay tuned!


How to Copy Table from Excel to PowerPoint with Formatting: 2 Quick Methods

In the following, I have described 2 quick and easy methods to copy table from Excel to PowerPoint with formatting using some simple tricks.

Imagine we have a dataset of some Car company Name and Their Brand Value in an Excel worksheet. Now we will copy the whole table to PowerPoint with formatting.


1. Use Paste Special Feature to Copy Table with Formatting

If you are looking for a quick solution to copy table from Excel worksheet to PowerPoint with the exact same formatting then you are at the right place. Follow the instructions below-

Steps:

  • First, choose the whole table and press CTRL+C to copy.

Use Paste Special Feature to Copy Table with Formatting

  • Second, open your Powerpoint file and hit “Paste Special” from the Home ribbon.

Use Paste Special Feature to Copy Table with Formatting

  • Next, select “Microsoft Excel Worksheet Object” and press OK to continue.

  • Finally, you will get the table copied as an image to PowerPoint with formatting. Simple isn’t it?

Use Paste Special Feature to Copy Table with Formatting

Read More: How to Perform Excel to PowerPoint Automation


2. Utilize Paste Options to Copy Table to PowerPoint with Formatting

In some cases, you might want to copy table and paste it to PowerPoint with formatting and change the data of the table at the same time. Well, here I have an easy solution for this.

Steps:

  • Presently, choose the whole table from the worksheet and click “Copy” from the options that appeared by right clicking the mouse button.

  • Now, open the PowerPoint document where you want to paste the table.
  • Choosing the slide, right click the mouse button and hit “Keep Source Formatting” from the “Paste” options.

Utilize Paste Options to Copy Table to Powerpoint with Formatting

  • Hence, the exact table from the Excel worksheet will be copied. Let’s check whether we can edit the table data or not.

Utilize Paste Options to Copy Table to Powerpoint with Formatting

  • To do so, select the last row with data and press DELETE.

  • In conclusion, you will see that the data from the last row will disappear. Here, we have successfully copied table from Excel to PowerPoint with formatting and edited our table without any hesitation.

Utilize Paste Options to Copy Table to Powerpoint with Formatting

Read More: How to Copy Chart from Excel to PowerPoint Without Link


How to Solve If Embedded Excel in Powerpoint Not Showing All Data

You can also embed Excel documents directly into PowerPoint. But in some situations, you will see all data is not showing in the PowerPoint file. In this situation, you can follow the instructions below to get all the data in your desired place.

Problem:

  • First, let’s start with attaching an Excel file by clicking “Object” from the “Insert” option.

Solve If Embedded Excel in Powerpoint Not Showing All Data

  • Then, choose “Create from file” and press “Browse”.

  • Now, from the new window choose your desired Excel workbook and click OK to continue.

  • After the Excel workbook is selected checkmark the “Display as icon” option and Hit OK.

Solve If Embedded Excel in Powerpoint Not Showing All Data

  • Thus, you will get the Excel icon instead of the data from the workbook. Let’s move on to the solution to this problem.

Solve If Embedded Excel in Powerpoint Not Showing All Data

Solution:

  • When the Excel workbook is uploaded checkmark the “Link” option and press OK to continue.

Solve If Embedded Excel in Powerpoint Not Showing All Data

  • This time, you will see all the data from the Excel workbook will be displayed over the PowerPoint slide. Enjoy!

Solve If Embedded Excel in Powerpoint Not Showing All Data

Read More: How to Insert Excel Chart into PowerPoint


Things to Remember

  • You can not copy and paste formulas from an Excel Worksheet into a PowerPoint slide as the software is unable to read it.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

In this article, I have tried to cover all the methods to copy table from Excel to PowerPoint with formatting. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. Stay tuned and keep learning.


Related Articles

<< Go Back to Excel to PowerPoint | Export Data from Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo