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

Easily add and print title/header row to each page easily with Kutools for Excel

Print title (same top row) on each page with the same number of rows in Excel

For example you need to split a long table into multiple pages with same number of rows in each page, and simultaneously repeatedly add the title (the same top row) on each page for printing, how to archive it easily in Excel? Try Kutools for Excel's Split to Columns utility! Click for 60-day free trial!

ad split to columns 3


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.

Kutools for Excel - Combines More Than 120 Advanced Functions and Tools for Microsoft Excel

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 Trial 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.


Actually, we can apply Kutools for Excel’s Insert Titles Rows utility to add the title/header row at every x rows, and then split every x+1 rows as a separate page. Please do as follows:

Kutools for Excel - Combines More Than 120 Advanced Functions and Tools for Microsoft Excel

1. Click Kutools > Insert > Insert Titles Rows to open the Insert Titles Rows dialog box.

2. In the opening Insert Titles rows dialog box specify your title row in Titles Range box, specify your table except the title row in the Insert Range box, specify the interval number in the Interval rows box, and click the Ok button. See screenshot above:

3. Now the title row is added at every x rows. As you see, the first title row is repeated. Please delete the repeated title row with right clicking the first title row and selecting the Delete from the right-clicking menu.

4. Click Enterprise > Printing > Insert Page Break Every Row, and then type the interval into the opening dialog box, and click the Ok button. See screenshot:

Note: The interval you insert page breaks at is 1 bigger than the interval you insert title rows at.

Then a dialog box comes out and shows how many page breaks have been inserted in active sheet. Click the OK button to close it.

So far, we have inserted the title row or header row on each page in active worksheet as below screenshot shown. You can click File (or Office button) > Print to print each page with title row.

Free Trial Kutools for Excel Now

doc print title 12


Tip: In this Video, Kutools tab and Enterprise tab are added by Kutools for Excel. If you need it, please click here to have a 60-day free trial without limitation!


Comments  

Permalink +6 Devendra Pahari
Thanks a lot, for your solution, some time small things make us crazy.
2013-10-22 14:39 Reply Reply with quote Quote
Permalink -1 Iqbal Hashmi
Pl let know the how to mention in Excel 2007
How to repeat 2 rows in Every Pages
example
row 2 dise no
Row 3 slno. name father name class

Iqbal Hashmi
2013-11-26 08:07 Reply Reply with quote Quote
Permalink 0 HelloKelly
hi,

To print 2 rows repeatedly in every page:

In the Step 3 click the browse button besides the Rows to repeat at top: box, and select the rows that you will print repeated in every page, such as $1:$2.


Or you can type the $1:$2 directly in the box.


To print first three columns, you can also type the $A:$C in the box of Columns to repeat at left:
2013-11-27 06:23 Reply Reply with quote Quote
Permalink 0 San
Great help. I check few websites for help before comming to this one.
Thank youy.
2014-01-30 16:02 Reply Reply with quote Quote
Permalink 0 CereusGraphics
I am very happy to be able to find this excellent article! After reading your article, I feel learned a lot of things, and we hope to see your next article, look forward to your masterpiece.
2014-02-19 06:50 Reply Reply with quote Quote
Permalink 0 BARKHA
Thank you so much for supporting me in any situation...... ...
2014-04-12 06:14 Reply Reply with quote Quote
Permalink 0 JAGAN G
Thanks and very useful information with easily understanding format picture
2014-04-16 17:38 Reply Reply with quote Quote
Permalink 0 Tom Rowen
Thank you! I knew there had to be a way. It's not intuitive in Excel, and the MS Help tool is a joke. This page was a life saver. Thanks again!
2014-07-08 18:18 Reply Reply with quote Quote
Permalink 0 Usman
I want a line repeat on every page but I couldn't it you can suggest.
2014-07-10 11:22 Reply Reply with quote Quote
Permalink 0 chukins
Thank you for making thins easier for me. I must agree with Tom Rowen, that the MS help tool is no help at all!
2014-08-28 18:10 Reply Reply with quote Quote
Permalink 0 Jackie
I tried to print the top roll on every page, but it keeps telling me Reference is not available. What do I do ???
2014-10-23 17:27 Reply Reply with quote Quote

Add comment


Security code
Refresh