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:
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:
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
Anonymous
February 14, 2012
Thank you, this post helped me a lot and saved me loads of time. Keep up the good work!Anonymous
July 12, 2012
not helpful. I wanted to know how to print a tabe in excel.Anonymous
August 09, 2012
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?Anonymous
November 04, 2012
It is very helpful....Anonymous
December 04, 2012
Perfect, just what I needed!Anonymous
December 05, 2012
The comment has been removedAnonymous
April 07, 2013
Excellent help Suzanne100. Thank you!Anonymous
May 21, 2013
Exactly what I was looking for. Thank You!Anonymous
May 23, 2013
Hey! does that also work when i take that table and put it on a ms word later?Anonymous
June 10, 2013
Thanks so much, this was exactly what I needed!Anonymous
July 29, 2013
You are awesome! Thank you, so simple.Anonymous
September 26, 2013
This explains how to repeat a row across every page, NOT how to get the same HEADER on all pages!