How to Use WPS Smart Fill on Windows

Use Smart Fill through 3 practical topics in WPS Spreadsheet; all 3 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Turn on Smart Fill

Entry: Data > Smart Fill

1. Enter one expected result in a new column next to the source data.
2. Select the example cell and the cells below that you want to fill.
3. Click Smart Fill on the Data tab.
4. Wait for WPS Spreadsheet to detect the pattern and fill the remaining cells.

Success Criteria

• Interface result: the target range is filled with results that follow the same pattern.
• What you can do next: review the output, edit individual cells if needed, or save the file.

Tips While Using

• Common mistake: if the cells below are not included in the selection, the whole target range may not fill at once.
• Environment note: clearer examples usually help pattern recognition stay more consistent.

2. Use Smart Fill for extraction

Entry: Enter an extraction example > Ctrl+E

1. In the target cell, type an example of the text you want to extract from another column, such as a surname from a full name.
2. Keep the cursor in the target column and press Ctrl+E.
3. Wait for WPS Spreadsheet to identify the extraction rule from your example.
4. Check whether the remaining rows are filled with results that follow the same rule.

Success Criteria

• Interface result: the target column shows extracted text based on the example pattern.
• What you can do next: continue adding data, or enter a clearer example and run the action again.

Tips While Using

• Common mistake: if the example does not match the source-data pattern, the results may not match your goal.
• Environment note: start with a clear example that reflects one rule only.

3. Use Smart Fill for merging

Entry: Enter a merge example > Smart Fill

1. In a new column, type one example that combines values from multiple columns.
2. Select the range in that target column that you want to fill.
3. Run Smart Fill.
4. Check whether WPS Spreadsheet combines text, numbers, or both into the target column by following the example.

Success Criteria

• Interface result: the target column shows merged results in a consistent format.
• What you can do next: adjust separators, change the text order, or run Smart Fill again with a new example.

Tips While Using

• Common mistake: if the separator in the example is unclear, the merged result may need a new example.
• Environment note: keeping the target column empty makes the fill result easier to review.