For Office 2007:

1. Click on page layout at the top

2. Click on print titles (click on sheet tab if not already there)

3. Click on red arrow at end of “Rows to repeat at top”

4. Click on row you want to repeat at the top of every page printed

5. Click ok

For Office 2003 and older:

1. Choose File, Page Setup, and then click on the Sheet tab

2. Click in the ‘Rows to repeat at topbox and click and drag the cursor through the rows that contain your headings. (Note: You can click OK at this point, or you can choose the Print Preview button to see if everything looks OK)

  • If you clicked Print Preview: On the Print Preview screen, click the Next button to see that your report headings will also print on page two
  • If everything looks OK, click the Close button

[Ask] [blinklist] [Bloglines] [del.icio.us] [Digg] [Facebook] [Furl] [Kaboodle] [LinkedIn] [MySpace] [Newsvine] [Propeller] [Slashdot] [Sphinn] [Squidoo] [StumbleUpon] [Technorati] [Twitter] [Windows Live] [Yahoo!] [Email] More »