WPS Show Page Breaks on Windows: Introduction

WPS Show Page Breaks on Windows helps you display automatic and manual page break positions in Normal view; this guide covers 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

Show Page Breaks is a view assistance feature in WPS Sheets for Windows. It helps you see where pages will break in Normal view so you can review print layout and page splitting more clearly.

Core capabilities include:

Turn Show Page Breaks on or off from File > Options > View.
Switch the display state quickly from the Page tab.
Distinguish automatic and manual page breaks, where dashed lines indicate automatic breaks and solid lines indicate manually inserted breaks.

This feature is useful when you want to check pagination before printing, adjust large worksheet layouts, or confirm manual page break placement.

System Requirements

Item	Requirement
OS	A Windows device
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory network connection is required
Other	You need to open a WPS Sheets file and work in Normal view

Download & Installation

Before using Show Page Breaks, install WPS Office on your Windows device and make sure WPS Sheets opens normally.

Item	Notes
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office, open a spreadsheet, and check whether page break options are available on the Page tab or under File > Options > View

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Displays automatic and manual page break positions in Normal view, and lets you switch the display state from settings or the Page tab.	Word supports inserting page breaks and viewing them through Home > Show/Hide, but the official guidance focuses on document page breaks rather than spreadsheet page break lines.	Google Sheets supports custom page breaks in print settings and lets users drag break lines, with the workflow centered on printing setup.	Notion supports exporting pages or databases as PDF, but its official guidance focuses on export and print output rather than a dedicated page-break-line view for spreadsheets.	Adobe Acrobat provides Read mode, Full Screen mode, and page display preferences for PDF viewing, not spreadsheet page break line management.
WPS Advantages	Advantage: You can check page break positions directly in Normal view. Distinct: Automatic and manual page breaks are visually separated, which helps before printing.	Compared with WPS: Word is more focused on document pagination and editing marks.	Compared with WPS: Google Sheets emphasizes page break adjustment during print setup instead of keeping page break lines visible in the regular editing view.	Compared with WPS: Notion is better suited to document export and organization, not worksheet page break inspection.	Compared with WPS: Acrobat is designed for PDF viewing and page display, not spreadsheet editing with visible page break lines.
Official Source	—	Insert a page break	Print from Google Sheets	Export your content	Viewing PDFs and viewing preferences

Overall Conclusion
WPS Sheets is well suited to worksheet editing and pre-print review when you need to see page break positions directly in the working view. Microsoft and Google provide related page break functions, but their official workflows focus more on document pagination or print setup. Notion and Adobe are more aligned with export or reading scenarios than spreadsheet page break inspection.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Check page ranges before printing	Office staff	It is unclear where content will split across pages	Turn on Show Page Breaks to review break positions directly
2	Adjust large worksheet layouts	Finance and operations users	Large sheets are hard to split into pages intuitively	Review page break lines in Normal view before adjusting rows and columns
3	Verify manual page break placement	Users who need precise layout control	It is hard to confirm whether a manual break is in the right place	Use solid and dashed lines to distinguish manual and automatic breaks
4	Review multi-sheet printing	Project and administrative users	Different worksheets may print inconsistently	Check page break lines sheet by sheet and align page settings
5	Avoid awkward page splits during editing	Users who print reports often	Important data areas may be split across pages	Show page breaks first, then move or resize content

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
Show Page Breaks	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
More advanced office and PDF features	Some features are limited	More advanced features are available
Cloud storage and template resources	Basic quota and basic resources	Higher quota or more resources

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
You only need to view or adjust worksheet page breaks	Free version	Show Page Breaks itself is available directly
You also need more advanced office features	WPS Member	Suitable if you use additional advanced tools at the same time

WPS membership center: Subscribe now