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

##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.

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

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!