importing an EXCEL object into powerpoint

[GPowers2]

people. I am trying to insert an EXCEL object (create from file)into Powerpoint and cannot seem to capture the exact area of the spreadsheet I want (it seems to have a mind of its own) ..... any ideas on what to do to grab the cells I need ......

thanks in advance .... gary

 

[melone]

Does the following work?

In Excel:
- select the cells you want to copy (MUST be contiguous)
- press <CTRL>-C (or right click and copy)

In Powerpoint:
- press <CTRL>-V (or right click paste)

 

[GPowers2]

nearly worked ... it seems to work OK for a small number of cells that naturally fit the slide but mine was a large number of Cells that over ran the powerpoint slide area....it would not re-size as CTRL V ... but it was a start and since then I saved the picture as a .WMF file and re inserted ... allowing a full scale down to fit .... so thanks for the steer ... I have a solution ...

many thanks ..... Gary

 

[prost]

A couple of ideas.
1) try to make certain you can see the whole table on your screen before you highlight and copy.
2) When you paste into PowerPoint, use Paste Special/picture or Paste Special/picture (enhanced metafile). When you copy and then Paste a piece of Excel into PowerPoint, you are embedding a copy of this Excel spreadsheet into PowerPoint. It will allow you to go to the PowerPoint file directly to change some numbers in the table, but sometimes the Paste doesn't work so well, and forces you to do a bunch of workarounds to get the table to look like you want.

3)Of course if it's just a table you want to copy, why not create a table in PowerPoint, then copy the cell contents of the Excel worksheet to your slide?

 

[IRstuff]

I usually do the following:

> Create buffer rows and columns around the cells you want displayed
> Disable the grid line display
> Use the Border commands to format the borders of the cells you want displayed
> Copy the desired cells AND the buffer rows and columns and paste into Powerpoint. I generally paste as a DIB (bitmap) instead of an Excel object to avoid additional annoyances with formatting.


TTFN

FAQ731-376

 

[electricpete]

I agree, graphic format is easier if you don't have to change.

But if you want the flexibility to edit the data later, you should be able to work with the spreadsheet to display what you want. There are two types of resizing you can do once you have the worksheet object in powerpoint:

1 - Double click on spreadsheet to activate the spreadsheet for editing. Then when you drag on the handle you add or subtract cells from the displayed range.

2 - Double click on the slide outside of the spreadsheet to deactivate the spreadsheet. Then dragging on the size handle just resizes as if it were a graphic.

I do it quite often for small tables. It has not been a problem for me except when I don't have enough room on the slide to display everything (and have already tried making the font smaller).

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[IPGBen]

What works for me is to copy the cells in "Paint".
Then size the picture to the size that is oke for you and copy this in the slide that you want.
In this slide you can size the picture any size you like....

Grtz
Ben

 

[rtmote]

I often use the print screen button to capture the window view in Excel (or anything for that matter) then go to Powerpoint and paste it in. Now when you click on the image in Powerpoint you can crop it to suit and stretch.



Robert Mote

http://www.motagg.com