Advanced Find and Replace in Excel

Search and replace in all or selected workbooks and worksheets

Advanced Find and Replace for Excel makes it easy to search across multiple spreadsheets and workbooks, select or replace all found values in a click. It can simultaneously search in values, formulas, hyperlinks, and comments with case-sensitive, case-insensitive or exact match. Besides, it can check your worksheets for typos.

Learn more
This tool is part of
Ultimate Suite
Advanced Find and Replace for Excel 2016 - 2007

With Advanced Find and Replace in Excel you will

  • Search in multiple workbooks at once Find and replace in all open files or only in selected workbooks and worksheets.
  • Search in all or specific data type You can search in values, formulas, hyperlinks and comments simultaneously or only within certain data types.
  • Find exact matches If partial match is not good enough for your needs, pinpoint your search to match the entire cell contents.
  • Perform case-sensitive search If lowercase and uppercase characters make a difference, tick off the Match case check box.
  • Replace all or selected search results Replace directly in search results. Select all or some of the found items and click Replace all.
  • Search in active sheet or selected cells If necessary, narrow down your search to the current worksheet or selected range.
  • Export found items to a new workbook Choose from five exporting options: all found entries, rows or columns with found values, and more.
  • Find and fix typos Optimize the quality of your Excel content by eliminating all those embarrassing fuzzy matches and misprints.

How to find and replace in Excel

  
Find and replace in Excel by choosing one of 4 options
Find and replace in Excel by choosing one of 4 options
Search in multiple workbooks at once
Search in multiple workbooks at once
Replace in the selected search results
Replace in the selected search results
Search only in comments and only within the active sheet
Search only in comments and only within the active sheet
The specified value is found in comments
The specified value is found in comments
Search for exact matches: case-sensitive and match entire cell contents
Search for exact matches: case-sensitive and match entire cell contents
All the upper-case variants of the search value are found
All the upper-case variants of the search value are found
Search for typos and fuzzy matches
Search for typos and fuzzy matches
Find and replace in Excel by choosing one of 4 options
Search in multiple workbooks at once
Replace in the selected search results
Search only in comments and only within the active sheet
The specified value is found in comments
Search for exact matches: case-sensitive and match entire cell contents
All the upper-case variants of the search value are found
Search for typos and fuzzy matches

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Advanced Find and Replace for Excel

  • What is Advanced Find and Replace for Excel?

    This tool extends the capabilities of Excel's Find and Replace with a handful of useful features:

    • Find and replace in all open workbooks or only selected worksheets from different workbooks.
    • Search simultaneously in values, formulas, hyperlinks and comments.
    • Export found entries to a new workbook in a mouse-click.
    • And a lot more options.
  • How to search and replace in Excel with this utility?

    Open your worksheet and click the Find and Replace button on the Ablebits Tools tab. To search, replace, export, and select, do the following:

    1. Enter a character, word or string to search for.
    2. Select workbooks and sheets you want to look in. To search only in the active sheet or selection, check the corresponding option.
    3. Choose data type for your search: values, formulas, comments, hyperlinks, or all at once.
    4. To look for case-sensitive data, select the Match case option.
    5. To find the exact matches, tick off the Entire cell checkbox.
    6. Click Find all.

    You will see a list of all found entries. Now you can replace all or some of them with another value, export the entries to a new workbook, or select and highlight cells, rows, or columns.

    More information can be found here.

  • Can I search for text in comments?

    Yes, you can search for any characters in comments, just select a corresponding option. Moreover, you can choose to look in formulas and even hyperlinks. And values, of course.

  • I need to find and replace a certain value in several workbooks, is it possible?

    Sure! The simplest way is to open all workbooks to look in, and then start Advanced Find and Replace. By default, all worksheets in all open books will be selected.

  • Can the tool search only in certain worksheets from different workbooks?

    Yes. When you start the add-in, all sheets from all open workbooks are selected, but you can unselect the ones you don't need.

  • If the same text is both uppercase and lowercase, can I find only uppercase ones?

    Yes. To do a case-sensitive search, just tick off Match case.

  • Can I replace only part of the found values, not all of them?

    Sure. It is up to you whether to replace all found entries, or only some of them. You can choose the entries to replace on the add-in pane.

  • I need to find entire cell content matches only, is it possible?

    Yes. To find only exact matches, select the Entire cell option.

  • How can I export the found data?

    When search is finished, the found entries are displayed on the add-in pane, and you can export them to a new workbook. There are several advanced options for you to choose from:

    • Export rows or columns with found values.
    • Export highlighted entries, i.e. the items you selected within search results.
    • Export rows or columns containing highlighted entries.
  • Can I replace all the found entries in one click?

    Yes, just click the Replace all button.

  • Can I only select found items without replacing them?

    Of course. The Select cells button offers you five options:

    • Select rows with all found entries.
    • Select columns with all found entries.
    • Select the highlighted entries.
    • Select rows with the highlighted entries.
    • Select columns with the highlighted entries.
  • Can I find partial matches in my worksheet?

    Yes. For this, use the Search for Typos option. Choose the range, run the utility, enter the max number of different characters and the max number of characters in a word or cell. Click Search for typos button. You will see a list of all values that meet your search criteria. Then you can choose the correct values and replace the incorrect ones.

Supported versions

 

Excel

  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • Windows Vista
  • Windows XP
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.
Excel add-ins and Outlook tools - Ablebits.com