Feature Summary

The Symbol feature is used to insert special characters, mathematical symbols, currency symbols, etc. in WPS Sheets, meeting the editing needs of various professional documents.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Insert Symbol

Feature Entry
"Insert" tab → "Symbol"

  1. Select the cell where you want to insert the symbol
  2. Click the Insert tab → Symbol button drop-down menu in sequence
  3. Click on a symbol under "Recently Used Symbols" or "Custom Symbols" to quickly insert it
  4. Browse categorized symbols under "Symbol Collection" or click "More" to open the Symbol Collection
  5. In the symbol panel, select the desired symbol, choose a font, and select Symbol (Hex) or Symbol (Decimal)
  6. Click Insert

image

Using Special Characters

Feature Entry
"Insert" tab → "Symbol" → "Special Characters"

  1. Click the Symbol button
  2. Switch to the Special Characters tab
  3. Select copyright symbol ©, registered trademark ®, etc.
  4. Click Insert

image

Custom Symbol Bar

Feature Entry
"Insert" tab → "Symbol" → "Symbol Bar"

  1. Click "Insert" tab → "Symbol" in sequence
  2. Under "Symbols" and "Special Characters", select the desired symbol and click "Insert to Symbol Bar"
  3. In the "Symbol Bar", select the relevant symbol to "Assign Shortcut Key", "Move Up/Down", or "Delete"
  4. Click "Reset Symbol Bar" to restore the symbol bar to default options

image

image

FAQ

Q1: What should I do if I cannot find the symbol I need?

  • Solution: Enter the symbol code, or switch to a different font to view.

Q2: What should I do if the symbol displays as a box?

  • Solution: Change to a font that supports the symbol, such as Wingdings, etc.

Q3: How to quickly insert a symbol?

  • Solution: Insert the desired symbol into the symbol bar for quick typing via custom symbols, or assign a shortcut key to the symbol in the symbol bar and use the shortcut key for quick typing.

Q4: What should I do if the set shortcut key becomes invalid?

  • Solution:
  1. Check if the assigned symbol shortcut key conflicts with WPS software's own shortcut keys, such as Command+S (Save);
  2. Check if there is a hotkey conflict with other currently running software;
  3. Reassign a shortcut key for the symbol in the "Symbol Bar".

Notes

  • Different fonts may support different symbol sets
  • Frequently used symbols can be added to the symbol bar for quick access
  • Some symbols may display differently across different operating systems
  • The Symbol Collection can be quickly opened in the right-side task pane