![How to set excel footer to be different for each page](https://img.php.cn/upload/article/000/000/020/5eb7579fb4ba3613.jpg)
How to set the excel footer to be different for each page?
1. First open the EXCEL document that needs to set the footer
![1589073706882336.png How to set excel footer to be different for each page](https://img.php.cn/upload/image/663/475/605/1589073706882336.png)
## 2. Select the "Page Settings" right in the "Page Layout" tab Click the launch button in the dialog box below, and the "Page Settings" interface will pop up
![1589073709860585.png How to set excel footer to be different for each page](https://img.php.cn/upload/image/780/359/592/1589073709860585.png)
3. Select "Header and Footer" on the pop-up "Page Settings" page. The "Header and Footer" setting interface pops up
![1589073713667294.png How to set excel footer to be different for each page](https://img.php.cn/upload/image/888/154/169/1589073713667294.png)
4. In the "Header and Footer" setting interface, first check the "Odd and Even Pages Are Different" tab, and then click " Custom Footer". In the pop-up page, you can set the odd and even pages separately.
![1589073719656083.png How to set excel footer to be different for each page](https://img.php.cn/upload/image/516/123/517/1589073719656083.png)
5. In the "Odd Page Footer" setting option, click the blank area on the left to activate the left footer. Then click the second option above to insert page numbers.
![1589073723602510.png How to set excel footer to be different for each page](https://img.php.cn/upload/image/780/855/926/1589073723602510.png)
6. The footer settings for even-numbered pages are similar to those for odd-numbered pages. In the "Even page footer" setting options, click on the empty space on the right to activate the right footer. Then click the second option above to insert page numbers. Then click OK continuously to complete the setting.
![1589073726947512.png How to set excel footer to be different for each page](https://img.php.cn/upload/image/702/628/642/1589073726947512.png)
7. In order to see the effect of the settings, you can view the print preview. Click "File" and then select "Print."
![1589073732623721.png How to set excel footer to be different for each page](https://img.php.cn/upload/image/591/329/256/1589073732623721.png)
8. In the "Print" interface, you can view the print preview. It can be seen that the footer of odd-numbered pages is on the left and the footer of even-numbered pages is on the right, indicating that the setting is successful.
![1589073736917190.png How to set excel footer to be different for each page](https://img.php.cn/upload/image/383/779/467/1589073736917190.png)
Notes
This is just an example, other settings for the footer are similar
The above is the detailed content of How to set excel footer to be different for each page. For more information, please follow other related articles on the PHP Chinese website!