Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The header is displayed repeatedly when Excel prints a multi-page form

2025-01-15 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >

Share

Shulou(Shulou.com)11/24 Report--

In the workplace office, we often encounter some longer forms, and these forms will be printed out in many pages, but the header will only be displayed on the first page, and there will be no title on the back of the paper.

For a better preview, we usually set repeating headers so that each page has a header. How to set it up? Today, Mr. Wang will come to teach you.

01, repeat print header and title first teach you to set repeat print header and title.

Go to "header layout"-"header Settings"-"worksheet", click the button next to "Top title Row", select the "title" and "header" rows at the beginning of the table, and make sure.

After setting up, we press the "Ctrl + P" shortcut key to enter "print" to check our effect.

02. Repeat print header if you only want to print a single header repeatedly.

All we have to do is click the button in the "top title row" and select the "header row".

Go to print preview and check out our results!

03. Printing the bottom title repeatedly teaches you to repeat the top title line. Let's talk about how to print the bottom title repeatedly.

Enter "Page layout"-"Page setup"-"header / footer"-"Custom footer". "footer" is mainly divided into three parts, left, middle and right, and you can enter content according to your own situation.

Not only that, in the footer, but also provides us with page numbers, dates, times, pictures, formatted text settings and many other functions, you can insert and use according to your own needs.

Finally, we "Ctrl + P", enter the print, let's see the effect!

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

IT Information

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report