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.
Remove characters from beginning/right/end in cells
Kutools for Excel's Remove By Position utility eases you removing certain number of characters from beginning/end/specified position of text string in cells.
Recommended Productivity SoftwareOffice Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).
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.
Sometimes, you may need to print every n rows in one page, and add title on every page repeatedly too. For example, you need to print every 20 rows in one page with adding title on every page. In this condition, you can apply Kutools for Excel's Split to Columns utility to get it done.
Step 1: Click the Enterprise > Split to Columns.
Step 2: In the opening Split to Columns dialog box, you need to:
(1) Click the button in the Titles range box, and then specify the title range;
(2) Click the button in the Data range box, and then specify the range you will print;
(3) In the Rows per printed page box, specify the number of rows you will print in each page;
(4) Click the Ok button.
Step 3: Now in a new worksheet, you will see the range you will print will be split by the specified number of rows, and the title will be added into each page.
Now you can click the File (or Office button) > Print to print every n rows in one page with adding title into every page.