Home>Article>Topics> How to automatically generate table headers on the second page of excel

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

coldplay.xixi
coldplay.xixi Original
2020-07-07 14:31:07 35481browse

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 table headers on the second page of excel

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;

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

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

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

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

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

##4. Select the title row or header;

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

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

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

6, OK See that every page has a title.

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn