Excel in the page settings are not as easy as in Word, so many friends, not in print form to print out the page number, but on serial number out to identify, report it to us to read a lot of inconvenience caused. In fact, Excel is also very easy to insert page numbers, together we can try the following:

one page insert general steps:

click the "View" ¡ú header and footer, in the "Page Setup" dialog box in the "Header / Footer" tab, click the "Custom Footer" button (in this case select "Custom Header "can be, but the general custom is to page numbers on the footer). (Figure 1)

In the open, "Footer" dialog box, click the "in" the blank box below (meaning the end to center the page number display), and then click Insert Page Number button ("# number" button), then in the "in" shown in the box under "& [Page]", and finally click "OK" to exit. (Figure 2)

click "File" ¡ú Print Preview to see! is not already inserted a page number. (Figure 3)

two simple steps modified page:

1, in the open, "Footer" dialog box, click the "in" the blank box below and click "No." button to insert the page number, and then click the "double plus" button (the button inserts the total number of pages ), then "& [Page]" in front of type "s" word in "& [Page]" behind (ie in the "& [Pages]" front) input "page (of" and finally then "& [Pages]" behind the input "page)", which is to ultimately become the "first & [Page] Page (of & [Pages] Page)", followed by point "to determine "Exit, use the" Print Preview "will be found to check results show that" at the number of pages (total number of pages). " (Figure 4 and Figure 5)

$ show_page $

2, double-click the insert page number and the total number of pages to select them, you can press and hold the left button drag selection, and then click the "letter A" button (Font button), in the open "Fonts" dialog box can on the page number for the font, font and font size settings. (Figure 6 and Figure 7)

3, the start page to non-1: