Print Excel table headers on every page


If you’re printing a long spreadsheet in Excel and want to have the same header row across the top of each page, you’re in luck. There’s a little-known feature tucked away in Excel 2007 and Excel 2010 to do just that.

If you’re using Excel 2007, go to File, Page Setup and then open the last tab. In Excel 2010, switch to the Page Layout tab and click the Print Titles button:

Print Titles

Click inside the Rows to repeat at top field and either type in the range if you know it, or click the icon at the far right of the field and select your header row in your worksheet:

Page Setup dialog box

Now just click Print Preview to ensure your pages look as you intended.

Likewise, if your document has a column you want repeated on each page, just fill in the details in the Columns to repeat at left field.

Suzanne

Comments (12)

  1. thomas says:

    Thank you, this post helped me a lot and saved me loads of time.  Keep up the good work!

  2. Cheryl Harvey says:

    not helpful.  I wanted to know how to print a tabe in excel.

  3. Nyla says:

    When I set print titles as you've described, the text in the rows I've selected is cut off on all pages after the first page. Also, a graphic in the rows does not show on every page. Do you know how to fix these two problems?

  4. Swaminathan says:

    It is very helpful….

  5. Matt says:

    Perfect, just what I needed!

  6. Greg Johnson says:

    It's not working for me. In Excel 2010 Page Layout shows Table1 in Print Area and $1:$2 for Rows to repeat at top.  Print Preview does not show Rows 1 and 2.  Rows 1 and 2 are not in the table.

    Oh, I found it.  You have to click the check the Print Row and column headings check box.  Dang

  7. ccruppe says:

    Excellent help Suzanne100. Thank you!

  8. Brenda B says:

    Exactly what I was looking for. Thank You!

  9. Mari says:

    Hey!

    does that also work when i take that table and put it on a ms word later?

  10. D. Hutchins says:

    Thanks so much, this was exactly what I needed!

  11. Allie says:

    You are awesome! Thank you, so simple.

  12. TJ says:

    This explains how to repeat a row across every page, NOT how to get the same HEADER on all pages!