WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How to insert Page Break in WPS Spreadsheet

Uploaded time: November 18, 2021 Difficulty Beginner

How to insert Page Break in WPS Spreadsheet

How to insert Page Break in WPS Spreadsheet

When we want to print a table but do not want to print all the contents on one page, we can Insert a Page Break to break the table into different pages.

First, click the Page Layout tab. Click the Page Break Preview button to enter the Page Break Preview mode, where we can see only one page.

Select a cell in the page break preview state and click Insert Page Break to generate split lines on the top and left of the selected cell. Now the table is split into four pages.

If we select one row, a split line will be generated above that row and the table is split into two pages.

What a practical feature! Did you get it?

For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.