How to automatically generate table headers on the second page of excel

How to automatically generate a header on the second page of excel: first open the table, click [Page Layout-Print Title]; then click the rightmost graphic of [Top Title Row] in the window; then select the title row Or table header; finally click [Print Preview].

How to automatically generate headers on the second page of excel:

1. Open an excel table and you can see The first row of this table is the header that needs to be printed on each page;

2. Click "Page Layout" and "Print Title" in sequence;

3. Click the rightmost graphic of "Top Title Row" in the window;

##4. Select the title row or header;

5. At this time, you can see that the title row has been selected, click "Print Preview";

6, OK See that every page has a title.

Related learning recommendations:

excel basic tutorial

The above is the detailed content of How to automatically generate table headers on the second page of excel. For more information, please follow other related articles on the PHP Chinese website!