Insert a scrolling worksheet in Powerpoint

subek

unread,

Oct 1, 2008, 3:45:02 PM10/1/08

to

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

unread,

Oct 1, 2008, 5:48:01 PM10/1/08

to

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

unread,

Oct 1, 2008, 7:42:01 PM10/1/08

to

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

Peter

unread,

Oct 1, 2008, 11:36:46 PM10/1/08

to

Great tip Sandy

FWIW, it works in PowerPoint 2007 too.

Peter

subek

unread,

Oct 2, 2008, 8:08:02 AM10/2/08

to

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

unread,

Oct 2, 2008, 12:54:06 PM10/2/08

to

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

unread,

Oct 2, 2008, 12:55:02 PM10/2/08

to

Thanks Peter.

diane

unread,

Oct 2, 2008, 5:16:04 PM10/2/08

to

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

Sandy Johnson

unread,

Oct 2, 2008, 7:16:13 PM10/2/08

to

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
on your slide.

diane

unread,

Oct 4, 2008, 3:41:00 AM10/4/08

to

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

lmac

unread,

Oct 12, 2008, 2:50:01 PM10/12/08

to

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

unread,

Feb 6, 2011, 2:12:35 PM2/6/11

to

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.

> On Wednesday, October 01, 2008 3:45 PM sube wrote:

> 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.

>> On Wednesday, October 01, 2008 5:48 PM SandyJohnso wrote:

>> 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
>>
>>
>>
>>
>>
>> "subek" wrote:

>>> On Wednesday, October 01, 2008 7:42 PM dian wrote:

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

>>> "Sandy Johnson" wrote:

>>>> On Thursday, October 02, 2008 8:08 AM sube wrote:

>>>> 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" wrote:

>>>>> On Thursday, October 02, 2008 12:54 PM SandyJohnso wrote:

>>>>> 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
>>>>>
>>>>> "subek" wrote:

>>>>>> On Thursday, October 02, 2008 12:55 PM SandyJohnso wrote:

>>>>>> Thanks Peter.
>>>>>>
>>>>>> "Peter" wrote:

>>>>>>> On Thursday, October 02, 2008 5:16 PM dian wrote:

>>>>>>> Sandy, is there a way to insert a Word document and scroll through it?
>>>>>>>
>>>>>>> "Sandy Johnson" wrote:

>>>>>>>> On Thursday, October 02, 2008 7:16 PM SandyJohnso wrote:

>>>>>>>> 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
>>>>>>>> on your slide.
>>>>>>>>
>>>>>>>> "diane" wrote:

>>>>>>>>> On Thursday, October 02, 2008 10:10 PM Peter wrote:

>>>>>>>>> Great tip Sandy
>>>>>>>>>
>>>>>>>>> FWIW, it works in PowerPoint 2007 too.
>>>>>>>>>
>>>>>>>>> Peter

>>>>>>>>>> On Saturday, October 04, 2008 3:41 AM dian wrote:

>>>>>>>>>> Thank you Sandy! Can't wait to share this tip with my coworkers!
>>>>>>>>>>
>>>>>>>>>> "Sandy Johnson" wrote:

>>>>>>>>>>> On Sunday, October 12, 2008 2:50 PM lma wrote:

>>>>>>>>>>> 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!
>>>>>>>>>>>
>>>>>>>>>>> "Sandy Johnson" wrote:

>>>>>>>>>>> Submitted via EggHeadCafe
>>>>>>>>>>> Creating Google Motion Charts from Excel data
>>>>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/86599bca-edda-4204-af15-7a1cf901a071/creating-google-motion-charts-from-excel-data.aspx

mjoh...@gmail.com

unread,

May 6, 2014, 1:36:03 AM5/6/14

to

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

mjoh...@gmail.com

unread,

May 6, 2014, 1:51:58 AM5/6/14

to

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 Office Spreadsheet 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