Common questions about WPS Find and Replace on iOS usually involve missing results, replacement scope, and matching conditions; this FAQ covers 4 frequent questions.
FAQ
Why can't I find content that is already in the sheet?
- Check whether the keyword exactly matches the cell content.
- Review whether options such as case sensitivity or cell matching are turned on.
- If the content may be in another worksheet, change the search scope to all worksheets.
- If the target is inside a formula or comment, turn on formula and comment search.
How do I replace only the current match instead of all matches?
- Open the Replace tab.
- Enter the text to find and the replacement text.
- Tap Replace instead of Replace All.
- Review each result before moving to the next one.
What is the difference between fuzzy search and exact search?
- Exact search is better when you need fully matching content.
- Fuzzy search is useful when the keyword may match only part of the text.
- If you get too many results, switch to a stricter matching method.
What should I check before using Replace All?
- Confirm that the search text will not affect similar fields by mistake.
- Run a normal search first to review the match scope.
- For important spreadsheets, save a copy before replacing all matches.
Glossary
| Term | Definition |
|---|---|
| Find | The action of searching for specific text or content in the current worksheet or across multiple worksheets. |
| Replace | The action of changing found content to new content, either one by one or in a batch. |
| Fuzzy search | A broader matching method that is useful when you do not know the full text exactly. |
| Cell matching | A setting that matches the full cell content instead of only part of the text inside a cell. |