Home > Topics > Excel > body text

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

coldplay.xixi
Release: 2020-07-07 14:31:07
Original
35378 people have browsed it

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!

Related labels:
source:php.cn
Statement of this Website
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 [email protected]
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!