Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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
2  
It doesn't work, the table isn't split on multiple slides – yanjost Apr 22 '13 at 15:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .