How to Use WPS Find and Replace on iOS

Use WPS Find and Replace on iOS with 5 how-to topics, including 5 free topics and 0 membership-related topics, and jump to each workflow from the index below.

How-to Index

How-to Guide

1. Find content from the top menu

Feature entry: Tap the top-right menu → Tap Find and Replace → Select the Find tab

1. Open the spreadsheet file 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 you want to search for.
6. Tap Search to find matching cells.
7. Choose exact or fuzzy search as needed.

Success Criteria

• Interface result: Matching results appear and the sheet moves to the related cell.
• Next action: You can continue to the next result or switch to Replace.

Tips While Using

• Common mistake: An incorrect keyword can return no results.
• Environment note: Open an editable spreadsheet file first.

2. Replace content from the top menu

Feature entry: Tap the top-right menu → Tap Find and Replace → Select the Replace tab

1. Open the spreadsheet file you want to edit.
2. Tap the top-right menu icon.
3. Tap Find and Replace.
4. Select the Replace tab.
5. Enter the text to find and the replacement text.
6. Tap Replace for one match or Replace All for batch replacement.

Success Criteria

• Interface result: Matching content is replaced with the new text.
• Next action: You can continue replacing more matches or return to the sheet to review the result.

Tips While Using

• Common mistake: Before using Replace All, confirm that the search text is accurate.

3. Find content from the bottom tools area

Feature entry: Tap Tools at the bottom → Open the related tool group → Tap Find and Replace → Select Find

1. Open the spreadsheet file.
2. Tap Tools at the bottom.
3. Open the related tool group.
4. Tap Find and Replace.
5. Select the Find tab.
6. Enter a keyword and tap Search.

Success Criteria

• Interface result: Matching results appear.
• Next action: You can continue browsing results or switch to Replace.

Tips While Using

• Common mistake: If you are not in the correct tool group, the entry may not appear immediately.

4. Replace content from the bottom tools area

Feature entry: Tap Tools at the bottom → Tap Find and Replace → Select the Replace tab

1. Open the spreadsheet file.
2. Tap Tools at the bottom.
3. Tap Find and Replace.
4. Select the Replace tab.
5. Enter the text to find and the replacement text.
6. Tap Replace or Replace All.

Success Criteria

• Interface result: The target content is replaced.
• Next action: You can continue working on other keywords.

Tips While Using

• Common mistake: Before batch replacement, review a sample result in the current sheet first.

5. Adjust find and replace settings

Feature entry: In the Find and Replace screen, tap the gear icon at the top left

1. Open the Find and Replace screen.
2. Tap the gear icon at the top left.
3. Set the search scope to the current worksheet or all worksheets as needed.
4. Turn fuzzy search on or off as needed.
5. Turn formula and comment search on or off as needed.
6. Turn case sensitivity on or off as needed.
7. Turn cell matching on or off as needed.

Success Criteria

• Interface result: The setting status updates successfully.
• Next action: Return to Find or Replace and run the search with the new conditions.

Tips While Using

• Common mistake: Too many restrictive conditions can reduce the number of matches.