Insert Page Break in WPS helps you control where spreadsheet content starts a new printed page; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | 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
Insert Page Break is a page setup feature in WPS Sheets for macOS. It lets you manually insert or remove print page breaks at a selected cell position so you can control how worksheet content is split across printed pages.
This feature supports the following print-layout tasks:
- Insert page breaks above the selected cell, to the left of the selected cell, or in both directions.
- Delete the current manual page break or reset all manual page breaks in the worksheet.
It is useful for report printing, section-based output, and page layout adjustment. In practice, automatic page breaks are typically shown as dashed lines, while manual page breaks are typically shown as solid lines.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Mac device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office for Mac |
| Network | Inserting and deleting page breaks is a local editing feature and does not require a constant network connection |
| Other | Open a WPS spreadsheet file and make sure it is editable |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Launch WPS Office, open a spreadsheet, and confirm that the Page tab includes the Insert Page Break entry |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In WPS Sheets, you can insert page breaks, delete page breaks, or reset all page breaks from the Page tab, with horizontal, vertical, or two-direction break control based on the selected cell position. | Word lets users insert a manual page break to start content on a new page, but the feature is designed for document layout rather than spreadsheet print pagination. | Google Docs lets users add page breaks and section breaks in documents, but this applies to paged documents rather than spreadsheet print break management. | Notion provides layout tools such as dividers and page formatting blocks, but its help content does not describe print page break control for worksheet-style output. | Acrobat provides PDF printing controls such as printer selection, scaling, and duplex options, but it does not describe inserting cell-level page breaks during spreadsheet editing. |
| WPS Advantages | Advantage: WPS works directly in a spreadsheet print-layout workflow. Distinct: it supports deleting one manual page break or resetting all manual page breaks from the worksheet. | Compared with WPS: Microsoft Word focuses on document page starts and does not describe cell-position-based horizontal and vertical break behavior for spreadsheets in this page. | Compared with WPS: Google Docs focuses on document page and section breaks, and these features require the document to be in pages format. | Compared with WPS: Notion is more suited to organizing content blocks than controlling printed page boundaries in a spreadsheet. | Compared with WPS: Adobe Acrobat is centered on printing existing PDFs rather than setting manual page breaks while editing worksheet content. |
| Official Source | — | Insert a page break in Word | Add page breaks and move margins | Format your page | Basic PDF printing tasks |
Overall Conclusion
If you need to fine-tune where spreadsheet content breaks before printing, WPS is a practical fit because the feature is built around worksheet pagination. Other products are better aligned with document page breaks, content structuring, or PDF output workflows.
Use Cases
| No. | Scenario | Suitable for | Core issue | How this feature helps |
|---|---|---|---|---|
| 1 | Monthly report printing | Finance teams, administrative staff | Printed tables break across pages in awkward places | Insert page breaks at key cells to control what appears on each page |
| 2 | Section-based data output | Operations teams, sales teams | Different data blocks need to be printed separately | Insert page breaks before section boundaries for modular output |
| 3 | Cleaning up manual pagination | Spreadsheet maintainers | Too many manual breaks remain after repeated edits | Delete page breaks or reset all page breaks to restore the layout |
| 4 | Reviewing print layout | General office users | Automatic page breaks do not match reading habits | Check pagination in print-related views and adjust breaks manually |
| 5 | Controlling row and column breaks together | Spreadsheet creators | Both horizontal and vertical content areas need separate printing | Select a non-starting cell to create break control in both directions |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Insert page breaks | ✅ Available | ✅ Available |
| Delete page breaks | ✅ Available | ✅ Available |
| Reset all page breaks | ✅ Available | ✅ Available |
| Cloud storage and broader advanced features | Basic benefits | More extended benefits |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Everyday spreadsheet printing and basic pagination adjustment | Free | Inserting, deleting, and resetting page breaks covers common print layout needs |
| Users who also need more cloud storage or broader office features | WPS Premium | Suitable for people who want added storage, templates, or other extended office capabilities |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page