Use Fill Color with 2 how-to topics on iOS, including applying a cell background color and clearing it; 2 topics are available without membership and 0 are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Apply Fill Color to Cells | Free |
| 2 | 2. Clear Fill Color from Cells | Free |
How-to Guide
1. Apply Fill Color to Cells
Entry path: Tools → Home → Fill Color
- Select one or more cells that need a background color.
- Tap Tools at the bottom of the screen.
- Open Home and tap Fill Color.
- Select the color you want from the color panel.
- If you need more choices, tap ....
- The selected cells update with the new background color immediately.
Success Criteria
- Visual result: The selected cells show the new background color.
- Next action available: You can continue editing, change font color, or save the file.
Tips While Using
- Common mistake: If no cells are selected first, the color may not apply to the intended area.
- Display tip: If you use a dark fill color, adjust the font color for better readability.
2. Clear Fill Color from Cells
Entry path: Tools → Home → Fill Color
- Select one or more cells that already have a background color.
- Tap Tools at the bottom of the screen.
- Open Home and tap Fill Color.
- Select No Fill (the ∅ icon).
- The cell background returns to the default transparent state.
Success Criteria
- Visual result: The previous background color is removed and the cells return to the default display.
- Next action available: You can apply another fill color or continue editing the spreadsheet.
Tips While Using
- Common mistake: Choosing white is not the same as clearing fill; use No Fill instead.
- Formatting tip: Before unifying table styles, clear old fill colors in the target cells first.