How to Use WPS Smart Fill on Windows

Use Smart Fill with 3 how-to topics, all available without membership; start from the How-to Index to complete extraction, merging, and batch filling.

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 needs to be filled.
3. Click Smart Fill on the Data tab.
4. Review the results after the system identifies the pattern and fills the remaining cells.

Success Criteria

• The target column is filled automatically according to the example pattern.
• The original data column remains unchanged.
• You can continue editing, copying, or saving the filled results.

Tips While Using

• Clearer examples usually produce more stable recognition results.
• It is recommended to place the target column next to the source data so the fill effect is easier to review.

2. Smart extraction example

Feature entry: Enter an extraction example → Ctrl+E

1. In the target cell, enter an example extracted from another column, such as a surname taken from a full name.
2. Select the example cell or the related fill range.
3. Press Ctrl+E to run Smart Fill.
4. Check whether all matching rows are extracted with the same rule.

Success Criteria

• The system extracts the target field based on the example.
• Multiple rows follow the same extraction rule.
• The results can be used for sorting, filtering, or export.

Tips While Using

• If the source data format varies a lot, add more examples before running the feature again.
• It is a good idea to spot-check the extracted results before using them in later batch tasks.

3. Smart merge example

Feature entry: Enter a merge example → Smart Fill

1. In a new column, enter one example result that combines data from multiple columns.
2. Select the example cell and the range that should receive the output.
3. Click Smart Fill or press Ctrl+E.
4. Check whether the system combines text, numbers, and other content into the target column according to the example.

Success Criteria

• Multiple columns are combined in the order and format shown by the example.
• The target column contains results in a consistent format.
• The source columns are not modified.

Tips While Using

• Before merging, confirm that separators, spaces, and order match your expected result.
• If the output format is inconsistent, enter a clearer example and run the feature again.