Download WPS Office for your device

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

When editing WPS presentation files, we will inevitably need to enter some symbols that cannot be directly entered through the keyboard. So, how can we insert the special symbols as needed? Take the slides as an example. To facilitate statistics, we want to tick the box after the tourist attractions we have already visited. Click where we want to insert the symbol, click the Insert tab and the Symbol drop-down button. Here, we can see Recently Used Symbols and Custom Symbols. These are....

When we edit a document, we will inevitably need to enter some symbols that are not directly entered by the keyboard input method. So, how do we insert the special symbols that we need? Take this document as an example. We want to tick the tourist attractions we have visited to facilitate statistics. Click the position where we want to insert the symbol and click the Insert tab and the Symbol drop-down button. We can see Recently Used Symbols and Custom Symbols here. These are the ....

This is a table of information about the department employees. If we need to calculate the average weight of the staff, what should we do?Normally, you only need to enter the formula =AVERAGE(D2:D8) in cell D9 to get the average.However, the formula returns 0, and obviously, the result is incorrect because there are text characters in the cells, which affects the accuracy of the calculation. Do you know how to retain the weight unit and normally perform the calculation at the same time....

When we edit documents, insert project symbols into appropriate places that could highlight corresponding text contents. In this way, the text would be classified with structured classes. How can we insert project symbols in WPS text? Taking this document as an example, we can see that the difference in font size does not reflect the level of contents very well. If we want to emphasize the relationship between contents, how should we do it? 1. First, choose the corresponding text. 2. ....

When using tables to enter data, if we often need to enter symbols, we can set shortcut keys for commonly used symbols, which can improve our work efficiency. Take this size chart as an example. We need to enter the length unit cm multiple times, so how can we get a quick input? Click the Home tab, and the Symbol drop-down button, then click More Symbol to pop up a dialog box. Click the Custom Symbols tab, and then we can see that there are many system-defined symbols, including the cm....

In the process of editing documents, we occasionally need to re-enter the same symbols. Take this table as an example. When we make an account for purchased fruits, we need to enter the weight unit kg, so how can we quickly enter it? In the Insert tab, click the Symbol drop-down button, and then click More Symbol to pop up a dialog box.In the Custom Symbols tab, we can see many system-defined symbols, including the kg we need to enter. After clicking kg, click the Shortcut keys edit b....

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