How to Show All Search Results in Excel Instead of One Match
Question details
The user wants to view all instances of a searched term simultaneously in Excel rather than jumping from one individual result to the next.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Searching for a specific keyword or value across a large dataset to review or manage all occurrences at the same time.
- Observed behavior
- The default search bar, especially on the mobile app, only highlights or navigates to one matching cell at a time, hiding the broader context.
Ensure your spreadsheet application is updated to the latest version, as advanced search functionalities can be limited in older builds or certain mobile environments.
Filter the Target Column to Show All Matches
Applying a column filter is the fastest way to hide non-matching data and display only the rows containing your search term.
This method is highly effective on both desktop and mobile versions of Excel. By filtering the data, you consolidate all matching results onto your screen, making it easy to review, edit, or copy the entire dataset in bulk.
Click or tap the header of the column you want to search through.
Navigate to the 'Data' tab and click the 'Filter' icon (or tap the filter icon on the mobile menu).
Click the filter dropdown arrow on your selected column, type your search keyword into the search box, and apply the filter to display all matching rows.

Highlight Matches Using Conditional Formatting
Use conditional formatting to visually highlight all cells containing your target text across the entire worksheet.
Use the Desktop Find All Feature
Switching to Excel for the web or desktop provides access to the robust 'Find All' dialogue box.
Easily Find and Manage All Data with WPS Spreadsheet
WPS Spreadsheet provides robust, user-friendly search and filtering capabilities across all devices. Use the intuitive built-in Find All feature to instantly generate a comprehensive list of every matching cell without single-match limitations.
- 1. Open Your Spreadsheet: Launch WPS Spreadsheet and open your document.
- 2. Launch the Find Tool: Press Ctrl+F to bring up the Find and Replace dialogue.
- 3. Find All Matches: Enter your keyword and select 'Find All' to display a complete list of matching cells instantly.

Frequently Asked Questions
Why does the Excel mobile app only show one search result?
The mobile version of Excel is optimized for smaller screens and limited device memory, which scales down complex search displays to one result at a time. To bypass this, use the filtering method or switch to the desktop/web versions.
How do I search across an entire Excel workbook instead of just one sheet?
Open the Find and Replace dialog (Ctrl+F), click on 'Options' to expand the advanced settings, and change the 'Within' dropdown menu from 'Sheet' to 'Workbook'. Then, click 'Find All' to search across every tab.
Can I copy all my search results into a new worksheet?
Yes. The easiest way is to apply a filter to your data using your search term. Once the non-matching rows are hidden, highlight the visible rows, copy them (Ctrl+C), and paste them (Ctrl+V) into your new worksheet.
How do I select all matching cells at once using Find All?
After clicking 'Find All' in the desktop version, click on any single result inside the bottom list of the Find and Replace dialogue box, then press Ctrl+A. This will highlight all matching cells in your spreadsheet simultaneously.




