Advanced Find & Replace for Microsoft Excel

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

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

Advanced Find and Replace can help you

You can view the video in the fullscreen mode by clicking

Advanced Find and Replace for Excel screenshots

Replace found values in all workbooks at the same time

Export search results to a new workbook

Select all found values in Excel

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, 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.0
published on: Jan 15, 2013

This add-in comes as part of Ultimate Suite (20+ useful Excel tools)

Try Advanced Find & Replace for Excel in the package without any limitations for 30 days.
You can order the add-in separately or buy it in the Suite at the best price.