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.
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
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
Export search results to a new workbook
Select all found values in Excel
Advanced Find & Replace for Excel system requirements:
- 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
- Microsoft Excel 2003
- Windows 10 (32- and 64-bit)
- 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 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: 6.0.6
published on: Nov 24, 2015
End-User License Agreement (EULA).