importing an EXCEL object into powerpoint
importing an EXCEL object into powerpoint
(OP)
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
thanks in advance .... gary





RE: importing an EXCEL object into powerpoint
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)
RE: importing an EXCEL object into powerpoint
many thanks ..... Gary
RE: importing an EXCEL object into powerpoint
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?
RE: importing an EXCEL object into powerpoint
> 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: Eng-Tips.com Forum Policies
RE: importing an EXCEL object into powerpoint
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.
RE: importing an EXCEL object into powerpoint
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
RE: importing an EXCEL object into powerpoint
Robert Mote
www.motagg.com