If you have a large list of data to print off on multiple pages and want to see the column headings or titles on each page, go to the Page Layout tab and select “Print Titles”. Click the range selector button on the right hand side of the “Rows to repeat at top” box and select the rows that contain your headings, most likely row 1. Click the range selector button again and click OK. Use print preview to test the sheet will print as desired before printing.
