How to bring the header to the second page when printing

How to bring the header to the second page when printing: First open the EXCEL table on the computer; then find the "Page Layout" tab, click "Print Title" to enter the relevant settings; then find the top title row , enter "$1:$1" after it; finally click "OK" to set the first row as the header.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2003 version, Dell G3 computer.

Related learning recommendations: excel tutorial

excel prints the second page to retain the header. This can only be achieved by using the print title.

The specific operations are as follows:

1. Open the EXCEL table on the computer. In the tools above the EXCEL table, you can find the "Page Layout" tab and click "Print Title" to enter the related set up.

2. Under the worksheet tab, find the top title row, enter $1:$1 after it, and then click OK to set the first row as the header. Of course You can set other header rows according to actual needs.

3. Return to the EXCEL table and press the Ctrl key and the letter P key on the keyboard at the same time to enter the print preview interface. In the preview page, you can find that the header of the second page can Printed successfully.

The above is the detailed content of How to bring the header to the second page when printing. For more information, please follow other related articles on the PHP Chinese website!