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.

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

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.

Related Articles


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Add comment


Security code
Refresh