Feature Summary

WPS Sheets collaboration mode supports changing the color of text within cells for data categorization, labeling, or highlighting.

Feature Description

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

Operation Steps

Setting Font Color

Feature Entry
"Home" tab → "Font Color" button

  1. Select the cell(s) whose color you want to change
  2. Click the drop-down arrow of "Font Color" (the icon with a colored underline below the letter A) in the "Home" tab
  3. Choose the desired color from the color palette and click to apply it

截图

Using the Floating Toolbar to Set

Feature Entry
Select the cell(s) whose color you want to change → "Floating Toolbar" menu → "Font Color" drop-down menu

  1. After selecting the cell(s), right-click the mouse
  2. In the pop-up Floating Toolbar menu, click the "Font Color" drop-down menu
  3. Select the desired color

截图

Setting Font Color via Right-Click Menu

Feature Entry
Select the cell(s) for which you want to set the color → "Right-Click Menu" → "Format Cells" → "Text"

  1. After selecting the cell(s), right-click
  2. Select "Format Cells"
  3. Switch to the "Text" tab
  4. Select the desired background color

截图

Custom Color

Feature Entry
"Font Color" → "More Colors"

  1. Click the drop-down arrow of "Font Color" and select "More Colors"
  2. In the custom color panel, enter RGB values or pick a color from the color wheel
  3. Click "OK" to apply the custom color

截图

FAQ

Will changing the font color in collaboration mode affect others?

  • Solution: Yes, font color changes are synchronized in real time to all online collaborators.

How to quickly restore the default font color?

  • Solution: Select the cell(s) and click "Automatic" in the "Font Color" drop-down menu to restore the default black color.

Notes

  1. All operations in collaboration mode are synchronized in real time; please maintain communication with team members
  2. If you encounter restricted operations, check whether there is an editing lock or area permission restriction
  3. It is recommended to regularly back up important content via "Version History" to prevent accidental operations