Home>Article>Topics> How to add page numbers in excel

How to add page numbers in excel

藏色散人
藏色散人 Original
2020-09-07 11:09:52 20540browse

How to add page numbers in Excel: First open the page settings window; then select the location to insert the page number under the [Header and Footer] tab; then select to insert the page number in the middle; and finally click the [OK] button. Can.

How to add page numbers in excel

Recommended: "Excel Tutorial"

1. Under the "Page Layout" tab, in the lower right corner there is An arrow pointing 45° downward, click to enter.

How to add page numbers in excel

#2. The "Page Settings" window pops up, and the "Page" tab is displayed by default. It is completely different from the way of inserting page numbers in word. The location for inserting page numbers in excel is under the "Header/Footer" tab, click to enter.

How to add page numbers in excel

3. Under the "Header and Footer" tab, select the location to insert the page number. You can insert it from the header part or the footer part. Take inserting page numbers from the header as an example.

How to add page numbers in excel

4. In the header window, first select the insertion position of the page number. There are three options: left, center, and right. Select the middle to insert the page number, and place the mouse in the middle input box. , select the page number icon above to insert.

How to add page numbers in excel

5. After inserting the page number, click the "OK" option.

How to add page numbers in excel

#6. Inserting page numbers cannot be seen in the excel table. You need to see it in the print preview state.

The above is the detailed content of How to add page numbers in excel. 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