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.
Thank you, this post helped me a lot and saved me loads of time. Keep up the good work!
not helpful. I wanted to know how to print a tabe in excel.
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?
It is very helpful....
Perfect, just what I needed!
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
Excellent help Suzanne100. Thank you!
Exactly what I was looking for. Thank You!
does that also work when i take that table and put it on a ms word later?
Thanks so much, this was exactly what I needed!
You are awesome! Thank you, so simple.
This explains how to repeat a row across every page, NOT how to get the same HEADER on all pages!