How to show sheets from Microsoft Excel to PowerPoint presentation

- Advertisment -
- Advertisement -

Microsoft PowerPoint is the program of choice for most users when it comes to creating presentations for the plethora of tools that it had to offer. From displaying images in a presentation to texts and illustrations, it is possible to deal with everything with the help of Microsoft PowerPoint.  But once in a while, when it comes to dealing with presentations for your office or workplace, you need to embed some sort of data into a PowerPoint slide. Depending upon the type of data that you want to add to a slide in Microsoft PowerPoint, there are numerous ways of doing that, and I will talk about one of the most generic ways of entering data, today.

Microsoft Excel is one of the best applications to deal with data, and sometimes it becomes important to show data from Microsoft Excel to a Microsoft PowerPoint slide. Let me make it a bit clear to you. You might have a table in Microsoft Excel containing some important data, and you need to show that table in Microsoft Excel. In the first place, you can capture the screenshot of the table and use it as an image on a Microsoft Excel slide. But that isn’t the best way of embedding Excel tables or data into a Microsoft PowerPoint slide. There is a direct and better way to directly embed selected Excel tables into Microsoft PowerPoint, and I will talk about that here.

So, without any further delay, let’s get started with, how you can embed tables from an Excel sheet to Microsoft PowerPoint.

There are two ways, you can actually do this. You can either create an Excel sheet within Microsoft PowerPoint, or you can even add the sheet from an existing file to Microsoft PowerPoint.

Creating a new Excel datasheet

I will talk about, how you can create a new Microsoft Excel sheet within Microsoft PowerPoint first. 

Open Microsoft PowerPoint, and proceed with creating a new presentation. Now, click on the ‘Insert’ tab, and then click on ‘Object’.

Insert object in powerpoint
Insert object in PowerPoint


The option that says ‘Create new’ will be kept selected by default. Hence select ‘Microsoft Excel Worksheet’ from the list under ‘Object type:’, and then click on ‘OK’.

Select Microsoft Excel Worksheet
Select Microsoft Excel Worksheet

Now, you can get a miniature Excel sheet, where you can enter the values at ease. You can also apply all types of formatting exactly the way you do on Microsoft Excel, as all those formatting options will be available.

miniature Excel sheet
miniature Excel sheet

After you are done editing the sheet, just press the ‘Esc’ button on your keyboard, or click anywhere outside the sheet, and the data will be present in front of you in form of a table.

add some data to the presentation
add some data to the presentation

The ability to create a fresh Microsoft Excel sheet can be useful if you want to quickly add some data to the presentation, and you want to get access to all the features available on Microsoft Excel, as well.

Add data from an existing Microsoft Excel datasheet

But, if you want to add bulk data to a presentation, or you have existing data the above method is not going to be useful for you. It is a tough exercise to concentrate on entering data and design the presentation at the same time.

So, if you want to add an existing Microsoft Excel datasheet to PowerPoint, just click on the ‘Objects’ button, and then select ‘Create from file’. Now, click on ‘Browse…’ to select the spreadsheet containing your datasheet, and click on ‘OK’.

Microsoft Excel datasheet to PowerPoint
Microsoft Excel datasheet to PowerPoint

 

Now you can get the content of the datasheet within your presentation. You can also make the necessary changes to the spreadsheet object, however, that will not update the original file containing the presentation.

content of the datasheet within your presentation
content of the datasheet within your presentation

After you have made the necessary changes to the presentation, you can simply click outside the object and Microsoft PowerPoint will treat the datasheet as a normal table. 

Add Excel sheets to PowerPoint
Add Excel sheets to PowerPoint

One thing that you should note is that, if you make changes to the original files, the changes will not be reflected in the PowerPoint presentation. So, live updates to the presentation will not take place. But, that is not a trouble as you can at least get your job done when it comes to embedding Excel sheets in a Microsoft PowerPoint presentation. This is the best way to do that.

So, that was all about, how you can embed a Microsoft Excel sheet into a Microsoft PowerPoint presentation. Do you have any questions or faced any problems? Feel free to comment on the same below.

Sarbasish Basuhttps://www.how2shout.com/
From B.Tech (Hons.) Electronics & Instrumentation Engineer to Photography and Writing blogs; he ultimately has answers to everything. Oh, and he's also quite good in rapidly building a relationship and set up the trust; his articles are proof of that...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Latest Posts

What is Aarogya Setu app and how to use it against COVID-19

Aarogya Setu is an app designed and developed by the India Government (ministry of electronics and IT) for Android...

How to enable Ubuntu 20.04 LTS Dark mode

Like Android and Windows, the Dark mode theme option is also available on Ubuntu 20.04 LTS Focal Fossa, thus...

4 Best Tablets in the Range of 10K to 20K in 2020

Most of us just love tablets and are also proud owners of the same, while many of us are...

How to record voice calls on Samsung handset without any third-party app

The simplest way to communicate with people not in front of us is to do voice calls. But from...
- Advertisement -

Benefits of using masks in tackling coronavirus outbreak

The world is in the middle of a never-seen-before battle against the global pandemic of Covid-19 aka Coronavirus, and...

Interaction with Vinay Agrrawal Founder & CEO, Hubbler – Digital Transformation platform

Digitising a business process into an app takes too long, and costs too much money. Owing to these high...

- Advertisment -
- Advertisement -

You might also likeRELATED
Recommended to you