Office Settings & Configuration

How to Fix Excel Find Searching Row Numbers Instead of Cell Values

Bushra Parveen Oct 22, 2026 868 views

Question details

The user needs to correct the search behavior in Excel so that it locates specific cell values rather than returning row numbers.

How to Fix Excel Find Searching Row Numbers Instead of Cell Values

Product: Excel
Device & OS: not provided
Scenario: Using the Find tool (Ctrl + F) to locate a specific multi-digit number within an Excel worksheet.
Observed behavior: Excel returns row numbers or unexpected results instead of finding the specific six-digit number inside the cell values.

Before you start

Ensure you have the worksheet open and verify whether the numbers you are searching for are generated by a formula or typed directly as plain text, as this determines the correct search setting.

Solution 1Recommended

Adjust the 'Look in' Settings in the Find Dialog

Change the default search parameters from searching within formulas to searching within values to ensure exact cell matches.

By default, Excel often searches within 'Formulas'. If a cell contains a formula referencing a row number that matches your search query, Excel will return that cell as a result. Changing the setting to search within 'Values' forces Excel to look only at the final visible data in the cells.

Open the Find Dialog Box

Press the Ctrl + F keyboard shortcut, or navigate to the Home tab and click on 'Find & Select' > 'Find'.

Expand Advanced Options

In the Find and Replace window, click the 'Options >>' button in the bottom right corner to reveal advanced search settings.

Change 'Look in' to Values

Locate the 'Look in:' dropdown menu and change the selection from 'Formulas' to 'Values'.

Enable Exact Match (Optional)

If you want to prevent partial matches, check the box next to 'Match entire cell contents'.

Execute the Search

Type your target number in the 'Find what' box and click 'Find Next' or 'Find All' to locate the correct cell values.

Adjust the 'Look in' Settings in the Find Dialog

Search Scope Optimization: You can also change the 'Within' dropdown from 'Sheet' to 'Workbook' if you need to search for the value across all tabs in your Excel file.

WPS Office Spreadsheet

Easily Find and Replace Data with WPS Spreadsheet

WPS Office provides a highly compatible and intuitive Spreadsheet application that makes searching for specific values, formulas, or formats effortless and accurate without confusing default settings.

1. Open Your Document: Launch WPS Spreadsheet and open your existing Excel (.xlsx or .xls) file.
2. Launch Find and Replace: Press Ctrl + F to bring up the Find and Replace dialog box.
3. Configure Search Options: Click 'Options', then set the 'Look in' dropdown menu to 'Values'.
4. Locate Your Data: Enter your specific number in the search bar and click 'Find All' to display a clean list of accurate results.

Accurate 'Look in Values' search prevents unwanted row number matchesFully compatible with Microsoft Excel (.xlsx, .xls) formatsLightweight application with fast search speeds across massive datasetsFree to download and use with a familiar tabbed interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel search formulas instead of values by default?

Excel often defaults the 'Look in' option to 'Formulas' to help users locate specific calculations and cell references. However, this can inadvertently cause the Find tool to match row references inside a formula instead of the displayed output value.

How do I find exact matches only in my Excel worksheet?

Open the Find dialog (Ctrl + F), click on 'Options >>', and check the box labeled 'Match entire cell contents'. This ensures Excel only returns cells that exactly match your search query, ignoring cells where your number is just a part of a larger string.

Does changing the 'Look in' option apply to all future searches?

The settings in the Find and Replace dialog box are typically saved for the duration of your active Excel session. If you close and restart the application, the settings may revert to the default 'Look in: Formulas' behavior.

Office App Problems