How to Use WPS Fill on macOS

Use WPS Fill with 2 how-to topics, including drag fill and series fill settings; choose a topic from the index and follow the steps to complete it.

How-to Index

How-to Guide

1. Use Drag Fill

Feature entry: Select a cell, then 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 a cross-shaped fill handle, drag downward or to the right.
4. Release the mouse. Numbers can increase, dates can continue, and formulas adjust relative references automatically.

Success Criteria

• Interface result: The target range shows the filled results.
• What you can do next: You can continue editing the filled content, formatting, or formulas.

Tips While Using

• Common mistake: If you drag over cells that already contain data, the original content in that target range can be replaced.
• Environment note: In collaborative spreadsheets, keep the network connection stable so other collaborators can see updates promptly.

2. Set Up Series Fill

Feature entry: After dragging the fill handle, click the quick menu button near the lower-right corner of the filled range.

1. Complete a drag fill first.
2. Click the quick menu button at the lower-right corner of the filled area.
3. Open the Auto Fill Options-related settings in the menu.
4. Choose options such as Copy Cells or Fill Formatting Only to adjust the result.

Success Criteria

• Interface result: The filled range updates according to the selected option.
• What you can do next: You can continue copying, adjusting formatting, or filling the same area again.

Tips While Using

• Common mistake: If you do not complete a drag fill first, the quick menu does not appear near the target range.
• Environment note: Fill results vary by data type, so it is helpful to confirm the result on a small range first.