How to Fix Excel Ctrl+F Cannot Find Visible Values
Question details
The user is unable to find specific visible numbers or text in a worksheet using the Ctrl+F Find function.

- 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.
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.
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.
Press the Ctrl+F shortcut on your keyboard to open the Find and Replace dialog box in Excel.
Click the 'Options >>' button located at the bottom right of the dialog box to reveal advanced search settings.
Locate the 'Look in:' drop-down menu and change the selection from 'Formulas' to 'Values'.
Enter your target visible text or number in the 'Find what:' field and click 'Find Next' to successfully locate the data.

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. Open your file in WPS: Launch WPS Spreadsheet and open your workbook.
- 2. Access the Find tool: Press Ctrl+F or navigate to the Home tab and click on Find and Replace.
- 3. Reveal Options: Click the Options button within the Find dialog box.
- 4. Select Values: In the 'Look in' dropdown menu, select 'Values' to find data exactly as it is displayed on your screen.

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.




