Advanced Find & Replace for Microsoft Excel 2013-2003

Simultaneously search and replace in Excel formulas, values, hyperlinks and comments

Advanced Find and Replace for Excel makes searching across multiple spreadsheets and workbooks easy, fast and comfortable. From now on you won't have to click Excel's "Find Next" time and again.

  • Find and Replace in all or selected workbooks & worksheets
  • Simultaneously search in values, formulas, hyperlinks and comments
  • Easily navigate in search results
  • Export results to a new Excel worksheet or workbook

Complete support for:

Search in all open workbooks and worksheets with Andvanced Find & Replace

Advanced Find and Replace benefits

In addition to all the features of Microsoft Excel's built-in Find, with the Advanced Find and Replace add-in you also get a set of tools for quick work with bulky worksheets.

Search in All or selected workbooks and worksheets.

Advanced Find and Replace displays all open Microsoft Excel workbooks and their spreadsheets in a tree making it very convenient to choose the worksheets to search.

You can search across all open workbooks, in selected spreadsheets only, or in the currently selected range.

Search in values, formulas, hyperlinks and comments

If the data you are looking for spread to comments, formulas and links, Advanced Find and Replace can still find them. You can simultaneously search for values, formulas, hyperlinks and comments in Microsoft Excel spreadsheets.

You see ALL results at a glance

Replace found values in all workbooks at the same time

If you have ever searched in Acrobat Reader, you certainly appreciated their comfortable manner of representing search results. With Advanced Find & Replace you will get exactly the same. The add-in displays all found items in a neat pane to the left of your Microsoft Excel workbook. It looks and behaves like a native part of Excel and will never impede your work by overlapping some of your data like the standard Excel Find dialog does.

You no longer need to seek where exactly the search dialog has moved after you clicked "Find Next" in Excel. Or if you prefer to search using "Find all", you needn't drag the standard form with the found results back and forth to see the entries it overlays.

You can easily set the width of Advanced Find & Replace's pane to make it most comfortable for your work. Just place the cursor on the right border of the pane (the cursor takes the look of "horizontal resize"), left click the mouse, and drag the border to any position you like. If you don't need the add-in, just close or minimize its pane.

Easy navigation in search results

When you highlight an entry in the search results, the add-in navigates to its original location and selects it in your worksheet. You immediately see where exactly the found data are located.

Replace all or selected search results

Once you see the found values, comments, hyperlinks and formulas, you can select only those items that you want to replace, all other entries will remain unchanged. Simply click Replace all to substitute new values for the found results at once.

Export found items to a new workbook

You can export found data to a new workbook for further analysis. Besides exporting all found entries, there are several enhanced options you can choose from:

  • Export rows or columns with found values
  • Export highlighted entries, i.e. items that you selected within search results
  • Export rows or columns containing highlighted entries
29.95
Buy now

Advanced Find and Replace can help you

You can view the video in the fullscreen mode by clicking fullscreen icon

I love it!

I use the Excel Search almost daily, and I love it. Moritz Farbstein

Great tool for writers and students.

As a translator, I usually juggle 5-15 versions of the same document, and Advanced Find and Replace has been a boon and serious time saver Contrary to CNet's gripes, the interface is simple and straightforward -- how complex does a Find/Replace app need to be? Pricey for a one-hit wonder, but it does the job extremely well and accurately. Permalink to this post

Best Program Ever.

This program was the best program ever to come to find and replace if you want to find and replace series of words in front page in seconds DOWNLOAD THIS!!! and it is worth to buy!! Permalink to this post

Advanced Find and Replace for Excel screenshots

Replace found values in all workbooks at the same time

Replace found values in all workbooks at the same time

Export search results to a new workbook

Replace, select or export the found items

Select all found values in Excel

Select all found values in Excel

Free Download
Free 15-day trial version, 7/14/2014

Advanced Find & Replace for Excel system requirements:

Operating System

  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Vista (32- and 64-bit)
  • Windows XP (32-bit)
  • Windows Server 2003, 2008, 2012
  • .NET Framework 2.0 must be installed.

If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment

Microsoft Excel

  • Microsoft Excel 2013 (32- and 64-bit)
  • Microsoft Excel 2010 (32- and 64-bit)
  • Microsoft Excel 2007
  • Microsoft Excel 2003

Advanced Find & Replace version

Current add-in version: 5.4.1
published on: Jul 14, 2014

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.