I have a table in Excel which is too long for one PowerPoint slide. So I would like to split it over 2 or 3 slides, but have the header on each of the slides. What is the easiest way to accomplish that? I am using Excel and PowerPoint 2007.
2 Answers
I would recommend printing to a PDF. You can customize how much data shows up on a page using the print dialog. By freezing the header row in the 'view' tab (ribbon interface), it will appear on each page printed. Then insert the PDF into powerpoint.
From here:
Step 1
Open the Excel spreadsheet with the data table that you want to copy by right-clicking on it and selecting "Open."
Step 2
Highlight the entire data table by clicking on cell A1 and dragging a box down and to the right across all of the cells in the table.
Step 3
Click the "Copy" button in the upper-left corner of the program. You can also copy the selection by holding down the "Ctrl" key and then pressing the "c" key.
Step 4
Open your PowerPoint presentation, and click on the slide where you want the table to be inserted. The slides are listed along the left side of the screen.
Step 5
Select "Insert," and then click on "Table."
Step 6
Click on the box in the upper-left corner of the table area to create a 1x1 table.
Step 7
Click on "Home," and then click "Paste." You can also hold "Ctrl" and then press "v" to automatically paste the copied table. The table will automatically be expanded from a 1x1 cell to the size of the copied table.
( or )
You could use XPPORT, which can do this job.
XPPort ports Microsoft Excel data to PowerPoint. A proven Excel add-in that views as a toolbar for use with all your spreadsheets and charts. When you are ready to convert Excel data to PowerPoint, XPPort reads your Excel page breaks and copies each page to a new separate slide.
-
2