A tutorial on setting different page numbering formats for odd and even page footers in Excel tables

You must be familiar with the different forms of the word Parity page, and here's how you can format the odd and even page footers in the Excel table by setting different page numbers. For example, it is convenient to print, you need to display the odd page footer to the left, even page footer on the right. Here take EXCEL2013 as an example to show how to set the

Tools/raw Materials

EXCEL 2013

Method/Step

1, first open the need to set the footer of the Excel document

2, select the Page Layout tab "Page Setup" in the lower right of the dialog box launch button, pop-up "Page Setup" interface

3, in the pop-up "Page Setup" page select "Header and Footer." Eject the header and Footer Settings screen

4, in the "header and footer" Settings interface first tick the "odd and even page different" tab, and then click "Custom Footer." The odd and even pages can be set separately on the pop-up page.

5, in the "Odd page footer" setting option, click on the left blank area, activate the left footer. Then click the second option above to insert the page number.

6, even page footer settings and odd pages similar. In the Even Page Footer setting option, click the right blank area to activate the right footer. Then click the second option above to insert the page number. Then click OK continuously, set to complete.

7, in order to see the effect of settings, you can view the print preview. Click "File" and select "Print".

8, in the "Print" interface, you can view the print preview. You can see that the footer on the odd page is on the left, and the footer on the even page is on the right, which indicates a successful setting.

Attention matters

Here's just an example, and the other settings for the footer are similar

The above is in the Excel table in the odd and even page footer set different page number format tutorial, hope to be helpful to everyone!