How To Print ‘Titles’ (Column and Row Headers) in Excel 2007 & 2010
Changing this setting will allow you to print column and row headers on every sheet you print out. If you do not select to “Print Titles” your column and row headers will ONLY appear on the first page of your print out.