A formal form usually has additional information such as the company’s logo, time, and page number at the top or bottom. This specific area is calledheader and footer. Do you know how we can set it?

Take this table as an example.

Get into theInserttab first, and then clickHeader/Footer.You can also click theHeader and Footerbutton in thePrint Previewtab to set theheader and footerarea.

After the page setting dialog box pops up, we can now see that WPS has already built in some basic styles. Users can directly apply these styles withone click. 

Also, we can customize the header and footer in many ways.

ClickCustom Footer.Then we will see three setting boxes corresponding to the three areas on the footer's left, middle, and right.

Here, you can freely set the text format and insertelements such as page number, picture, date, time, etc.

Now we are going to adddate,time,andpage numberto this form.

It should be noted that the inserted page number will only display the number. If we want the page number to be more specific, we also need to add text before the page number.

After we finished setting the footer, we now need toinsert the company logo as the header.

Prepare the Logo image first, then clickInsert Picture.

Then, you can adjust the size of the picture in theFormat Graphicand check theLock aspect ratioto ensure thatit will notdeform the picture after changing the ratio. In this step, users are also allowed to adjust the color inthe Image Control category.

Finally, clickOKand the header is done now.

To meet the diversity of table design, WPScan also set First Page Footer,Odd Page Footer, andEven Page Footerseparately.

Check theDifferent odd and even pagesor/andDifferent first pageoptions according to our needs, then we can set different styles of headers and footers for different pages.

To be office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.