How to Use WPS Find on macOS

Use WPS Find on macOS across 3 how-to topics, including finding content, replacing content, and locating specific cell types; choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. Find content

Feature entry: Home tab → Data Processing drop-down menu → Find drop-down menu → Find

1. Click the Data Processing drop-down menu on the Home tab.
2. Click the Find drop-down menu.
3. Select Find.
4. Enter the content you want to search for in the dialog box.
5. If you need more conditions, click Options to expand advanced settings.
6. Set the scope, search direction, look-in range, match case, and full-cell matching as needed.
7. Click Find All, Previous, or Next to run the search.

Success Criteria

• Interface result: The Find dialog opens and shows matching results.
• Next action available: You can move to the previous result, the next result, or review all results.

Tips While Using

• Common mistake: If Match case or full-cell matching is enabled, fewer results may appear.
• Environment note: This feature works in an open spreadsheet file.

2. Replace content

Feature entry: Home tab → Data Processing drop-down menu → Find drop-down menu → Replace

1. Click the Data Processing drop-down menu on the Home tab.
2. Click the Find drop-down menu.
3. Select Replace to open the Replace dialog box.
4. Enter the original text in Find what.
5. Enter the new text in Replace with.
6. Click Replace to update one match at a time, or click Replace All for batch changes.

Success Criteria

• Interface result: The Replace dialog opens normally and shows the replacement result.
• Next action available: You can continue replacing the next match or finish a batch replacement.

Tips While Using

• Common mistake: Before using Replace All, confirm that the search text is accurate.
• Environment note: Replacing content changes the current spreadsheet directly.

3. Locate specific cell types

Feature entry: Home tab → Data Processing drop-down menu → Find drop-down menu → Go To

1. Click the Data Processing drop-down menu on the Home tab.
2. Click the Find drop-down menu.
3. Select Go To to open the Go To dialog box.
4. Choose a target type such as data, constants, formulas, comments, blanks, or errors.
5. Click Go To.

Success Criteria

• Interface result: Matching cells are selected or the view jumps to the target area.
• Next action available: You can continue editing, checking, or formatting the selected area.

Tips While Using

• Common mistake: Choosing the wrong target type can produce unexpected results.
• Environment note: Results depend on the actual data types in the current worksheet.