How Excel tables print the same header headers per page

1, click the menu bar "file-page settings", the following figure:

2, the Page Setup window, click the "sheet" option, find "Print title", and then click the "Top header row" to the right side of the button with a red arrow, the following figure:

3, at this time, has been reduced to the following figure as shown in the "Page Setup-Top header row" window, this window if it affects our next work when the line of sight, you can drag it.

4, the mouse to move to the header row number, if the title is only one row, you can click the row number selection, if the title has more than one line, you can drag on the row number selection. When selected, the header line changes to a dashed border, as shown in the following illustration:

5, at this time, "Page Setup-Top header row" window has become the following figure, "$1:$1" to represent a row, if it is a multiline header, then the corresponding line number, that is, line 1th to the first few lines, the same click on the right side with a red arrow button, as shown:

Zoom back to the Page Setup window, as shown below, and finally click OK to set the finish. Each page of the Excel table prints the same header heading when you print it.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join