Print Titles

When we print the excel worksheet the title is present in the first worksheet page but not in others, so in order to print titles in each and every printed page we can select the print options from the headings in the page layout tab which will print the titles for us.

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.

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.

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.