WPS Find and Replace on iOS FAQ

Common questions about WPS Find and Replace on iOS usually involve missing results, replacement scope, and search settings; this FAQ includes 4 practical answers.

FAQ

Why are there no search results?

1. Check whether the keyword is entered correctly.
2. Confirm whether options such as Case Sensitive or Match Cell are limiting the search.
3. Turn off overly strict filters if needed, then search again.
4. If the content may be in another worksheet, change the scope to all worksheets.

Can I replace only the current match?

1. Open the Replace tab.
2. Enter the text to find and the replacement text.
3. Tap Replace to update only the current match.
4. Use Replace All only when you want to update every result.

How do I search within formulas or comments?

1. Open the Find and Replace screen.
2. Tap the settings icon to open search settings.
3. Turn on the option for formulas and comments.
4. Return to the Find screen, enter the keyword again, and run the search.

What should I check before using Replace All?

1. Confirm that both the find text and replacement text are correct.
2. Set the search scope carefully so you do not affect worksheets that should stay unchanged.
3. If the spreadsheet is important, save a copy before running a batch replacement.
4. Review a few results afterward to confirm that the replacement worked as expected.

Glossary