Isolda has attended:
PowerPoint Introduction course
Inserting worksheets into PowerPoint
Please can you tell me how I insert an entire spreadsheet including all worksheets into a powerpoint presentation? I have tried inserting object with each worksheet but is there a quicker way?
Also, one of the worksheets that I've inserted brings with it a load of empty columns - is there a way I can insert this without including these? I have tried to copy & paste it but it shrinks and then it doesn't match the size of the other worksheets that were successfully inserted.
Thanks,
Isolda
RE: Inserting worksheets into PowerPoint
Insert Object is a very good way of creating inserted worksheet, because it takes the entire workbook in. If you just copy and paste, then there is no structure that comes with it.
Seems like you are doing the right thing by using INSERT > OBJECT.
Regarding the empty columns, can you resize the window that the worksheet shows, by dragging the edge on a black box.
Regards
Richard
RE: Inserting worksheets into PowerPoint
Hi Richard,
Thank you for your response. However, I have tried this, and it is only inserting one worksheet at a time - laborious! Is there a way of inserting object for a spreadsheet that inserts the entire load of worksheets?
Thanks,
Isolda
RE: Inserting worksheets into PowerPoint
As far as I know, you can only insert one object at a time.
Regards
Richard
RE: Inserting worksheets into PowerPoint
Oh I see. I thought you said it would insert an entire workbook? I thought that was one whole object?
Thanks,
Isolda
RE: Inserting worksheets into PowerPoint
As far as I know, when you insert an object, it will insert the whole workbook. If you double click on the image, the sheet will open and look like an excel sheet, not just a table. You are able to switch between the sheets that are available in that workbook, and show one at a time.
Does that clarify how it works?
Regards
Richard
RE: Inserting worksheets into PowerPoint
Thanks Richard. Actually it does not seem to be possible to insert an entire workbook as one object - I have tried unsuccessfully to do this. Yes it is possible to insert each worksheet from a workbook one at a time, and yes it appears as a spreadsheet and not just a table, - but not the whole workbook. I am a little confused as you say it is possible to insert the entire workbook as one object.
Also, when inserting one of the worksheets of this particular workbook, the empty columns show and take up unnessessary space on the page. Any tips on how to trim this down?
Many thanks,
Isolda
RE: Inserting worksheets into PowerPoint
INSERTING WORKBOOKS
INSERT > OBJECT
Select CREATE FROM FILE
Browse > Locate file
OK.
This will insert an entire workbook. If you double click on it, you are able to select one worksheet from that workbook to show.
REDUCE COLUMNS.
Double click on worksheet
Drag the right edge of the window left to show only the column you want.
Click off the worksheet
Resize to your requirement.
Does that answer your questions?
Regards
Richard
