How to print title (top row) on every page repeatedly in Excel?
Most often, we make some quite long workbooks, and they overflow to several pages. Normally we can freeze the top row or top column to view the overflowed data in workbook on every page. However, when we print these long workbooks, the title (top row) disappears and will not be printed in all pages except the first one. Actually, we can specify the Page Setup settings, and print the title (top row) on every page repeatedly.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.
Step 1: In the Page Setup group under Page Layout tab, click the Print Titles button.
Step 2: In the Page Setup dialog box, click the Sheet tab.
Step 3: In the Print Titles section, click the Browser button to specify the title (top row).
Step 4: Click OK button.
Now the title (top row) will be printed on every overflowed page.
By the way, if you need to print the gridlines, Row Heading, and Column Heading, you can check the Gridlines option, Row and column headings Option in the Print section in the same Page Setup dialog box.