Insert a scrolling worksheet in Powerpoint

[subek]

I am using Powerpoint 2003. I need to insert a long Excel spreadsheet into a
single slide and animate it to scroll through the entire sheet. Any ideas how
to accomplish this? Thanks.

 

[Sandy Johnson]

Let me know if this is what you're looking for:

On your desired slide go to:
View > Toolbars > Control Toolbox
Click on More Controls (lower right hand corner of Toolbox dialog box)
Scroll to find Microsoft Office Spreadsheet 11.0
Your cursor will change into a crosshair or plus sign
Click and drag a box shape on your slide -- a blank spreadsheet will appear
in the area.

Go to your original Excel spreadsheet. Select the area you want in the
PowerPoint and Copy.

Return to your PowerPoint slide.
Right click on the *spreadsheet* you just created with Control Toolbox
Select Microsoft Office Spreadsheet 11.0 > Edit
Paste the Excel Spreadsheet
Exit the Control Box (click outside of the Control Box)

View in Slide Show View. If the spreadsheet you pasted into the Control Box
is larger in area than the box you drew, the scroll bars will appear,
allowing you to scroll within the spread sheet.

Hope this helps. This was taught to me by Brian Reilly.

Sandy

 

[diane]

Sandy, this is a fantastic tip! Thanks so much for sharing!

 

[Peter]

Great tip Sandy

FWIW, it works in PowerPoint 2007 too.

Peter

 

[subek]

This is fabulous ... I would have never found this on my own! One more
question ... is there a way to animate it to automatically scroll or does
that have to be done manually in the presentation?

Thanks Sandy (and Brian!)

 

[Sandy Johnson]

You'll have to do it manually using this method.

You could fake it by placing a copy of the spreadsheet under a mask on the
slide. Animate the spreadsheet using an upward motion path.

Sandy

 

[Sandy Johnson]

Thanks Peter.

Great tip Sandy

FWIW, it works in PowerPoint 2007 too.

Peter

 

[diane]

Sandy, is there a way to insert a Word document and scroll through it?

 

[Sandy Johnson]

diane,

You can paste content from a Word doc into the same Microsoft Office
Spreadsheet 11.0 box. When you right click on the box and hit Commands and
Options > Sheet. Then uncheck the Gridlines box (you can also unchecker Row
and Column headers here). Other formatting can be performed within Commands
and Options.

For all practical purposes, you will appear to have a scrolling *Word* doc

 

[diane]

Thank you Sandy! Can't wait to share this tip with my coworkers!

 

[lmac]

Is there a way to show a powepoint slide show within a slide of a different
powerpoint slide show? Just like you added the excel sheet is it possible to
add a powerpoint slide show to play within a slide of a main show? The reason
I'm asking is that I want the sub-show to transition on the screen while the
heading on the main show will stay static.

Thank you!

 

[Robert McA]

This DOES NOT work in Powerpoint 2007
The object it creates is a solid box, and any attempt to click on that box simply brings up the nest slide.

Check the web, hundreds of folks have this issue and are yelling about it. Guess I will try 2010 and see if it helps in anyway.

 

[mjohn1223]

Let me know if this is what you're looking for:

On your desired slide go to:
View > Toolbars > Control Toolbox
Click on More Controls (lower right hand corner of Toolbox dialog box)
Scroll to find Microsoft Office Spreadsheet 11.0
Your cursor will change into a crosshair or plus sign
Click and drag a box shape on your slide -- a blank spreadsheet will appear
in the area.

Go to your original Excel spreadsheet. Select the area you want in the
PowerPoint and Copy.

Return to your PowerPoint slide.
Right click on the *spreadsheet* you just created with Control Toolbox
Select Microsoft Office Spreadsheet 11.0 > Edit
Paste the Excel Spreadsheet
Exit the Control Box (click outside of the Control Box)

View in Slide Show View. If the spreadsheet you pasted into the Control Box
is larger in area than the box you drew, the scroll bars will appear,
allowing you to scroll within the spread sheet.

Hope this helps. This was taught to me by Brian Reilly.

Sandy

Hi Sandy,

Just coming across this. I am using PPT 2010. I would love to be able to do this in 2010. Only thing is, I don't see a "control toolbox" in the View tab. Is this someplace different in 2010? Thanks.

MJ

 

[mjohn1223]

Let me know if this is what you're looking for:

On your desired slide go to:
View > Toolbars > Control Toolbox
Click on More Controls (lower right hand corner of Toolbox dialog box)
Scroll to find Microsoft Office Spreadsheet 11.0
Your cursor will change into a crosshair or plus sign
Click and drag a box shape on your slide -- a blank spreadsheet will appear
in the area.

Go to your original Excel spreadsheet. Select the area you want in the
PowerPoint and Copy.

Return to your PowerPoint slide.
Right click on the *spreadsheet* you just created with Control Toolbox
Select Microsoft Office Spreadsheet 11.0 > Edit
Paste the Excel Spreadsheet
Exit the Control Box (click outside of the Control Box)

View in Slide Show View. If the spreadsheet you pasted into the Control Box
is larger in area than the box you drew, the scroll bars will appear,
allowing you to scroll within the spread sheet.

Hope this helps. This was taught to me by Brian Reilly.

Sandy

Ok, so I was able to turn "on" the developer tab. However, in the control toolbox, under "more controls" I did not see an option for Microsoft OfficeSpreadsheet 11.0, or anything of that nature. There were tons of other options, i.e. Microsoft Forms 2.0, Microsoft RFP Client Control, etc. But nothing for a spreadsheet. Could it be somewhere else?

Thanks.

MJ