How to Use WPS Fill on iOS

Use WPS Fill through 3 how-to topics, including turning on Fill, dragging fill arrows, and using Copy Fill; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Turn on Fill

Entry: Method 1 is Tools → Home → Fill; Method 2 is Floating menu bar → Fill

1. Select the cell range that you want to fill, and make sure the source data starts at the top or left side of the range.
2. If you use the tool-area entry, tap Tools and then tap Home.
3. Tap Fill.
4. Or tap the selected range to open the floating menu bar, then tap Fill.
5. When Fill mode starts, draggable arrows appear to the right and below the source cell.

Success Criteria

• Interface result: The selected range stays highlighted, and fill arrows appear to the right and below the source cell.
• What you can do next: You can drag downward or to the right to continue filling.

Tips While Using

• Common mistake: If you do not select the target cell range first, the Fill entry or fill arrows may not appear.
• Environment note: This feature must be used in an editable spreadsheet.

2. Fill by Dragging the Arrows

Entry: After Fill mode is enabled, drag the arrow to the right or below the source cell

1. First complete the steps in Turn on Fill.
2. Check the arrows that appear to the right and below the source cell.
3. Drag downward to fill adjacent cells below.
4. Drag to the right to fill adjacent cells on the right.
5. When finished, tap another area of the sheet to exit Fill mode.

Success Criteria

• Interface result: The target area shows the filled content.
• What you can do next: You can continue editing, save the file, or select another range to fill.

Tips While Using

• Common mistake: If the target area already contains data, Fill will overwrite the existing content.
• Environment note: In a filtered sheet, Fill affects visible cells only and does not fill hidden rows.

3. Use Copy Fill

Entry: After dragging to fill, tap Copy Fill at the top of the fill operation interface

1. Drag a fill arrow once to complete a downward or rightward fill.
2. Check for the Copy Fill button at the top of the fill operation interface.
3. Tap Copy Fill.
4. The app will stop continuing a sequence and will copy the original content instead.

Success Criteria

• Interface result: The target area repeats the original value instead of continuing a sequence.
• What you can do next: You can adjust the fill range again or exit Fill mode.

Tips While Using

• Common mistake: If you want numbers to continue in order, do not switch to Copy Fill.
• Environment note: Copy Fill also overwrites existing content in the target area, so confirm the destination first.