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.

Print title on every page repeatedly with Print Titles feature

Print title on every page repeatedly with Kutools for Excel


Remove characters from beginning/right/end in cells

module remove by position 5

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.

Read More      Free Trial

Recommended Productivity Software

Office 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).


Hint


arrow blue right bubblePrint title on every page repeatedly with Print Titles feature

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.


arrow blue right bubble Print title on every page repeatedly with Kutools for Excel

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.

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Read More      Free Download Now

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.

Free Download Kutools for Excel Now

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.


arrow blue right bubbleRelated Articles

Combine row or column into one cell without losing data

Read More      Free Trial

ad combine rows columns 1 kutools-arrow-right kutools-arrow-right
Original data   Combine columns   Combine rows

Add comment


Security code
Refresh