Excel 2010 print settings print the title line on each page

1. to display the title of each printed Excel page, click the "page layout" tab on the menu after opening the Excel file, click "page settings" as shown in the following figure:

2. then, in the displayed "page settings" window, we find the "worksheet" in which we can see that there is a "top heading line" set to the cell coordinates that need to be repeatedly displayed, the procedure is as follows.

3. Before printing, we can use print preview to see if the title is displayed on each page, as shown in Figure 3:

 

Well, if there is no problem, we can start printing.