Home 
Excel Printing Print Titles On All Excel Workbook Pages
Search MS Office A-Z | Search Web Pages/ Design A-Z
Print Titles On All Excel Workbook Pages
To make titles print on each page:
- Choose File | Page Setup.
- When the dialog opens, click the Sheet Tab.
- Click the icon at the right side of the "Rows to repeat at top" entry box. When the Rows to Repeat at Top dialog box opens, click the row where your titles appear (usually the top row) and press Enter.
- Back in Page Setup, click OK.