Use WPS Find through 4 how-to topics, all available without membership; choose a topic from the index to complete search or replacement tasks.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Find content from the top menu | Free |
| 2 | 2. Replace content from the top menu | Free |
| 3 | 3. Find content from the tools area | Free |
| 4 | 4. Replace content from the tools area | Free |
How-to Guide
1. Find content from the top menu
Entry path: Tap the top-right “☰” icon → Tap “Find and Replace” → Select the “Find” tab
- Tap the “☰” icon in the top-right corner.
- Tap Find and Replace.
- Select the Find tab.
- Enter the keyword you want to search for.
- Tap Search to view matching cells.
Success Criteria
- Interface result: The Find panel opens and shows a text box and a search button.
- What you can do next: You can continue reviewing matched results or editing spreadsheet data.
Tips While Using
- Common mistake: If the keyword is entered incorrectly, the target content may not be found.
- Environment note: Open a spreadsheet file before using this entry path.
2. Replace content from the top menu
Entry path: Tap the top-right “☰” icon → Tap “Find and Replace” → Select the “Replace” tab
- Tap the “☰” icon in the top-right corner.
- Tap Find and Replace.
- Select the Replace tab.
- Enter the search text and replacement text.
- Tap Replace to replace one match.
- Or tap Replace All to replace all matched content.
Success Criteria
- Interface result: The Replace panel shows both the search field and the replacement field.
- What you can do next: You can continue replacing the next match or return to the sheet to review the result.
Tips While Using
- Common mistake: If you do not confirm the keyword before using Replace All, multiple cells may be changed unexpectedly.
- Environment note: Check the target field in the spreadsheet before replacing content.
3. Find content from the tools area
Entry path: Tap Tools at the bottom → Select the View tab → Tap Find and Replace → Select the Find tab
- Tap Tools at the bottom.
- Select the View tab.
- Tap Find and Replace.
- Select the Find tab.
- Enter the keyword you want to search for.
- Tap Search to find matching cells.
Success Criteria
- Interface result: The Find panel opens successfully from the bottom tools area.
- What you can do next: You can continue browsing matches and return to the editing view.
Tips While Using
- Common mistake: If you are not on the correct tab, the search field may not appear.
- Environment note: The position of the bottom tools bar may vary with different editing states.
4. Replace content from the tools area
Entry path: Tap Tools at the bottom → Tap Find and Replace → Select the Replace tab
- Tap Tools at the bottom.
- Tap Find and Replace.
- Select the Replace tab.
- Enter the search text and replacement text.
- Tap Replace to replace one match.
- Or tap Replace All to replace all matches.
Success Criteria
- Interface result: The Replace panel accepts both text entries normally.
- What you can do next: After replacing content, you can return to the spreadsheet and verify the result.
Tips While Using
- Common mistake: If the replacement field is left empty, the original content may be cleared.
- Environment note: Before batch replacement, check whether the target fields are consistent.