When using WPS Fill, common questions usually involve sequence rules, formula results, and collaboration syncing; this FAQ includes 3 frequent questions and a glossary.
FAQ
How can I stop serial numbers from increasing automatically when I fill cells?
- Complete a drag-to-fill action.
- Click the quick menu button at the lower-right corner of the filled area.
- Select Copy Cells so the target area keeps the original value instead of continuing the sequence.
What should I do if a formula gives the wrong result after filling?
- Check whether the formula references should stay fixed.
- If some rows or columns should not change, use
$to create absolute references. - Drag to fill again and confirm whether the result matches your expectation.
Do fill actions sync in collaborative mode?
- After filling, confirm that the current network connection is working normally.
- Wait for the spreadsheet to save and sync in the collaboration environment.
- Ask collaborators to refresh or reopen the spreadsheet to confirm that the latest filled result appears.
Glossary
| Term | Definition |
|---|---|
| Fill handle | The small square in the lower-right corner of a selected cell. Dragging it can copy content or continue a series. |
| Auto Fill Options | The quick menu that appears after dragging to fill. It lets you switch between copy, series, or formatting-related fill methods. |
| Relative reference | A cell reference in a formula that changes automatically based on position when the formula is copied or filled. |