Feature Summary

The fill color feature is used to set the background fill color of cells for data classification, visual distinction, or sheet beautification.

Feature Description

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

Steps

Set Fill Color

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

  1. Select the cells for which you want to set the background color
  2. Click the drop-down arrow of the "Fill Color" (paint bucket icon) in the "Home" tab
  3. Select the desired color from the color palette and click to apply it

image

Set Fill Color Using the Right-Click Menu

Feature Entry
Select the cells for which you want to set the color → "Right-click Menu" → "Format Cells" → "Celll" →"Fill color"

  1. Select the cells and right-click
  2. Select "Format Cells"
  3. Switch to the "Cell" tab
  4. Select the desired background color from "Fill color" drop-down arrow

image

Custom Fill Color

Feature Entry
"Home" tab → "Fill Color" → "More Colors"

  1. Select the cells for which you want to set the background color
  2. Switch to the "Home" tab
  3. Click the drop-down arrow of "Fill Color" and select "More Colors"
  4. Enter RGB values in the custom color panel or pick a color from the color wheel

image

Clear Fill Color

Feature Entry
"Home" tab → "Fill Color" → "No Fill"

  1. Select the cells for which you want to clear the background color
  2. Switch to the "Home" tab
  3. Click the drop-down arrow of "Fill Color"
  4. Select "No Fill" to clear the background color

image

FAQ

Q1: Will modifying the fill color in collaboration mode affect others?

  • Solution: Yes, fill color modifications will be synced in real time to all online collaborators.

Q2: What should I do if the text is hard to read after applying a fill color?

  • Solution: After setting a darker background color, it is recommended to change the font color to white or a light color to ensure sufficient contrast between the text and the background. Generally, use light text on dark backgrounds and dark text on light backgrounds.

Notes

  1. Fill color only affects the cell background and does not change the text content or formulas in the cell
  2. Use "No Fill" instead of white fill to clear the fill color, in order to maintain the cell's transparent property
  3. It is recommended to preview before printing to confirm that the fill color effect meets expectations