Function Problems

How to Fix Excel Ctrl+F Cannot Find Visible Values

John WilsonJohn Wilson Nov 2, 2026 870 views

Question details

The user is unable to find specific visible numbers or text in a worksheet using the Ctrl+F Find function.

How to Fix Excel Ctrl+F Cannot Find Visible Values
Product
Excel
Device & OS
not provided
Scenario
Searching for specific data points or calculation results displayed on a spreadsheet.
Observed behavior
Excel reports that the data cannot be found, despite the search restrictions, preview settings, and Fn key being normal and the value being visibly present on the sheet.
Before you start

Ensure there are no leading or trailing spaces hidden within the cells you are searching for, and clear any formatting rules applied in the Find dialog box.

Solution 1Recommended

Change the 'Look in' Setting to Values

Adjust the Find and Replace options to force Excel to search the displayed results rather than the underlying cell formulas.

By default, Excel searches within the underlying formulas of a cell. If a cell displays '50' as a result of the formula '=25+25', searching for '50' while the search is set to 'Formulas' will return zero results. Switching the setting to 'Values' resolves this.

1
Open Find and Replace

Press the Ctrl+F shortcut on your keyboard to open the Find and Replace dialog box in Excel.

2
Expand search options

Click the 'Options >>' button located at the bottom right of the dialog box to reveal advanced search settings.

3
Modify the Look in setting

Locate the 'Look in:' drop-down menu and change the selection from 'Formulas' to 'Values'.

4
Perform the search

Enter your target visible text or number in the 'Find what:' field and click 'Find Next' to successfully locate the data.

Change the 'Look in' Setting to Values
Search Scope: This setting change will apply to your current Excel session, allowing you to continue searching for calculated values across your worksheets seamlessly.
WPS Spreadsheet Solution

Effortlessly Search Formulas and Values in WPS Spreadsheet

WPS Spreadsheet features a highly intuitive Find and Replace tool that makes searching through complex datasets, formulas, and values seamless.

  1. 1. Open your file in WPS: Launch WPS Spreadsheet and open your workbook.
  2. 2. Access the Find tool: Press Ctrl+F or navigate to the Home tab and click on Find and Replace.
  3. 3. Reveal Options: Click the Options button within the Find dialog box.
  4. 4. Select Values: In the 'Look in' dropdown menu, select 'Values' to find data exactly as it is displayed on your screen.
Easily toggle between searching values, formulas, or comments100% compatible with Microsoft Excel (.xlsx and .xls) formatsLightweight program with a familiar, user-friendly interfaceAdvanced filtering and conditional formatting tools built-in
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel 'Find' ignore certain cells?

Excel may ignore cells if 'Match entire cell contents' or 'Match case' is checked in the Find options. Additionally, hidden rows or columns are skipped during searches unless specified otherwise.

Can I set 'Values' as the default search option in Excel permanently?

Excel remembers your 'Look in' preference during your active session. However, once you completely close and reopen the application, it reverts to 'Formulas' by default.

How do I clear formatting from my Find search?

In the Find and Replace dialog, click Options. If the 'Format...' button has a preview next to it, click the drop-down arrow next to 'Format...' and select 'Clear Find Format'.

How can I search my entire workbook instead of just one sheet?

Open the Find options by pressing Ctrl+F and clicking 'Options'. Change the 'Within' dropdown menu from 'Sheet' to 'Workbook' to expand your search to all tabs.