Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

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.

share|improve this answer

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.

alt text

share|improve this answer
    
thanks Joshhunt :-) –  joe Nov 11 '09 at 14:21
    
It doesn't work, the table isn't split on multiple slides –  yanjost Apr 22 '13 at 15:00

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.