How to Use WPS Fill on Android

Use WPS Fill on Android through 4 how-to topics, all available directly on mobile; 4 topics are available without membership and 0 are membership-related, so you can jump from the index to the exact workflow you need.

How-to Index

How-to Guide

1. Open Fill from the toolbar

Entry path: Tools → Home → Fill

1. Select the cell range you want to fill, and make sure the source data is at the top of the range.
2. Tap Tools.
3. Tap Home.
4. Find and tap Fill.
5. Choose Fill Down, Fill Right, Fill Up, Fill Left, or drag-based fill as needed.
6. Tap another area of the sheet to exit Fill.

Success Criteria

• Interface result: You can see fill direction options or a drag-fill entry.
• Next action available: You can keep editing, save the file, or choose another fill method.

Tips While Using

• Common mistake: If you do not select the target range first, the fill range may not match your expectation.
• Environment note: Existing data in the target range may be replaced.

2. Drag Fill from the floating menu bar

Entry path: Floating menu bar → Fill

1. Tap the cell range you want to fill to open the floating menu bar.
2. Find and tap Fill.
3. Check that arrows appear on the right side and bottom of the source cell.
4. Drag the arrows as needed to fill down, right, up, or left.
5. Tap another area of the sheet to exit Fill.

Success Criteria

• Interface result: Draggable fill arrows appear around the source cell.
• Next action available: The target range shows the fill result after dragging.

Tips While Using

• Common mistake: If the floating menu bar does not open correctly, the Fill entry may not appear.
• Environment note: On smaller screens, it helps to zoom in on the target range before dragging.

3. Use Copy Fill

Entry path: After drag fill → top of the fill action interface → Copy Fill

1. Complete a drag-fill action first.
2. Find Copy Fill at the top of the fill action interface.
3. Tap Copy Fill.
4. Check that the target range matches the source content instead of continuing a series.

Success Criteria

• Interface result: The target range shows the same content as the source cells.
• Next action available: You can adjust the range or switch to another fill method.

Tips While Using

• Common mistake: If you want a number pattern to continue, do not choose Copy Fill.
• Environment note: Copy Fill also replaces existing data in the target range.

4. Use Series Fill

Entry path: After drag fill → top of the fill action interface → Series Fill

1. Enter starting content with a recognizable pattern, such as consecutive numbers.
2. Perform a drag-fill action.
3. Tap Series Fill at the top of the fill action interface.
4. Check whether the sequence continues automatically based on the source content.

Success Criteria

• Interface result: The target range extends with an increasing or continuing pattern.
• Next action available: You can continue extending the same type of sequence to more cells.

Tips While Using

• Common mistake: If the starting data does not show a clear pattern, the result may not match your expectation.
• Environment note: In a filtered sheet, Fill applies only to visible cells.