Find and Replace in all open Excel workbooks & worksheets

Simultaneous search in values, formulas, hyperlinks and comments

Task

You need to find and replace the company's domain name in 15 different Excel documents. The deadline was yesterday. So each minute counts. The standard Excel search tool fails to cope with the given task in a time-efficient way. Besides you need to search in comments and hyperlinks.

Solution

Advanced Find and Replace for Excel will search across all open Excel files, applying match options and looking for entries within values, hyperlinks, formulas, and comments. With this straightforward add-in you can instantly replace all found entries, export the results to a new Excel spreadsheet or select them in your table for further review.

Find and replace values in all opened workbooks and worksheets.

Advanced Find and Replace key features

  • Get full-text search in all or selected Excel workbooks and worksheets
  • Simultaneous search in values, formulas, hyperlinks and comments
  • See all found entries in a tree-view
  • Replace all or selected entries in MS Excel in a click
  • Customize your search requirements using the match options or wildcards
  • Export columns or rows with the found entries or all found records to a new workbook
  • Automatically select rows or columns with all values or those highlighted in the add-in's list
  • Easily access the add-in using hotkeys

Tip

You can get this add-in as a part of Ultimate Suite for Excel - 20+ add-ins destined to cut your time and clicks on the most frequent spreadsheet tasks.

How Advanced Find and Replace works

See all found entries in a tree-view and replace them in a click.
Automatically select rows or columns with the found entries.
Copy the found entries to a new Excel workbook.

Advanced Find and Replace is equipped with a powerful search-n-replace engine. With its help you can scan the data for values, formulas, hyperlinks or comments. This Excel add-in will look for any occurrence of a given item in all open or selected workbooks and worksheets. In addition, you can easily expand or narrow the search by using the match options or wildcards.

The found results are displayed in a tree-view so that you can see all found entries. Then you choose whether to swap all or selected entries and click the Replace button. The plug-in will substitute the data in the corresponding cells in a snap freeing you from typing the same thing again and again.

By clicking the Export button you can quickly transfer found entries to a separate workbook for further analysis. Use the Select button to highlight the found entries in your worksheet, or select entire rows and columns containing them.

Full-text search in Excel workbooks and worksheets

This Excel add-in gives you an enhanced search engine to look in all entries within your workbooks and worksheets. Not a single entry is skipped or left unprocessed. Click to Find all occurrences of a given entry in all or selected spreadsheets.

Simultaneous search in values, formulas, hyperlinks and comments

You can look for an entry in values, formulas, hyperlinks, and comments through all or selected Excel spreadsheets at the same time.

See all found entries in a tree-view and replace them in a click

All the results are displayed on the add-in pane. So you just need to verify the found entries and click Replace without incessant switching between workbooks and worksheets back and forth.

Export the found entries to a new workbook

In addition to searching and replacing, the tool lets you export the search results to a new Excel spreadsheet. It is possible to get rows or columns with all or selected entries in a separate file. Or you can simply press the Export all button on the pane and the search results will appear on another workbook for you to take a closer look at them.


Customize your search requirements using the match option or wildcards

With the match options you can tweak the search criteria to include only those entries that meet your requirements. Apply the Match case option to distinguish between uppercase and lowercase characters. Or choose Entire cell to look for the complete match.

If there are likely to be items containing typos or mistakes, take the advantage of wildcard characters. These are special symbols that stand for one or more characters, which may be useful for finding records with similar, but not exactly the same, data. Or they may be helpful when you can't remember enough information to retrieve some text value.

Automatically select rows or columns with all or highlighted values

If you think that it could be useful to pinpoint and show the found items in your table, choose the option to select entire rows or columns with the results. Also, you can narrow the view down to the entries you highlighted on the pane.

Easily access the add-in using hotkeys

The add-in's pane is opened by the standard Ctrl+F shortcut. It is also possible either to change the selection to Ctrl+Alt+F or choose None if you want to disable the shortcut keys.

29.95
Buy now

Advanced Find & Replace for Microsoft 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 must be installed.

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 for Excel version

Current add-in version: 5.0
published on: Jan 15, 2013

Order Advanced Find & Replace for Excel

29.95
Buy now
 
Contact us