Print Titles in Excel

 

You can specify rows and columns in Excel that will be printed on each printed page. This can make your printed copy easier to read.

To print titles, execute the following steps.

1. On the Page Layout tab, in the Page Setup group, click Print Titles.

Click Print Titles

The Page Setup dialog box appears.

2. To repeat row 1 at the top of each printed page, click in the corresponding box and select row 1.

3. Click OK.

Repeat Row 1

Note: in a similar way, you can repeat columns at the left of each printed page.

4. On the File tab, click Print for a print preview.

The labels (LastName, Sales, Country and Quarter) appear on page 1 and page 2.

Print Preview Page 1

Print Preview Page 2

If you're new here, welcome to Excel Easy! Join over 1 million monthly Excel learners. You can find popular courses here: Excel Functions and Data Analysis in Excel.