98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Powerpoint
Powerpoint
Resolved · Medium Priority · Version 2003
Paula has attended:
PowerPoint Introduction course
Powerpoint
is there a way to import large spreadsheets into Power point so each page automatically goes into a separate slide
RE: powerpoint
Hello Paula
Thank you for your question and welcome to the forum.
I think that what you describe here would require writing VBA code, which is beyond the scope of what we cover on our PowerPoint training.
I do have a suggestion that might make this process a bit faster for you though, depending on how you are doing this now.
1. Insert the Excel spreadsheet as an object (Insert - Object - From File, navigate to and select the file containing the spreadsheet).
2. If the spreadsheet that shows on your screen is not the one you want to display, then double-click on the spreadsheet and select the tab for the sheet you want to display, then click away from the spreadsheet.
3. Make a duplicate of the slide by selecting the whole slide in the Slides pane on the left hand side of your screen, then use the keys Ctrl + D to make a duplicate slide. You will now have two slides that are identical.
4. If the whole spreadsheet will take more than two slides to display, repeat step 3 as many times as you think will be necessary to show the whole spreadsheet over consecutive slides.
5. Go back to the first slide showing the spreadsheet and bring up the Picture toolbar on your screen (View - Toolbars - Picture).
6. Click on the spreadsheet object and click the Crop tool on the Picture toolbar.
7. You will have handles come up around the edge of the spreadsheet. If you hold your mouse over the bottom right corner of the spreadsheet you will be able to drag in and eliminate all but the top left of the spreadsheet. Click on the Crop tool to turn it off. Then you can resize the remaining bit of the spreadsheet on the slide, to make it bigger.
8. Repeat step 7 on the other slides showing the spreadsheet, each time cropping out different parts of the spreadsheet and resizing the remaining part of the spreadsheet.
I hope this helps.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
PowerPoint tip:Start and stop presentations if you have used timingsIf you have used timings and need to stop a presentation press S to stop and S again to restart. |