How to set excel footer to be different for each page

How to set the excel footer to be different for each page?

1. First open the EXCEL document that needs to set the footer

## 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

3. Select "Header and Footer" on the pop-up "Page Settings" page. The "Header and Footer" setting interface pops up

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.

　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.

　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.

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

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.

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!