Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

inserting excel sheet into

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Inserting an excel sheet into a PowerPoint presentation

Inserting an excel sheet into a PowerPoint presentation

ResolvedVersion 2002/XP

Maria has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course

Inserting an excel sheet into a PowerPoint presentation

Hi,

I'm inserting an object - a linked excel sheet to my presentation. I can do this no problem, however I'm not able to specify the content how I want it. I'm getting empty rows and columns below and on the left of table. How do I get rid of them?

Also how do I get rid of the grey borders in my table in my presentation? I would like only those borders that I've drawn to show on the PP.

Thank you!

Edited on Thu 10 Apr 2008, 14:09

RE: Inserting an excel sheet into a PowerPoint presentation

Hi Maria,
Thank you for the post, in answer to you question; this may be down to the Excel worksheet and not so much to PowerPoint. In the first part of your question; ensure that there is no data outside the table you wish to link, eg there may be a space in one cell which will cause those cells to be included in your link. Also your worksheet should start in A1.
In the second part of your question, again in Excel you need to switch off the gridlines before you link the worksheet, to do this go to menu comand Tools>Options and in the View tab you will see the option to switch off the grid lines, have a go and good luck, best regards Pete

PowerPoint tip:

Paste a web address into the hyperlink address field

If you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work.

View all PowerPoint hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.