How to insert page numbers in Excel table

In actual printing, we often add page numbers to tables, but setting page numbers in Excel is not as convenient as Word. So how to set table page numbers? Let’s find out together.

1. Page number setting position

Click on the page layout - page settings - open the page settings interface - select the header/footer, as shown in the figure below Display:

2. How to add page numbers

If you want to add page numbers in the header, select the header and click Select the appropriate format from the corresponding drop-down menu. If you want to add it at the footer, the method is the same.

The specific operations are as follows:

##Related recommendations: "

excel basic tutorial"

Note: After adding the page number , cannot be seen in normal view. If you want to view the corresponding setting style, you can click File-Print. You can preview it on the right side, or directly press the shortcut key Ctrl P to view it, as shown in the following figure:

3. How to delete page numbers

If you want to delete page numbers, you can click Page Layout - Page Settings - Header and Footer , select the drop-down menu where to add the page number, and then select "None" and click OK.

4. No page number is set on the homepage

How to make the page number of the table start counting from the second page?

Click Page Layout - Page Settings - Header and Footer, select a page number format, and then check the "Different Home Page" checkbox.

The specific operations are as follows:

5. The first page starts from the third page

Sometimes the printed form It is necessary to continue to other table page numbers, for example, starting from the third page. How to deal with this?

First add the footer, then click "Page" in the page settings and set the starting page number to page 3.

The specific operations are as follows:

PS: If the format of "pages and total pages" is set, when the start page is set directly, it There will be an error in the total page number. If you want to enter the correct format, you need to add other page numbers. For example, you need to add 2 more pages here, so after setting the header format, you need to click Set Custom Header Format, and then enter "&[ Page number] pages, total &[total number of pages] 2 pages”.

The above is the detailed content of How to insert page numbers in Excel table. For more information, please follow other related articles on the PHP Chinese website!