How to use the page break preview feature

Uploaded time: August 26, 2021 Difficulty: Primary

How to use the page break preview feature

How to use the page break preview feature

Tips: you can turn on the volume by clicking

Graphic skills

When you need to print a table at work, sometimes you may find that the table cannot be printed on one page. And also when you need to output a table as a PDF file, it sometimes will be divided into several pages. In this case, you can use the Page Break Preview feature of Spreadsheet. It can help you to preview the paging area.



Take this table as an example. Click the View tab of the tab feature panel and then the Page Break Preview button. In this page break preview interface, you can see the dividing lines around the table and the number of showed pages. The content within the blue dividing lines of the page break preview can be exported and printed. The content outside the blue dividing lines of the page break preview cannot be exported and printed. 


Now if we use the mouse to drag the dividing lines, we can better adjust the display area of each page. 

For example, now we want to print these four pages of the table on one page. Drag the horizontal and vertical blue dividing lines to the right and the bottom respectively. In this way, the contents of the four-page table can be printed on one page. 



If we want to divide this table into two pages, just place the mouse on the row where you want to break. Select the entire row in the WPS Spreadsheet, and then click the Insert Page Break drop-down button in the Page Layout tab to divide the one-page table into two pages.



Moreover, If we want to include the title on every page, we can click the Print Title button in the Page Layout tab, and find Rows to repeat at top in the pop-up Page Setup dialog box. All we need to do is to enter the row of the title that needs to be printed repetitively. Then click the Print Preview button below to preview the set effect.



What a practical feature! Easy your work with WPS Spreadsheet like Microsoft Excel. Did you get it?