Add horizontal lines to EXCEL headers and footers

1. First, double-click the excel icon on the desktop to open excel.

2. After opening excel, click the "Page Setup" option in the file on the left side of the upper bar.

3. Click the "Header/Footer" option in the page setup pop-up box to enter the header/footer tab.

4. Click Custom Header in the Header/Footer tab.

5. The header setting box will pop up, and information such as date, confidentiality, producer and page number can be filled in the left/middle/right of the header.

6. After completing the form, click the "OK" button in the upper right corner.

7. After setting the header, the effect is shown in the figure.

8. Click "Custom Footer" in the page setup.

9. The footer settings page will pop up. You can fill in date, confidentiality, producer, page number and other information on the left/middle/right of the footer.

10, and then click OK.

1 1. After setting the footer, the effect is shown in the figure.