How to Use WPS Fill on Android

Last updated:July 20, 2026

Use WPS Fill with 2 how-to topics, including starting Fill and switching Fill modes; choose a topic from the index and follow the steps to complete the task.

How-to Index

No.TopicMembership Requirement
11. Start FillFree
22. Switch Fill ModesFree

How-to Guide

1. Start Fill

Entry point: Floating edit bar → Fill

  1. Select the cell or range you want to fill to open the floating edit bar.
  2. Tap Fill in the floating edit bar.
  3. Directional arrows appear above, below, left, and right of the source cell.
  4. Drag the arrow in the direction you need to apply the fill.
  5. Tap another area of the spreadsheet to exit Fill mode.

Success Criteria

  • Interface result: draggable directional arrows appear around the selected area.
  • Next action available: adjacent cells show the fill result after dragging.
  • No side effect: tapping another area returns the sheet to normal editing mode.

Tips While Using

  • Common mistake: if no cell is selected first, the Fill entry may not appear.
  • Environment note: Fill writes directly to the target area, so check the destination cells before applying it.

2. Switch Fill Modes

Entry point: Top area of the Fill interface

  1. Complete one drag fill action first.
  2. Find Switch to Copy Fill at the top of the Fill interface and tap it.
  3. The result will stop recognizing increasing or decreasing sequences and will copy the existing value instead.
  4. If you want pattern-based extension again, tap Switch to Series Fill.
  5. Preview the result, then tap another area of the spreadsheet to exit Fill mode.

Success Criteria

  • Interface result: a mode switch button appears at the top of the interface, and its label changes with the current mode.
  • Next action available: the fill result changes according to copy or series rules.
  • No side effect: after you exit Fill mode, the completed result remains in the target area.

Tips While Using

  • Common mistake: if you do not check the current button label, you may use Copy Fill when you intended Series Fill, or the reverse.
  • Environment note: Fill can replace existing data in the target area, so confirm important content before applying it.