Others

How to Show All Search Results in Excel Instead of One Match

Bushra ParveenBushra Parveen Nov 11, 2026 869 views

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.

How to Show All Search Results in Excel Instead of Just One Match
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.
Before you start

Ensure your spreadsheet application is updated to the latest version, as advanced search functionalities can be limited in older builds or certain mobile environments.

Solution 1Recommended

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.

1
Select the Column Header

Click or tap the header of the column you want to search through.

2
Enable the Filter Function

Navigate to the 'Data' tab and click the 'Filter' icon (or tap the filter icon on the mobile menu).

3
Enter the Search Term

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.

Filter the Target Column to Show All Matches
Easy Bulk Edits: Once filtered, any edits, copying, or formatting you apply will only affect the visible matching rows.
Powerful Spreadsheet Alternative

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. 1. Open Your Spreadsheet: Launch WPS Spreadsheet and open your document.
  2. 2. Launch the Find Tool: Press Ctrl+F to bring up the Find and Replace dialogue.
  3. 3. Find All Matches: Enter your keyword and select 'Find All' to display a complete list of matching cells instantly.
Advanced 'Find All' functionality to view all matching results in an easily navigable listIntuitive conditional formatting and data filtering tools optimized for both desktop and mobileFully compatible with Microsoft Excel formats (.xlsx, .xls) with zero formatting lossFree and lightweight alternative for seamless cross-platform spreadsheet management
microsoft office alternative - wps office

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.