How to Use WPS Fill on macOS

Use WPS Fill on macOS through 2 how-to topics in the spreadsheet interface; 2 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Use drag fill

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

1. Enter data or a formula in the starting cell.
2. Select that cell and move the pointer to the lower-right corner.
3. When the pointer changes to a cross-shaped fill handle, drag downward or to the right.
4. Release the mouse to complete the fill action.
5. If the content is a number, date, or formula, the result extends or updates based on the content type.

Success Criteria

• Interface result: The target range shows the filled content.
• What you can do next: You can continue editing, save the file, or adjust the filled range again.

Tips While Using

• Common mistake: If the starting cell is not selected correctly, the fill result may not match your expectation.
• Environment note: The fill action applies within the target area of the current worksheet.

2. Set series fill options

Entry: After dragging the fill handle, click the quick menu button near the lower-right area of the filled range

1. Complete a drag fill action first.
2. Click the quick menu button near the filled result.
3. Open the Auto Fill options to change the fill result.
4. Select options such as Copy Cells or Fill Formatting Only as needed.
5. Confirm that the updated result matches your spreadsheet task.

Success Criteria

• Interface result: The filled range updates according to the selected option.
• What you can do next: You can continue editing data, formatting, or repeat the fill action.

Tips While Using

• Common mistake: If you have not completed a drag fill first, the related quick menu will not appear.
• Environment note: Different content types can produce different fill results.