Download WPS Office for your device

When we encounter many blank rows in a table, it can be troublesome to delete them one by one. Then how can we accurately delete all the blank rows in batches at once? We click the Home tab, find the Find and Replace drop-down button under the tab, and choose the Go To option. Or we can use the shortcut key Ctrl+G to open the dialog box.In the Go To dialog box, check the Blanks option, and then click Go To. We can see that all the blank rows are selected. Click the right mouse button, ....

When printing WPS Spreadsheet, in order to print out the table more readable and more beautiful, we can set up the printed page of the table. Take this table as an example. First, click the Page Layout tab and then click the Print Titles button to enter the Page Setup dialog box. If we want to print a specific part of the area, select the area that needs to be printed in the Print area box. If we want to print too much data, we can print them on several pages. Except for the first pag....

After editing the document, we sometimes may want to insert a blank page in the middle to supplement related content. So how can we do that? After clicking the page, click the Blank Page drop-down button in the Insert tab. Here, we can choose Vertical Text Box or Horizontal Text Box.GIf If we want to delete a blank page, place the mouse on the blank page. Now hold down the Backspace key, and press the Delete key to delete the blank page.GIf This skill could be compatible with Microsoft....

Are you confused about the blank pages between pages in a document? And you only press the Backspace key repeatedly to delete them, and you fail sometimes.So how can we delete blank pages quickly? Here I'll introduce three methods to you. Tips: Before deleting the blank pages, we can show paragraph marks first to know why these blank pages were generated. Head to the Home tab, click the Show/Hide Editing Marks drop-down button and check Show/Hide Paragraph Marks.· Delete paragraph ....

A table of contents, also called TOC, is a significant part of an article. It can help readers to get the outline quickly and locate the target part. In WPS, we can insert a table of contents in a convenient way. Click the blank page inserted at the beginning of the article. Get into the Reference tab, and click Table of Contents. In the dropdown menu, we can choose from three styles of the table of contents, which presents in different layouts. Since we have "Heading 1", "Heading 2", ....

When adjusting the page layout of a word document, we can add page borders and change their styles. In this example, if we want to insert page borders of the palm tree style, how can we realize it? First, click the Page Layout tab, and choose Page Borders to pop up the Borders and Shading window. Here we can access the settings of the page borders, including style, color, and width. We can see the page border of palm trees in the category of Art. In the Preview interface, we can choose....

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 r....

When we are editing a PDF file, what should we do if we want to extract and replace several pages of the content?We can use the Extract Page and Replace pages functions of WPS Premium. If we want to extract the third page of this file and save it separately as a PDF file, click the Page tab, click Extract Page. In the Extract Mode box, select Extract selected page to PDF. In Page range, enter 3.We can add a watermark to the file, and we can also name the newly output file and set the s....