Feature Summary

The Find and Replace feature is used to quickly locate cells containing specified content in a worksheet. It supports exact match, fuzzy match, and advanced search options, and can replace specified content.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction
Find Shortcut Command+F
Replace Shortcut Command+H
Go To Shortcut Command+G

Steps

Find

Feature Entry
"Home" tab → "Data Processing" dropdown menu → "Find" dropdown menu → "Find" button

  1. Click the Data Processing dropdown menu in the Home tab
  2. Click the Find dropdown menu
  3. Select the "Find" button
  4. Perform a search in the pop-up dialog box
  5. You can click Options to expand advanced find settings
  6. Configurable settings:
  • Within: Sheet/Workbook
  • Search: By Rows/By Columns
  • Look in: Formulas/Values/Comments
  • Match case: Whether to match case
  • Match entire cell contents: Whether to match exactly
  1. Click the Find All button, Find Previous button, or Find Next button to search

image

Replace

Feature Entry
"Home" tab → "Data Processing" dropdown menu → "Find" dropdown menu → "Replace" button

  1. Click the Data Processing dropdown menu in the Home tab
  2. Click the Find dropdown menu
  3. Select the "Replace" button to open the Replace dialog box
  4. Enter the original text you want to modify in the Find what input box
  5. Enter the target new text in the Replace with input box
  6. Click Replace to confirm one by one, or click Replace All to batch modify

image

Go To

Feature Entry
"Home" tab → "Data Processing" dropdown menu → "Find" dropdown menu → "Go To" button

  1. Click the Data Processing dropdown menu in the Home tab
  2. Click the Find dropdown menu
  3. Select the "Go To" button to open the Go To dialog box
  4. Select the target type in the Go To options: Data, Constants, Formulas, Comments, Blanks, Errors, etc.
  5. Click Go To

image

FAQ

Q1: What should I do if Find cannot locate the content?

  • Solution: Check if "Match case" or "Match entire cell contents" is checked, and try unchecking these options.

Q2: How do I find content within formulas?

  • Solution: Select "Formulas" in "Look in" to search for text within formulas.

Notes

  • Find supports wildcards (* and ?)
  • You can search within the entire workbook
  • Find results can be batch selected