Home>Article>Topics> How to set up a spreadsheet to have a header on every page

How to set up a spreadsheet to have a header on every page

angryTom
angryTom Original
2019-07-25 09:50:11 38450browse

How to set up a spreadsheet to have a header on every page

If you want to know more about the operation of tables, you can click:Excel Tutorial

We will make many very long forms in our office. These forms may be printed on many sheets of paper, but there is only one header. For a better preview, we usually set the header to print on each page. So today, Teacher Ning Shuangxuehaowangshi will teach you how to print headers on every page in Excel!

This is the effect before setting

How to set up a spreadsheet to have a header on every page

How to set up a spreadsheet to have a header on every page

##Excel printing Each page has a header setting method

First, enter [Page Layout]-[Page Setup]-[Worksheet]-click [Top Title Row] under [Print Title] button next to it, then select the header part you want to print on each page with the cursor, and finally confirm.

How to set up a spreadsheet to have a header on every page

How to set up a spreadsheet to have a header on every page

Then we print and preview it, and we will find that each page has a title line.

How to set up a spreadsheet to have a header on every page

The above is the detailed content of How to set up a spreadsheet to have a header on every page. 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