When printing excel forms, it is sometimes necessary to display personal signature, company name or file name, company logo, etc. On every page. If you edit each page in an excel table, the workload is very heavy, which is unattractive for worksheets with dozens or hundreds of pages.

Turn on step reading mode

operational approach

0 1

Open the excel table to be printed and enter the print-print preview. There is a two-page form in it. You need to set the name of the watchmaker at the bottom, so that every printed page shows the watchmaker.

02

Select the page layout in the toolbar, and then click the small icon to the right of the page setup.

03

Enter the page setup dialog box, select the header/footer, and then click Custom Footer. Of course.

04

In the footer dialog box, three small boxes, left, middle and right, are displayed, indicating the position displayed at the bottom. Here we choose to enter the watchmaker at the bottom right: Ling Huchong, and then click OK. Go back to the page setup and confirm again.

05

When you enter the print preview again, you can see the signature displayed at the bottom of each page. This setting can only be displayed when printing, but not when reading the electronic version on the computer.

06

Besides editing what you want to display manually, there are some shortcut buttons and format settings in the footer settings, such as page number, file name and file path, which can be set according to your own needs.