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
  3. Click the Symbol button
  4. In the symbol panel, select the desired symbol, choose a font, and select Symbol (Hex) or Symbol (Decimal)
  5. Click Insert

【EN】WPS Sheets Symbol Feature User Guide_截图01

Quick Insert

Feature Entry
"Insert" tab → "Symbol" drop-down menu

  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. Click "Other Symbols" to browse more symbol content

【EN】WPS Sheets Symbol Feature User Guide_截图02

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

【EN】WPS Sheets Symbol Feature User Guide_截图03

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

【EN】WPS Sheets Symbol Feature User Guide_截图04

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 Ctrl+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