How to Use WPS Find on Windows

Use WPS Find with 3 how-to topics, including finding content, replacing content, and going to cells by condition; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Find content

Entry: Home tab → Find drop-down menu → Find

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

Success Criteria

• Interface result: The Find dialog box opens and matching results are shown.
• What you can do next: You can continue reviewing matches or adjust the search conditions.

Tips While Using

• Common mistake: If Match case or entire-cell matching is enabled, fewer results may appear.
• Environment note: If the current worksheet or workbook does not contain the target content, no match will be returned.

2. Replace content

Entry: Home tab → Find drop-down menu → Replace

1. Click the Find drop-down menu on the Home tab.
2. Select Replace to open the Replace dialog box.
3. Enter the original text in Find what.
4. Enter the new text in Replace with.
5. Click Replace to confirm changes one by one, or click Replace All to update all matches.

Success Criteria

• Interface result: The matched cell content is updated to the new text.
• What you can do next: You can continue replacing the next match or enter a new replacement condition.

Tips While Using

• Common mistake: Before using Replace All, confirm that the search condition is correct.
• Environment note: If the search scope is broad, batch replacement may affect matches across multiple worksheets.

3. Go to cells

Entry: Home tab → Find drop-down menu → Go To

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

Success Criteria

• Interface result: Cells that match the selected condition are highlighted or selected.
• What you can do next: You can review, edit, or format the selected range directly.

Tips While Using

• Common mistake: If the selected condition is not accurate, the result may differ from what you expect.
• Environment note: The result depends on the actual data types and content in the current worksheet.