How to Use WPS Find and Replace on iOS

Last updated:July 20, 2026

Use Find and Replace in 3 how-to topics on iOS spreadsheets; all 3 are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Use Find and Replace in editing modeFree
22. Quickly find content in reading modeFree
33. Adjust Find and Replace settingsFree

How-to Guide

1. Use Find and Replace in editing mode

Entry: Open a spreadsheet in editing mode → tap Find and Replace at the bottom

  1. Open the spreadsheet and switch to editing mode.
  2. Tap Find and Replace at the bottom to open the search and replacement area at the top.
  3. Enter a keyword in the Find box to search matching data.
  4. If you want to replace content, enter the new text in the replacement box.
  5. Choose Replace or Replace All as needed.

Success Criteria

  • Interface result: The search and replacement area appears at the top and matching results are shown.
  • Next action available: You can continue to the next match, replace one result, or replace all results.

Tips While Using

  • Common mistake: Before using Replace All, confirm that the keyword is correct.
  • Environment note: Replacement affects content within the current search scope.

2. Quickly find content in reading mode

Entry: Open a spreadsheet in reading mode → tap Find at the lower right

  1. Open the spreadsheet and stay in reading mode.
  2. Tap Find at the lower right of the screen.
  3. Enter the keyword you want to search for.
  4. Review the results and jump to the matching location.

Success Criteria

  • Interface result: Search results appear and the matching content can be located.
  • Next action available: You can continue browsing matches or switch to editing mode to make changes.

Tips While Using

  • Common mistake: Reading mode is mainly for search. Switch to editing mode if you need to replace content.

3. Adjust Find and Replace settings

Entry: Open the Find and Replace page → tap Settings

  1. Open the Find and Replace page first.
  2. Tap Settings on the right to open the settings menu.
  3. Set the scope to the current worksheet or all worksheets in the document as needed.
  4. Choose search by row or search by column.
  5. Turn options on or off as needed, including formulas, case sensitivity, full-width and half-width characters, and cell matching.

Success Criteria

  • Interface result: The settings are updated for the current search task.
  • Next action available: After returning to the Find and Replace page, you can search or replace with the updated conditions.

Tips While Using

  • Common mistake: An incorrect scope can return too many results or miss the target content.
  • Environment note: Different settings directly affect matching results, so confirm them before using Replace All.