WPS Fill on macOS FAQ

Last updated:July 20, 2026

When using WPS Fill on macOS, common questions usually involve sequence behavior, formula results, and overwriting existing data; this FAQ covers 3 frequent questions.

FAQ

How do I stop fill from increasing serial numbers automatically?

  1. Complete the drag fill action first.
  2. Click the quick menu button near the filled range.
  3. Choose an option such as Copy Cells instead of using the sequence result.

What should I do if formulas look wrong after filling?

  1. Check the cell references in the first formula.
  2. Confirm whether some references should stay fixed.
  3. Drag fill again and review whether the formulas in adjacent cells match your expected result.

Will fill overwrite existing data?

  1. Check whether the target range already contains content before dragging.
  2. If the existing data must be kept, adjust the fill range or back up the data first.
  3. Run the fill action only after confirming the target area.

Glossary

TermDefinition
Fill handleThe small square in the lower-right corner of a selected cell that you can drag to copy or extend content.
Series fillA fill method that continues numbers, dates, or other patterned content based on existing values.
Relative referenceA formula reference that changes automatically when the formula is copied or filled into another cell.