How to Insert an Excel Worksheet in PowerPoint 2010

Topic: Excel, Microsoft Office, Office, PowerPoint Product: Microsoft Excel , Microsoft Office Related Articles: powerpoint worksheets unlink worksheet powerpoint embed excel worksheet pi processbook

As in former versions of Microsoft Excel, you can link data from a saved Excel spreadsheet or copy cells from an Excel spreadsheet into your Microsoft PowerPoint 2010 presentation.

sponsored ads

Solution

Open Microsoft PowerPoint application. Click "Insert" > "Text" > "Object".
In the "Insert Object" dialog box, click "Create from file" and then "Browse" button.
Select your wanted Excel document from your files. Then check "Link"and click "OK".
Then you can see the Excel worksheet is inserted into the slide. Right click on it and choose "Linked Worksheet Object" > "Edit" to edit the data.

Insert an Excel Worksheet in PowerPoint 2010
Also, right click on the spreadsheet and choose "Update Link" in the list in order to update the data to match the data in the original Excel file.

Insert an Excel Worksheet in PowerPoint 2010

If you want to insert a linked selection from a spreadsheet, do the following steps.

Open the right worksheet and select the wanted part, table, chart or others like this. Then hit "Ctrl+C" keys.
In the PowerPoint presentation, click "Home" > "Paste" > "Paste Special" in the ribbon.
In the "Paste Special" dialog box, select "Paste link" and then "Microsoft Excel Worksheet Object" under "As" area. Then click "OK".
To paste a copy a selection of Excel data onto your PowerPoint slide, follow the steps below.
First, select the selection of data and press "Ctrl+C" keys on the keyboard.
Also, go to "Home" > "Paste" > "Paste Options" like this. Choose "Keep Source Formatting if you want to copy the data as a PowerPoint table".
Here, you can see the inserted excel data which keeps source formatting.
Select "Use Destination Styles" if you want to copy the data as a PowerPoint table like this.
Select "Embed" if you want to copy the data as information that can be edited in Excel.
Select "Picture" if you want to copy the data as an un-editable picture
The last option, select "Keep Text Only" if you want to copy all the data as a single text box.
Well done.

Tips

I need to insert tables from Excel to PowerPoint, and keep all the alignments and other format intact. But when I cut and paste to PowerPoint, tables lose their format and parts of the table become unreadable. How can I insert a whole table from Excel to PowerPoint?

How to Annotate a Worksheet with Comments in Excel 2010

You can add notes to a worksheet by using comments. Using comments can help you make a worksheet easier to understand by providing additional context for the data it contains. For example, you can use a comment as a note that provides information about data in an individual cell. You can also add a comment to a column heading to provide guidance on data that a user should enter.

How to Create a PivotTable from Worksheet Data in Excel 2010

A pivot table creates an interactive summary from many records. And in new Microsoft Excel 2010, the PivotTable has been replaced with "PivotTable" command on the "Insert" tab in the "Tables" group. It is a little different. Next, I will introduce how to create a PivotTable from Worksheet data in Excel 2010.

Search for Related Topics

insert organigram excel insert cagr excel insert diameter excel insert h2o excel insert nslookup excel insert octagon excel insert swimlane excel

Related Unresolved Questions