×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

importing an EXCEL object into powerpoint

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

RE: importing an EXCEL object into powerpoint

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)

RE: importing an EXCEL object into powerpoint

(OP)
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

RE: importing an EXCEL object into powerpoint

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?

RE: importing an EXCEL object into powerpoint

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: Eng-Tips.com Forum Policies

RE: importing an EXCEL object into powerpoint

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.

RE: importing an EXCEL object into powerpoint

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

RE: importing an EXCEL object into powerpoint

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
www.motagg.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources