WPS Header and Footer on Windows: Introduction

WPS Header and Footer is a print layout feature in WPS Spreadsheets; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Header and Footer lets you add fixed content to the top and bottom of printed worksheet pages, such as page numbers, dates, file names, and company names. You can open the editing mode from the Page tab or from Print Preview, use preset styles for quick insertion, or enter custom content in the left, center, and right sections. It also supports inserting pictures, page numbers, time, and total page count.

This feature is useful for printed reports, worksheets that need page numbering, and archived files that should display dates or file names. It helps keep printed output consistent and reduces repeated manual entry.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local header and footer editing
Other	You need an editable spreadsheet file, and it is recommended to check the final result in Print Preview

Download & Installation

Before using Header and Footer, install WPS Office on your Windows device.

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Spreadsheets, then confirm that the Header and Footer entry is available on the Page tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheets, you can enter header and footer editing mode, use preset styles, and insert text, pictures, page numbers, time, and total page count in left, center, and right sections.	Word lets you edit existing headers and footers, add page numbers and images, and use a different first page option.	Google Docs lets you add headers, footers, page numbers, and page count, and supports different first pages, odd/even pages, and margin settings in pages format.	Notion Sites lets paid users customize the site header, navigation, favicon, and share preview, but it does not provide spreadsheet print headers and footers.	Acrobat lets you add headers and footers to PDFs for final-output documents, including text and page numbering.
WPS Advantages	Advantage: WPS provides a worksheet-focused entry from the Page tab or Print Preview, with both preset styles and section-based custom editing for print-ready spreadsheet pages.	Compared with WPS: Microsoft focuses on document header and footer editing in Word rather than worksheet print layout.	Compared with WPS: Google supports document page headers and footers, but the feature applies to Docs pages rather than spreadsheet print pages.	Compared with WPS: Notion focuses on website-style header customization for published pages, not print headers and footers.	Compared with WPS: Adobe is suited to adding headers and footers after a PDF is finalized, not during spreadsheet editing.
Official Source	—	Edit headers and footers in Word	Use headers, footers, page numbers and footnotes	Edit and customize your Notion Sites	Add headers and footers to PDFs in Acrobat

Overall Conclusion
If your main goal is to manage headers and footers for spreadsheet printing, WPS offers a direct worksheet entry and a combination of preset and custom editing. Microsoft and Google are more document-focused in their official guidance, Adobe is more suitable for finalized PDF output, and Notion is aimed at website header presentation.

Use Cases

No.	Scenario	Suitable for	Core need	How it helps
1	Printing financial reports	Finance and admin teams	Multi-page reports need consistent page numbers and dates	Use preset headers and footers to insert page numbers and dates
2	Exporting archived files	Office staff	Printed files need file names or company names	Enter fixed text in a custom header or footer
3	Separating the first page from later pages	Project teams	The first page and later pages need different content	Turn on Different First Page or Different Odd and Even Pages
4	Adding brand identifiers	Business users	Printed pages need a consistent visual identity	Insert pictures and text in custom sections
5	Checking layout before printing	All users	Standard editing view does not show the final print result clearly	Open Header and Footer from Print Preview and review the layout

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic spreadsheet header and footer setup	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Advanced PDF and more advanced tools	Limited in scope for some features	Broader access to advanced tools and extended capabilities
Cloud storage	1 GB	20 GB
Template downloads	Limited	More template benefits

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You only need to add headers and footers to worksheets and print occasionally	Free	The feature itself is available directly for everyday printing needs
You also need more PDF tools, cloud storage, or template benefits	WPS Premium	Suitable for broader document workflows and storage needs

WPS membership center: Subscribe now