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