Advanced Find & Replace for Microsoft Excel 2016, 2013-2007

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

Free download 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
Buy now

Find and replace in multiple Excel workbooks

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
Freeware, 6 MB

Advanced Find & Replace for Excel system requirements:

Microsoft Excel

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

Operating System

  • Windows 10 (32- and 64-bit)
  • Windows 8 (32- and 64-bit)
  • Windows 7 (32- and 64-bit)
  • Windows Server 2008, 2012, 2016
  • .NET Framework 4.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

Advanced Find & Replace version

Current add-in version: 2018.1
published on: Nov 17, 2017

End-User License Agreement (EULA).

Featured customers featured customers
Contact us
  Publish your message on our support forum

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Sheila Blanchard
Excel add-ins and Outlook tools -