Printing Headings on Each Page/Repeating Headers and Footers
Print Headings on Each Page/Repeating Headers and Footers
If your printout spans multiple pages, you may want to have column headers and/or row titles be repeated at the top and left of each page.
To print headings on each page:
- On the PAGE LAYOUT tab, from the Page Setup group, select Print Titles.
- In the Page Setup dialog box, on the Sheet tab, under Print titles, type the references of the rows and columns that you want to appear, respectively, in the Rows to repeat at top and Columns to repeat at left options and click OK.