When using WPS Fill, 3 common question types come up most often: copying versus incrementing, incorrect formula results, and collaboration sync behavior; this FAQ includes 3 common answers.
FAQ
How do I stop Fill from automatically incrementing numbers?
- Complete the drag fill first.
- Click the quick menu button at the lower-right corner of the filled range.
- Select Copy Cells so the target range keeps the original value instead of continuing a sequence.
What should I do if a formula gives the wrong result after filling?
- Check whether the cell references in the formula should stay fixed.
- If some rows or columns should not change, use
$to create absolute references. - Run drag fill again and confirm that the result matches your expected calculation.
Do fill actions sync in collaboration mode?
- After completing the fill action in a collaborative spreadsheet, make sure the network connection is working normally.
- Wait for the document to save and sync.
- Ask other collaborators to refresh or review the same range again to confirm the latest filled result is visible.
Glossary
| Term | Definition |
|---|---|
| Fill handle | The small square at the lower-right corner of a selected cell that you drag to copy content or continue a sequence. |
| Relative reference | A formula reference that changes automatically based on the destination cell when the formula is copied or filled. |
| Auto Fill Options | The quick menu that appears after dragging Fill, allowing you to switch between results such as Copy Cells or Fill Formatting Only. |