Common questions about WPS Fill on iOS usually involve entry points, fill results, overwrite behavior, and filtered sheets; this FAQ covers 4 common questions and a 3-term glossary.
FAQ
Why can’t I find the Fill option in WPS Sheets on iOS?
- Make sure you opened a WPS Sheets spreadsheet instead of another file type.
- Select an editable cell or cell range.
- Check both Tools > Home > Fill and the floating menu for the Fill entry point.
- If it still does not appear, reselect the cells or reopen the spreadsheet.
Does Fill overwrite existing data?
- Yes. Fill writes content into the target range.
- Before dragging, check whether the existing data in the target cells needs to be kept.
- If needed, test the result in a blank area first.
Why does Fill sometimes continue a sequence and sometimes just copy the same value?
- If the source data follows a clear pattern, Fill can continue that pattern.
- If the source data does not form a pattern, the result usually repeats the original value.
- If you only want to copy the original value, tap Copy Fill after dragging.
How to autofill cells on iPhone in a filtered spreadsheet without affecting hidden rows?
- In a filtered sheet, Fill applies only to visible cells.
- Hidden rows are not filled during the current action.
- After filling, clear the filter if you want to review the full result.
Glossary
| Term | Definition |
|---|---|
| Fill | A spreadsheet action that copies source cell content into adjacent cells or continues data based on an existing pattern. |
| Copy Fill | A fill method that copies the original value only and does not continue a detected sequence. |
| Floating menu bar | A shortcut menu that appears near the editing area after you select cells. |