Current location - Quotes Website - Signature design - How to make the title bar of the first row automatically appear on the next page when typing tables in EXCEL?
How to make the title bar of the first row automatically appear on the next page when typing tables in EXCEL?
When you enter a table in EXCEL so that the title bar of the first row automatically appears on the next page, you need to set "Print Title Row".

The method comprises the following steps:

1. Open the EXCEL document with the title line to be printed, click Page Layout in the tab bar above, find Page Setup, and click Print Title to enter the print title setting interface.

2. Enter $ 1:$ 1 (set the first title line) in the "Top Title Line" input box, and then click the "OK" button below.

3. Return to the table, press the keyboard "Ctrl+P" to open the "Print Preview", and find that the title line at the top of the first page has been printed successfully.

4. Turn to the second page and find that the top title line can also be printed successfully.