Download WPS Office for your device

How can users quickly enter information in the table according to standard content? Drop-down list can help us to do that. Take this table as an example. Now we need to perfect the data in the “Gender” column. We can easily do that by using the drop-down list. 1. First, select the C2: C16 cell range.2. Then click the Insert Drop-Down List button in the Data tab. 3. We can select the Add choices drop down manually button in the popup dialog box and enter Male in the text box below. 4. T....

The Data Validation feature of the WPS Spreadsheet can help us quickly complete the setting of input conditions and drop-down menus, thereby improving the accuracy of our input data.Take this form as an example. Now we need to enter a 9-digit US passport number in column C. We can use Data Validation to improve the accuracy of our input data.1. Select the cell range, then click the Data tab. 2. Click the Validation drop-down button.3. Now select the Validation option in the drop-down m....

When there are too many pictures or tables inserted into a document, we can make a table of figures. It can generate a list of captioned objects and their page numbers for quick location. So how do we insert the table of figures? In this document, for example, we have inserted 6 images with captions.Click the location where we need to insert the table of figures, and click the Insert Table of Figures button on the References tab to get a dialog. On the left side of the dialog, we can ....

When we edit a document with WPS Writer, if we want to highlight the separation of paragraphs, we can set a Drop Cap effect in the paragraph. In this way, the first letter of the paragraph is a large capital letter and it occupies multiple lines, making the paragraph separation more noticeable. · 1. DroppedTake the first paragraph as an example. Select this paragraph. Click the Insert tab and the Drop Cap button, then a dialog will pop up. In the Position area, we can choose None, Drop....

WPS Office fulfils our needs to mark on a PDF. It provides various kinds of comment or marking functions. Today, you will learn practical methods of using the Note function in WPS PDF. If you want to make notes for certain content on a PDF, you can insert a comment into the corresponding place. To realize it, get into the Comment tab and click the Note button. You can also find the Note button in the Insert tab. Choose a color for your note and click on any place on the page to insert ....

When we are using WPS Document, we often encounter situations where we need to insert pictures into the document. So, how can we insert pictures and set images in the Document? Take this speech draft as an example.1. Click the Insert button on the tab of the upper side of the screen.2. Then select the drop-down button of Picture.3. Click From File in the popup window.4. Select the image you want to insert, and click Open. We can now see that the picture is inserted into the document su....

When using WPS Spreadsheet, we often need to insert some special characters in the text content. Sometimes when we need to insert special symbols such as m2, ℃, etc., it is not quite convenient to use the keyboard to input them. At this time, we can use the Symbol feature of WPS Spreadsheet to meet our needs. Take this table as an example. This is the Weekly Attendance Sheet of employees. We now need to add an area unit m2 after 1000 in the third row. Click the Insert tab, and then cli....

Inserting patterns and shapes can increase the aesthetics of the document. Take this document as an example. We can add shapes to make workflow diagrams. For all, easy your work with WPS Writer. First, click the Insert tab, and click the Shapes button. In the selection list, we can see different categories, namely Lines, Rectangles, and Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners and Callouts. These shapes can be selected according to personal needs. In th....