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, 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.

Page Numbers in EXCEL

This example teaches you how to print page numbers in Excel.

1. On the View tab, click Page Layout, to switch to Page Layout view.

2. Click to add footer.

The Header & Tools contextual tab activates.

3. On the Design tab, click Page Number to add the page number.

4. Type " of "

5. On the Design tab, click Number of Pages to add the number of pages.

Note: Excel uses codes in order to automatically update the header or footer as you change the workbook.

6. Click somewhere else on the sheet to see the footer.

Note: on the Design tab, click Options for a different first page header/footer or a different header/footer for odd and even pages.

7. On the View tab, click Normal, to switch back to Normal view.