When using Symbol, the most common issues fall into 3 groups: finding the entry, symbol display differences, and changes to spreadsheet content after insertion; this FAQ covers 3 common questions.
FAQ
Why can't I find the Special Character entry?
- Make sure the current file is a WPS spreadsheet rather than a Writer or Presentation file.
- Tap Tools at the bottom, then switch to the Insert tab.
- Look for Special Character among the Insert-related tools.
- If the entry still does not appear, update WPS Office and reopen the file.
What should I do if the inserted symbol looks different?
- Check whether the current cell font supports that symbol.
- Try switching to a commonly used font and review the display again.
- If the file will be viewed across devices, check the result on another device as well.
- Save and reopen the file to confirm that the symbol displays consistently.
Why does inserting a symbol affect calculation or alignment?
- Check whether the cell is intended for numeric calculation.
- If the cell participates in formulas, avoid inserting characters that change the data type.
- If you only need to display a symbol, consider placing it in a note column or description column.
- After insertion, review the cell format, formula result, and alignment.
Glossary
| Term | Definition |
|---|---|
| Special Character | A currency symbol, mathematical symbol, or other character that is not convenient to enter with a standard keyboard. |
| Cell | The basic area in a spreadsheet where data is entered. The selected symbol is inserted into the active cell. |
| Symbol Panel | The selection interface used to browse or search available characters for insertion. |