If a worksheet spans more than one printed page, you can label data by adding row and column headings that will appear on each print page. These labels are also known as print titles.

If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page. For example, you can repeat the first row of column headers …

Print column headings on each page of your worksheet so your readers won’t have to go back to the first page to see the headers.

In the table, right-click in the row that you want to repeat, and then select Table Properties. In the Table Properties dialog box, on the Row tab, select the Repeat as header row at the top of …

Repeating item and field labels in a PivotTable visually groups rows or columns together to make the data easier to scan. For example, use repeating labels when subtotals are turned off or …

On the Page Layout tab, select Page Setup, then the Sheets tab. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the …

If your report has more than one row label and you also want to repeat the outer row label items on each page, select the Repeat row labels on each printed page check box.

To print specific data at the top or side of each printed page—such as the names of the months that appear across the first row of a worksheet—see Repeat row or columns on every printed …

In Excel, you can enter the same data into several worksheets without retyping or copying and pasting the text into each one.

On the first page of the Repeating Table Binding Wizard, click the data source that you want to use in the Data source list, and then click the repeating group that you want to bind the table …