In a PowerPoint 2010 presentation, you can insert a linked Excel worksheet or a portion of data from a linked spreadsheet, and copy a selection of cells to a slide. Here’s a guide discussing in 3 parts:
Part 1 Insert a linked Excel worksheet to PowerPoint 2010
To insert and link a saved Excel spreadsheet onto your PowerPoint slide, do the following:
Note - The linked object in your presentation displays all data from the active, top spreadsheet in the linked Excel workbook.
1. In PowerPoint 2010, on the Insert tab, in the Text group, click Object.
2. In the Insert Object dialog box, select Create from file.
3. Click Browse, and in the Browse dialog box, browse to and then select the Excel workbook that contains the information that you want to insert, and then click OK.
4. In the Insert Object dialog box, select Link and then click OK.
To edit a linked Excel spreadsheet, do one of the following:
• To edit the data from within Excel, right-click the object on the slide, point to Linked Worksheet Object, and select Edit.
• To update the data on the slide to match the data in the original Excel file, right-click the object on the slide, and click Update Link.
Part 2 Insert a linked selection from a spreadsheet to PowerPoint 2010
To insert and link a selection of data from a saved Excel spreadsheet, do the following:
1. In Excel, open the workbook containing that data that you want to insert.
2. Select and copy the data that you want.
Keyboard shortcut You can press CTRL + C to copy the data.
1. In PowerPoint 2010, click the slide where you want to paste the copied worksheet data.
2. On the Home tab, in the Clipboard group, click the arrow below Paste, and select Paste Special.
3. In the Paste Special dialog box, under As, select a Microsoft Excel Worksheet Object.
4. Select the Paste link check box and click OK.
To edit a selection of cells from a linked Excel spreadsheet, do one of the following:
• To edit the data from within Excel, right-click the object on the slide, point to Linked Worksheet Object, and select Edit.
• To update the data on the slide to match the data in the original Excel file, right-click the object on the slide, and click Update Link.
Part 3 Copy a selection of Excel cells onto a slide in PowerPoint 2010
To paste a copy a selection of Excel data onto your PowerPoint slide, do the following:
Note- Data copied and pasted onto a PowerPoint slide does not automatically update when the data is changed in the Excel workbook. To link the data on the PowerPoint slide to the original Excel data source, see Insert a linked selection from a spreadsheet.
1. In Excel, open the Excel workbook that contains the information that you want to copy.
a. Select and copy the data that you want.
Keyboard shortcut You can press CTRL + C to copy the data.
b. In PowerPoint 2010, click the slide where you want to paste the copied worksheet data.
c. On the Home tab, in the Clipboard group, click the arrow below Paste.
d. Under Paste Options, do one of the following:
1. Select Keep Source Formatting if you want to copy the data as a PowerPoint table, but want it keep the appearance of the original Excel spreadsheet.
2. Select Use Destination Styles if you want to copy the data as a PowerPoint table, but want it to assume the appearance of the PowerPoint presentation.
3. Select Embed if you want to copy the data as information that can be edited in Excel.
4. Select Picture if you want to copy the data as an un-editable picture.
5. Select Keep Text Only if you want to copy all the data as a single text box.
31 Comments to 'Learn Latest PowerPoint: Insert Excel Worksheets to PowerPoint 2010'
Subscribe to comments with RSS or TrackBack to 'Learn Latest PowerPoint: Insert Excel Worksheets to PowerPoint 2010'.
:: Trackbacks/Pingbacks ::
-
Pingback by Learn Latest PowerPoint: Insert Excel Worksheets to PowerPoint … « PPT Converter - on November 18th, 2009 at 5:23 am
-
Pingback by is there a way to create a windows error message when i open a file? | Windows XP Repair - on November 23rd, 2009 at 4:02 pm
-
Pingback by I’m kinfa slow, and need a ABC-123 answer to put music and slide show on to CD? | Answer For Article - on November 28th, 2009 at 3:43 am
-
Pingback by PowerPoint 2010 Tips: Slide Show Shortcuts in PowerPoint 2010 Presentation | PowerPoint E-learning Center - on December 6th, 2009 at 11:24 pm
-
Trackback by oplzchzc - on December 30th, 2009 at 3:59 pm
-
Trackback by imamgrvt - on December 30th, 2009 at 5:40 pm
-
Trackback by zignwqva - on December 30th, 2009 at 5:59 pm
-
Trackback by drvozizm - on December 31st, 2009 at 2:11 am
Leave a Reply
Keep posting stuff like this i really like it.
I have been searching for weeks trying to get my hands on the latest trading software, I finally found a great website full of information.
Great post this will really help me.
Forex trading really changed my life, although I must admit I really battled to get my head around some of the concepts, once I got going for real I have been doing really well.
The GBPUSD has squeezed higher to test the 38.2% retracement and th 100 bar MA on the 5 minute chart. A move above targets the 1.6182 level where the 200 day MA is found. This is key resistance. On the downside, the move above the 1.6144 level now makes that level the support level to get through for the sellers up here. We will be watching that level on the downside.
Just thought i would comment and say neat theme, did you code it yourself? Looks great.
Just thought i would comment and say neat design, did you code it yourself? Looks great.
Thank you for taking time to write such a useful to read article on this subject.
I was searching for photography when I found your site. Great post. Thank You.
This guy does a pretty good job of going over automated forex trading robots. He likes Forex-Megadroid Pro.
This guy does a pretty good job of going over automated forex trading robots. He likes Forex-Megadroid Pro.
Hi just thought i would tell you something.. This is twice now i’ve landed on your blog in the last 3 days hunting for completely unrelated things. Spooky or what?
that was really helpful.. i spent a long time in ppt trying to find it… but i couldnt. after I read this i managed to figure it out. thanks alot folks
Hi, i must say fantastic site you have, i stumbled across it in AOL. Does you get much traffic?
Just thought i would comment and say neat theme, did you code it yourself? Looks great.
Great information! I’ve been looking for something like this for a while now. Thanks!
Great information! I’ve been looking for something like this for a while now. Thanks!
Great site. A lot of useful information here. I’m sending it to some friends!
Which Word Press template are you using?
I am always searching online for articles that can help me. Thank you
You can tally me in for a Digg. Thanks for posting this on your blog!
I lean toward utilizing computerized systems myself, but I can clearly accept the points you’re espousing here. You’ve broader background and more accurate insights than many of the so-called expert who are spouting off about trading on the internet. Thank you for the useful comments.
thanks !! very helpful post!