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

When printing, whether it is PPT, Word or Excel, it is hard to escape a header footer setting.

You might say, this is too easy!

I use page numbers every day.

If you say so, I believe it, too.

But you know, if only one number is too monotonous, if you want to change the style of which page, how to change it?

Or, what if you want to change the starting page number?

When it comes to details, there are probably tears, right?

Today, let's take a look at the customization of the page number format and let your page number do whatever you want!

Where can I set the page number? To print a page number, you first need to know where to set the header and footer in Excel.

(students who know can skip this Part directly.)

❶ opens the footer settings window. In the Page layout tab, select more options for Page setup

Select the header / footer tab and you can customize the footer.

❷ inserts the page number. In the footer settings window, you will see that the footer is divided into three parts, the left, middle and right.

Put the page number wherever you want, whatever you want! Help yourself!

(at the will of the leader, of course.)

For example, click the edit box on the right, and then select "insert Page number" above, and the page number will be added.

There will be a page number code on the right.

* * here to distinguish between the page number and the number of pages, the number of pages is the total number of pages, and what we want is the page number.

After this setting is completed, it is just an ordinary numeric page number.

Then how to change it into the format of "which page of the October salary schedule"?

Custom page number format is super simple!

Just add a string of text "October salary schedule" before the page code symbol and a "page" after it.

The effect will come out.

You can even combine the page number with the number of pages, such as the total number of slashes, which is the number of pages in the total number of pages.

Of course, you can also make more custom styles.

You don't have to worry about leading some weird page number requirements anymore.

Wrong! Wait!

We also often encounter a situation: the home page does not have a page number, or the page number does not start from 1, how to do this?

Customizing the starting page number gives you two ways!

❶ footer settings. In fact, using the footer setting can also add or subtract a few pages from the page number.

Go to the footer setting window, give it "+ 1" after the existing page number code, and take any non-numeric character.

You can write a "page" or type a space.

See if the page number has changed?

In this way, we can define the starting page number at will.

❷ starting page number setting. Under the Page setup-Page tab, there is a setting edit box for the start page number.

We can enter the starting page number manually and start from which page we want to start!

However, please note that do not use both methods at the same time, the setting effect will be superimposed.

Okay, these are a few tips for customizing page numbers that we're going to talk about today.

Do you think, ah, it's so simple?!

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Xiaomin, Editor: Zhu Lan

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.