Set Header/Footer at Page Setup in excel

February 25, 2022
443 Views 0


Are you still not a confident WPS Spreadsheet user and see page set up as a tricky matter? Don't worry. To help out, we've prepared this tutorial just for you.

 

Page Setup consists of four parts, namely,  Page, Margins, Head/Footer and Sheet. In today's tutorial, we will learn the Head/Footer.

· Example of setting Head/Footer in Page Setup

Go to the Page Layout tab, and click Settings > Page setup.  

Head to the Header/Footer tab, where you can set the header and footer with some built-in options, such as page numbers and sheet numbers.

image (9).gif


You can preview in the rectangle box above or click Print Preview to preview the effect.

image (10).gif 

Click Custom Header, and then we will see three setting boxes corresponding to three areas in header's left, middle, and right. Here, you can freely set the text format and insert elements such as page number, picture, date, time, etc.

We want the time to display on the left and the page number in the middle of the page.

Go to the First Section box, and then select Time. Next, go to the Center Section, and select Page number and Number of Pages, with an of to connect them. Dont forget to type spaces before and after the of.

The complete form goes like this:

&[Page Number] of &[Number of Pages]

image (11).gif 

We can also preview it by clicking Printing Preview. This also works for Custom Footer.

image (12).gif


Apply Different odd and even page separately to Header, and Footer is also available in WPS Spreadsheet.

Check Different odd and even page, and then clicking either Custom Header or Custom Footer will give you two different tabs to customize, namely, Old Page Header/Footer, Even Page Header/Footer.

Similarly, you can click Print Preview to preview the effect.

image (13).gif 

Click Different first page, and then you can make a difference between the first page and the rest of the pages like what we did in setting different odd and even pages to the header.

image (14).gif 

 

· To learn more about page setup in WPS Office:

Click here to see how can we set header and footer

 

Excel is the most powerful tool to manage and analyze various types of Data. This free WPS Spreadsheet tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.

Was this helpful?