Use search without replacement when you only need to locate a value. A Find and replace dialog can be used safely for finding, provided you do not activate its replacement controls.
Start with the intended file
Confirm the spreadsheet and account, then search for a distinctive value or ID. On a computer, use the file’s find shortcut or Edit > Find and replace for more detailed controls.
Choose the appropriate sheet or range scope where available. A match in a hidden or unrelated area may not be the record you intended to inspect.
Use platform-specific search controls
On Android and iOS, Google’s Sheets instructions use the More menu’s Find and replace command. Enter the search text and navigate with the result arrows. Leave Replace with and Replace all unused.
On desktop, review options such as Match case, Match entire cell contents, regular expressions, and searching within formulas. A literal wildcard-like character has different meaning if regular-expression mode is enabled.
Verify the record rather than just the match
Inspect neighboring fields and the exact ID to distinguish similar names or repeated values. Search results do not establish that a record is unique or current.
If nothing appears, check scope, spelling, invisible whitespace, and whether the desired text is a displayed result or part of a formula. Do not change source data merely to make the search find it. Keep the operation read-only when investigating a restricted file; requesting Editor access is unnecessary solely to locate information that your existing viewing role permits you to read. Close the dialog after confirming the intended record.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.