How to Use WPS Find and Replace on iOS

Use WPS Find and Replace on iOS through 5 practical topics in the spreadsheet editor, with 5 available without membership and 0 membership-related items.

How-to Index

How-to Guide

1. Find content from the top menu

Entry path: Top-right menu → Find and Replace → Find

1. Open the spreadsheet file that you want to edit.
2. Tap the top-right menu icon.
3. Tap Find and Replace.
4. Select the Find tab.
5. Enter the keyword that you want to search for.
6. Tap Search to view matching cells.
7. Choose Exact Find or Fuzzy Find as needed.

Success Criteria

• Interface result: Matching cells for the keyword appear in the sheet.
• Next action available: You can continue browsing results or return to editing.

Tips While Using

• Common mistake: A misspelled keyword may return no results.
• Environment note: The file must open normally before you can search it.

2. Replace content from the top menu

Entry path: Top-right menu → Find and Replace → Replace

1. Open the spreadsheet and tap the top-right menu icon.
2. Tap Find and Replace.
3. Select the Replace tab.
4. Enter the text to find and the replacement text.
5. Tap Replace at the bottom to replace the current match.
6. Tap Replace All if you want to update all matches at once.

Success Criteria

• Interface result: Matching content is updated with the new text.
• Next action available: You can continue replacing items or save the file.

Tips While Using

• Common mistake: Before using Replace All, confirm that the search condition is correct.
• Environment note: A read-only file may not allow replacement changes.

3. Find content from the bottom tools area

Entry path: Bottom Tools → View → Find and Replace → Find

1. Open the spreadsheet file.
2. Tap Tools at the bottom.
3. Open the View tab.
4. Tap Find and Replace.
5. Select the Find tab.
6. Enter the keyword that you want to search for.
7. Tap Search to view matching results.

Success Criteria

• Interface result: WPS moves to matching cell content in the sheet.
• Next action available: You can continue reviewing results or switch to the Replace tab.

Tips While Using

• Common mistake: If you are in the wrong tab, the Find entry may be harder to spot.

4. Replace content from the bottom tools area

Entry path: Bottom Tools → Find and Replace → Replace

1. Tap Tools at the bottom.
2. Tap Find and Replace.
3. Select the Replace tab.
4. Enter the text to find and the replacement text.
5. Tap Replace to update the current match.
6. Or tap Replace All to update every matching result.

Success Criteria

• Interface result: The current match or all matches are replaced.
• Next action available: You can return to the sheet, continue editing, or save the file.

Tips While Using

• Common mistake: Check the replacement text carefully before running a batch replacement.

5. Adjust find and replace settings

Entry path: Find and Replace screen → top-left settings icon

1. Open the Find and Replace screen.
2. Tap the settings icon in the top-left corner.
3. Set the search scope to the current worksheet or all worksheets as needed.
4. Turn Fuzzy Find on or off as needed.
5. Turn the option for formulas and comments on or off as needed.
6. Turn Case Sensitive on or off as needed.
7. Turn Match Cell on or off as needed.

Success Criteria

• Interface result: The setting status is updated and applied to later searches or replacements.
• Next action available: You can return to Find or Replace and run the search immediately.

Tips While Using

• Common mistake: Too many filters can reduce the result set or return no matches.