How to Find and Replace in WPS on macOS

Use Find and Replace in WPS on macOS through 4 how-to topics, with 4 free topics and 0 membership-related topics; start from the How-to Index and jump to the steps you need.

How-to Index

How-to Guide

1. Use Find

Entry: Home tab → Find, or press Command + F.

1. Press Command + F, or click Find on the Home tab.
2. Enter the content you want to search for in the search box.
3. Click Find Next to jump to the matching cell.
4. Click Find All to view the full list of matches.

Success Criteria

• The view jumps to a cell that contains the matching content.
• When you use Find All, a list of matching results appears.

Tips While Using

• Broad keywords may return many matches.
• In a collaborative spreadsheet, confirm the current editing area before making changes.

2. Use Replace

Entry: Home tab → Find drop-down menu → Replace, or press Command + H.

1. Press Command + H, or open the Find drop-down menu on the Home tab and select Replace.
2. Enter the original content in the Find box.
3. Enter the new content in the Replace with box.
4. Click Replace to update one match, or click Replace All to update all matches.

Success Criteria

• The original content in the target cell changes to the new content.
• Replace All updates multiple matching cells in one action.

Tips While Using

• Before a batch replacement, run a search first to confirm the match scope.
• In a collaborative spreadsheet, replacements affect shared content, so confirm the replacement text before applying it.

3. Use Go To

Entry: Home tab → Find drop-down menu → Go To, or press Command + G.

1. Press Command + G, or open the Find drop-down menu on the Home tab and select Go To.
2. In the Go To panel, select the type of content or target you want to locate.
3. Confirm the selection to jump to the target area.

Success Criteria

• The view moves to the target area that matches the selected condition.
• You can continue editing or reviewing the selected cells.

Tips While Using

• Decide what kind of target you need before opening Go To to reduce repeated jumps.
• In smaller sheets, some Go To conditions may return no result.

4. Use Advanced Find Options

Entry: Find or Replace dialog box → Options.

1. Open the Find or Replace dialog box.
2. Click Options to expand advanced settings.
3. Set the search scope to Sheet or Workbook as needed.
4. Turn on options such as Match Case, Match Entire Cell, or search by rows or columns when needed.
5. If you need format-based search, click Format, set the condition, and run the search.

Success Criteria

• Search results are narrowed to a more accurate range based on the selected conditions.
• Format-based search can locate content that matches the specified formatting.

Tips While Using

• Different search scopes can change the number of results significantly.
• When using exact cell matching or format conditions, confirm that your search text and settings are complete.