Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

powerpoint

ResolvedVersion 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

PowerPoint tip:

Large Icons on toolbar

You can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons.

View all PowerPoint hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.