How To Set A Row As Print Titles In Excel

Excel Tips
Excel Functions
Excel Formulas
Excel Charts
Discussion Tips
Outlook Tips

How to impress title (tiptop row) on every page repeatedly in Excel?

Most oftentimes, nosotros make some quite long workbooks, and they overflow to several pages. Usually we tin freeze the peak row or top cavalcade to view the overflowed data in workbook on every page. However, when nosotros print these long workbooks, the championship (peak row) disappears and will non exist printed in all pages except the first one. Really, nosotros can specify the Page Setup settings, and print the championship (tiptop row) on every page repeatedly.

Print title on every page repeatedly with Impress Titles feature
Print championship on every page repeatedly with Kutools for Excel
Hands add and print title/header row to each page easily with Kutools for Excel

Print title on every folio repeatedly with Print Titles characteristic

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 Canvas tab.

Step 3: In the Print Titles section, click the Browser button to specify the title (top row).

Stride 4: Click OK button.

At present the title (summit row) volition be printed on every overflowed folio.

By the mode, if you lot need to impress the gridlines, Row Heading, and Cavalcade Heading, you lot can check the Gridlines option, Row and column headings Option in the Print section in the same Folio Setup dialog box.

Impress title on every page repeatedly with Kutools for Excel

Sometimes, you may need to print every northward rows in ane page, and add title on every folio repeatedly too. For instance, you need to print every 20 rows in one folio with calculation title on every page. In this status, you tin can apply Kutools for Excel'south Split to Columns utility to get it done.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit menu required! Gratis Trial Now!

Step 1: Click the Kutools Plus > Split up to Columns.
doc split to column

Step 2: In the opening Separate to Columns dialog box, you need to:

(one) Click the button in the Titles range box, and and so specify the title range;
(ii) Click the button in the Data range box, and then specify the range you volition print;
(3) In the Rows per printed page box, specify the number of rows you will print in each page;
(4) Click the Ok push button.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature complimentary trial 30-mean solar day, no credit card required! Get It Now

Stride 3: Now in a new worksheet, you lot will encounter the range y'all will print will be split by the specified number of rows, and the title volition be added into each folio.

Now you can click the File (or Office button) > Impress to print every n rows in one folio with calculation title into every page.

Easily add and impress title/header row to each page hands with Kutools for Excel

Actually, we tin apply Kutools for Excel'south Insert Titles Rows utility to add together the title/header row at every x rows, and and then dissever every 10+1 rows equally a dissever page. Please practise as follows:

Kutools for Excel - Includes more than than 300 handy tools for Excel. Full feature free trial 30-mean solar day, no credit carte required! Free Trial Now!

1. Click Kutools > Insert > Insert Titles Rows to open up 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 tabular array except the title row in the Insert Range box, specify the interval number in the Interval rows box, and click the Ok push button. Meet screenshot in a higher place:

3. Now the title row is added at every x rows. As yous encounter, the first title row is repeated. Please delete the repeated championship row with right clicking the beginning championship row and selecting the Delete from the right-clicking carte du jour.

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

Note: The interval yous insert folio breaks at is 1 bigger than the interval yous insert title rows at.

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

So far, we have inserted the championship row or header row on each page in active worksheet every bit below screenshot shown. You can click File (or Role button) > Print to print each folio with title row.
doc print title 12

Kutools for Excel - Includes more than 300 handy tools for Excel. Full characteristic costless trial 30-mean solar day, no credit card required! Become It Now

Demo: print title (superlative row) on every page repeatedly in Excel

Kutools for Excel includes more than than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Print multiple workbooks
Print ranges
Copy Excel folio setup to other worksheets