Insert a symbol in the table

Uploaded time: 2021-08-27 Difficulty: Primary

Insert a symbol in the table

Insert a symbol in the table

Graphic skills

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 click the Symbol drop-down button. Here, we can see that there are Recently Used Symbols and Custom Symbols. These are symbols that are more common commonly used in our daily work. We select the unit symbol for per square meter here.

111_01.gif

 

We can also use the special symbols of right and wrong to register the employee's weekly attendance. Click the Symbol drop-down button, and select right and wrong special symbols from the popup drop-down menu. We can also choose different types of right and wrong special symbols.

111_2.gif


If we have a large number of employees, it will be troublesome to input symbols one by one. Therefore, we can combine the Insert Drop-Down List feature with inputting symbols. It will be we more convenient. If you want to learn more about the use of Insert Drop-Down List, you can watch more related videos in our WPS Academy.

111_3.gif

 

In addition, click More Symbols, then the Symbol dialog box will pop up. There are more symbols in Subset. We can choose them according to our needs. We can also select the needed font in Font. As a result, the corresponding symbol style will be changed accordingly.

111_4.gif

 

In Special Characters, we can see some rare symbols, such as Copyright, Registered, Trademark, etc. In the Custom Symbols dialog box, we can delete and move the position of the custom symbol. 

111_5.gif


The two dialog boxes Symbols and Special Characters both have the Insert to Custom Symbols button at the bottom. By clicking this button once, we can place the special symbols that we often use In the Symbols drop-down button. It will be more convenient for us to use when editing the document later.

111_6.gif

 

Easy your work with WPS Spreadsheet like Microsoft Excel. Did you get it?