How to Use WPS Smart Fill on macOS

Use WPS Smart Fill through 3 how-to topics, including turning on Smart Fill, trying extraction, and trying merge-based filling; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Turn on Smart Fill

Feature entry: Data → Smart Fill

1. In a new column next to the source data, manually enter one expected result as an example.
2. Select the example cell and the range below that you want to fill.
3. Click Smart Fill on the Data tab.
4. Wait for WPS to identify the pattern and fill the remaining cells automatically.

Success Criteria

• Interface result: The target range shows results generated with the same pattern.
• What you can do next: You can edit the results, undo the action, or save the file.

Tips While Using

• Common mistake: If you select only the example cell and not the target range, the fill result may be incomplete.
• Environment note: Clear examples help the app recognize the pattern more reliably.

2. Try Smart Extraction

Feature entry: Enter an extraction example → Command + E

1. In the target cell, enter one extraction example, such as a surname taken from a full name.
2. Select the example cell and the range below where results should appear.
3. Press Command + E to run Smart Fill.
4. Check whether the remaining rows are filled with the same extraction rule.

Success Criteria

• Interface result: The target column shows extracted text segments based on the example.
• What you can do next: You can add clearer examples and run it again if needed.

Tips While Using

• Common mistake: If the example is ambiguous, the extracted results may not match your expectation.
• Environment note: Source data works better when it follows a stable text structure.

3. Try Smart Merge

Feature entry: Enter a merge example → Smart Fill

1. In a new column, enter one example that combines data from multiple columns.
2. Select the example cell and the target range below it.
3. Click Smart Fill or press Command + E.
4. Check whether WPS has merged text, numbers, or other values with the same rule.

Success Criteria

• Interface result: The new column shows merged results in a consistent format.
• What you can do next: You can continue editing the merged content and use it for sorting, filtering, or export.

Tips While Using

• Common mistake: Empty source cells or large format differences may require manual review after filling.
• Environment note: Decide the target display format before entering the example.