Download WPS Office for your device

We often deal with tables with vast amounts of data at work. When we move the page, we can locate the content we are focusing on, but we cannot quickly know the row and column names of the cells. But now, with the Reading Layout of WPS Spreadsheet, users can quickly locate the row and column names of the cells that they are concerned about. Take this table as an example. Click the View tab, and then the Reading Layout drop-down button. In this mode, once a cell is selected, we can fin....

A well-formatted presentation file can better your speech, and properly adding animation effects can help capture the audience's attention. So how can we customize the animation? Take these slides as an example.1. Click the Animation tab at the top, then the Custom Animation task pane will pop up on the right side of the screen. Now we click Selection Pane.2. In the Selection Pane task pane, we can see all the elements of the current slide page.3. Click the eye icon on the right to....

We can use the caption feature to number and annotate images, charts and other contents referenced in a document. So how do we use this feature? We take the image in this document as an example. Select the image, click References, and then click Caption to get a pop-up dialog.Click the Label pull-down to select the label you want. If none is available, you can click New Label to customize a label such as a Picture.Then select the Position of the caption. Click the Numbering button, you....

1.In this lesson shared several chart types, such as column, line, pie, bar, area, scatter, radar, and bubble chart. Each chart has its own features and imperfections. We should pick the chart that best fits the topic. 2.Many different elements make up a chart, such as a chart title, data labels, trendlines, and so on. We should pick elements appropriately, concisely, and clearly. 3.We also learn the basics of ribbon buttons. We know how to change the chart type, how to switch rows and....

We can use the Name Manager to set a fixed name for the cell area, which can be more simple and intuitive in function calculations and it can be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. We can select the cell range from A2 to A10 and click the Name Manager in the Formulas tab. Its shortcut key is Ctrl+F3.In the pop-up dialog box, click New, enter a custom name, select the scope of use, and finally click OK.In this way, we will give the ce....

Navigation Pane works like GPS in WPS Office, allowing users to find and locate text and adjust article structures more efficiently. 1. We need to open the Navigation Pane. Click the View tab, select Navigation Pane, and then it will appear on the left. 2. We can also click the Navigation Pane drop-down button and choose Move to Right according to our habits.There are four icons on the left, namely, Content, Section Navigation, Bookmark, and Find and Replace.· ContentHere is the table ....

When creating tables, we often need to insert check boxes to check the information quickly and check multiple options at once. Today we'll learn how to insert check boxes. Take this Registration of Selected Courses table as an example. 1. Go to the Insert tab, click the Forms drop-down button, and select the Check box. 2. The cursor becomes the shape of a cross, and you can insert a check box by dragging the mouse.3. Input text in the check box, such as "French."Then the check box ....

Radar chart displays data information on one dimension like a spider web, allowing us to learn the relationships between each piece of data to the whole and compare them quickly.Take this table as an example, which is a table of the competency rating of three employees this year. It's difficult to find out the differences between them only with this data, so we can use a radar chart to make it clear. 1. Select the needed cell range, click the Insert tab and click the Radar drop-dow....