When using WPS Fill, common questions usually involve sequence recognition, data replacement, and date filling; this FAQ includes 3 frequent questions and a glossary.
FAQ
Can Fill recognize a sequence pattern?
- Yes. Enter starting values with a pattern in adjacent cells, such as 1 and 2.
- Select those starting cells and enter Fill.
- Drag a directional arrow to continue the pattern with increasing or decreasing values.
Will Fill replace existing data?
- Yes. Fill writes results into the target area.
- If the destination cells already contain content, the original values may be replaced.
- Check the target range first, and make a backup if needed before applying the fill.
Can dates be filled automatically?
- Yes. Fill can be used with date values.
- Enter a starting date, and if needed, provide two consecutive dates to help establish the pattern.
- Enter Fill mode and drag an arrow to continue the date sequence into adjacent cells.
Glossary
| Term | Definition |
|---|---|
| Fill | An action that copies existing cell content into adjacent cells or continues content based on an established pattern. |
| Copy Fill | A fill mode that does not recognize increasing or decreasing rules and only copies the original content into the target area. |
| Series Fill | A fill mode that continues numbering, dates, or other sequential content based on the starting pattern. |