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.
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
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.
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:
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.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 years agoThank you!!
To post as a guest, your comment is unpublished.· 5 years agoI tried to print the top roll on every page, but it keeps telling me Reference is not available. What do I do ???
To post as a guest, your comment is unpublished.· 5 years agoThank you for making thins easier for me. I must agree with Tom Rowen, that the MS help tool is no help at all!
To post as a guest, your comment is unpublished.· 5 years agoI want a line repeat on every page but I couldn't it you can suggest.
To post as a guest, your comment is unpublished.· 5 years agoThank 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!
To post as a guest, your comment is unpublished.· 5 years agoThanks and very useful information with easily understanding format picture
To post as a guest, your comment is unpublished.· 5 years agoThank you so much for supporting me in any situation.........
To post as a guest, your comment is unpublished.· 5 years agoI 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.
To post as a guest, your comment is unpublished.· 5 years agoGreat help. I check few websites for help before comming to this one.
To post as a guest, your comment is unpublished.· 6 years agoPl let know the how to mention in Excel 2007
How to repeat 2 rows in Every Pages
row 2 dise no
Row 3 slno. name father name class
To post as a guest, your comment is unpublished.· 6 years agohi,
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:
To post as a guest, your comment is unpublished.· 6 years agoThanks a lot, for your solution, some time small things make us crazy.