Insert a scrolling worksheet in Powerpoint

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.

SandyJohnson
Wed Oct 01 16:48:01 CDT 2008

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:

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

diane
Wed Oct 01 18:42:01 CDT 2008

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

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

Peter
Wed Oct 01 22:36:46 CDT 2008

Great tip Sandy

FWIW, it works in PowerPoint 2007 too.

Peter

On Oct 2, 1:42=A0pm, diane <di...@discussions.microsoft.com> wrote:
> Sandy, this is a fantastic tip! =A0Thanks so much for sharing!

subek
Thu Oct 02 07:08:02 CDT 2008

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:

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

SandyJohnson
Thu Oct 02 11:54:06 CDT 2008

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:

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

SandyJohnson
Thu Oct 02 11:55:02 CDT 2008

Thanks Peter.

"Peter" wrote:

> Great tip Sandy
>
> FWIW, it works in PowerPoint 2007 too.
>
> Peter
>
> On Oct 2, 1:42 pm, diane <di...@discussions.microsoft.com> wrote:
> > Sandy, this is a fantastic tip! Thanks so much for sharing!
>

diane
Thu Oct 02 16:16:04 CDT 2008

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

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

SandyJohnson
Thu Oct 02 18:16:13 CDT 2008

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:

> Sandy, is there a way to insert a Word document and scroll through it?
>
> "Sandy Johnson" 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:
> >
> > > 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:
> > >
> > > > 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:
> > > >
> > > > > 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.

diane
Sat Oct 04 02:41:00 CDT 2008

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

"Sandy Johnson" 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:
>
> > Sandy, is there a way to insert a Word document and scroll through it?
> >
> > "Sandy Johnson" 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:
> > >
> > > > 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:
> > > >
> > > > > 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:
> > > > >
> > > > > > 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.

lmac
Sun Oct 12 13:50:01 CDT 2008

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:

> 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:
>
> > Sandy, is there a way to insert a Word document and scroll through it?
> >
> > "Sandy Johnson" 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:
> > >
> > > > 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:
> > > >
> > > > > 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:
> > > > >
> > > > > > 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.