File Name – Same as Sheet Name, It also gives the name of the file to be shown in Header or Footer (Formula = &).Sheet Name – It gives the name of the sheet, which is entered in a sheet to be shown in the Header or Footer.Current Time – It gives the current or publishing time.Current Date – It gives the current or today’s date.Number of Pages – It shows the total number of pages where complete data are available.Now we will see a few more functions, as shown in the below screenshot. We have seen how Header, Footer, and Page Number work. To make Header and Footer in excel more attractive, we have a few more functions, which are there to make our Header and Footer in excel more attractive and professional. Below, we have filled the footer with some data.Īs you can see in the above screenshot, we have put the company’s name, which is ABC Corporation, in a light color to make a watermark impression and kept CopyRight Reserved © in small fonts. This will be visible when you change the cell or come out from edit mode from the same cell.īy escaping out of edit mode from that footer, page numbers will start forming in sequence, and that will be created in all the subsequent pages as below.Īlso, in Footer, you can enter the Copyright detail or number, your company’s name, if the format allows you to do so. Once you click on the Page Number tab, the selected will be added with “ &,” which is nothing but the starting page number “1”. This will enable the cell where you want to see Page Numbers in every sheet. For that, go to any page or footer of the first page and click on the Page Number tab from the Design option from the Header and Footer Tools menu. Now, here we will see another step of adding page numbers. Below, we can see the main Product Sale in the main header, which is in bold and high in text size document revision number and Document type as Sample Data are kept in the corner of the Header. Now in the header, you can enter the name of the table, document revision number, and the type of data in a different format or font size, as per your requirement. Now click on the Header tab, and it will be to be filled with text. Here, our data is arranged in a page set with all columns of a table on a single page. Once you click on Header and Footer, then Header and Footer option will be activated in the current opened excel sheet. Now, for adding Header and Footer in this excel sheet, go to the Insert Menu bar and select Header and Footer.
Here we have Product Sale data of a month in this example. Now to see, how Header and Footer in excel will look like, go to print preview by pressing Ctrl+P or go to Print option in the File menu to see the preview. Put the cursor on Click to add Footer, and enter footer name as per need. (If the page size is large, which is normally a default set, go down to change footer)
#How to unhide header and footer in word how to
Have you learned about how to insert page numbers to a header or footer in word documents ? If you want to know more about WPS Office, you can download WPS Office software to process documents or others in Word, Excel and PowerPoint for free.Now go down to enter or change Footer. Click the From current page button to set the page to start page numbering from a specific page. Then, you can click the Insert Page number drop-down button.ģ. L How to start page numbering from a specific page?Ģ. Double click the page number and select the page number to enter last name next to the page number. L How to a dd l ast n ame with page numbers in WPS Office Writer?ġ. Click the Delete Page Num button to delete page numbers for all pages at once. Go to the Insert tab and click the Page number drop-down button.Ģ. L How to delete page numbers for all pages at once in WPS Office Writer?ġ.
Then you can choose the following page number formats to insert page numbers into headers or footers in word. Head to the Insert tab to click the Page Number drop-down button.Ģ. L How to insert page numbers to a header or footer in WPS Office Writer?ġ. This article will introduce to you how to insert page numbers to a header or footer in word documents. It is convenient for users to insert page numbers in Microsoft Office and WPS Office Writer. Page numbers help identify the order and the total number of pages. In everyday use of Word, we often need to add page numbers to a header or footer in word documents.