Find and Replace in all opened Excel workbooks & worksheets

Advanced Find & Replace for Microsoft Excel

Search and replace in all opened Excel workbooks and worksheets. Simultaneous search in values, formulas, hyperlinks and comments.

Advanced Find & Replace for Excel is an add-in for Microsoft Excel 2010 (32-bit and 64-bit), Excel 2007, Excel 2003, Excel XP, and Excel 2000.

15-days fully-functional trial version

7.5 MB

Advanced Find & Replace for Excel in detail

Advanced Find & Replace for Microsoft Excel enhances Excel's built-in Find and provides you a number of useful features and advanced options such as:

Find & Replace for Excel

• Simultaneous search in values, formulas, hyperlinks and comments.
• Search in all open or selected workbooks and worksheets.
• All search results conveniently displayed in a tree.
• Easy navigation in search results.
• Replace all or selected items.
• Export found items to a new workbook.
• Open / close the add-in easily (standard Ctrl+F shortcut).
• Full support for Microsoft Excel 2010.

This Excel add-in reduces the number of clicks to one and the search time to a second and adds no new workbooks or VBA macros to your Excel.

3 easy steps to find and replace in Excel

1. Open the Find & Replace pane by pressing Ctrl+F hotkey. Before the search starts, you define the search region by selecting workbooks, worksheets, or a range in your current worksheet; and choose what kind of data you are looking for: comments, hyperlinks, formulas or values.
   
   
   

   Search options (click to enlarge - 144 KB)

   
   
   
   
   
2. Click the "Find All" button and have all found items shown in a tree-view list.
   
   

   Find & Replace for Excel - search results (click to enlarge - 153 KB)

   
   
   
   
   
3. Choose the action with search results
   • Select some or all found items.
   • Replace all or selected items.
   • Export all or selected search results to a new workbook.
   • Search in found items.
   
   
   

   Replace in the selected items only (click to enlarge - 146 KB)

   
   

Advanced Find & Replace for Microsoft Excel works with:

• Operating System: Microsoft Windows 7 (32-bit and 64-bit), Windows Vista (32-bit and 64-bit), Windows 2003, XP, 2000.
• Microsoft Excel 2010 (32-bit and 64-bit), Excel 2007, Excel 2003, Excel XP, and Excel 2000.

Download Advanced Find & Replace for Excel

• 15-days fully-functional trial version (7.5 MB)

See also in "Excel - Find / Select Excel data"

• Merge Tables Wizard for Microsoft Excel - Copy matching data from lookup Excel table to main one.
• Cells Assistant for Microsoft Excel - Select Excel spreadsheet cells with the same format by one click.