How to Use WPS Fill on Windows

Use WPS Fill through 2 how-to topics, including drag-to-fill and sequence fill options; choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. Use drag-to-fill

Entry path: Select a cell and drag the fill handle at the lower-right corner of the cell

1. Enter data or a formula in the starting cell.
2. Select the cell and move the pointer to the lower-right corner.
3. When the pointer changes to the fill handle, drag down or across.
4. Release the mouse to fill based on the detected pattern, such as increasing numbers, continued dates, or adjusted formula references.

Success Criteria

• On-screen result: the target range shows continuous data, copied content, or formulas with adjusted references.
• What you can do next: you can edit the filled result, undo the action, or save the file.

Tips While Using

• Common mistake: if the starting cell is not selected correctly, the fill handle may not appear.
• Environment note: fill actions apply only within the current worksheet.

2. Set sequence fill options

Entry path: Drag the fill handle → open the quick menu → choose fill options

1. Complete a drag-to-fill action first.
2. Click the quick menu button at the lower-right corner of the filled range.
3. Select the fill option that matches your goal.
4. If you do not want a sequence, choose options such as Copy Cells or Fill Formatting Only.

Success Criteria

• On-screen result: the filled range updates according to the selected method, with the expected content, sequence, or formatting.
• What you can do next: you can adjust the fill method again or continue editing nearby cells.

Tips While Using

• Common mistake: if you have not completed a drag-to-fill action first, the fill options menu will not appear.
• Environment note: results vary by data type, so check the starting pattern before filling.