inserting excel sheet into
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

resolvedResolved · High Priority · Version 2002/XP

replyReply Thu 10 Apr 2008, 11:00Delegate Maria said...

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!

For upcoming training course dates see: Pricing & availability

replyReply Thu 10 Apr 2008, 14:08 Edited on Thu 10 Apr 2008, 14:09Trainer Pete said...

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

 

Please browse our web site to find out more about
powerpoint.courses and other Microsoft training courses.

Powerpoint tip:

Running a Show from the Keyboard

To start a show from the keyboard, press F5. You can move from slide to slide with cursor keys, or use N for Next and P for Previous.

View all Powerpoint hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard