up vote 1 down vote favorite
share [g+] share [fb]

I use comments allot in Excel and I need to search for a particular text that is in both values and comments. Is there a way to configure the Find and Replace in Excel to look by default in these fields?

link|improve this question
100% accept rate
feedback

1 Answer

up vote 1 down vote accepted

You can try 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 Microsoft Excel" enhances Excel's built-in Find and gives you:

  • Find and Replace in all opened Excel workbooks & worksheets - Advanced Find & Replace for Excel
  • Simultaneous search in values, formulas, hyperlinks and comments.
  • Search in all opened or selected workbooks and worksheets.
  • All search results displayed in a tree-view.
  • Easy navigation in search results.
  • Replacing in all or selected found items.
  • Exporting found instances to a new workbook.
  • Show / hide the add-in easily (standard Ctrl+F shortcut).
  • Support of Microsoft Excel 2007.

Before the search starts, you define the search region by selecting workbooks, worksheets, comments, hyperlinks, formulas or/and values.

Download the 15-days fully-functional trial version (3 MB)

link|improve this answer
2  
Thanks, but like 99.9% of superuser.com users I was hoping for a free solution. – Nicu Zecheru Mar 1 '10 at 14:01
You need to find/develop a macro for that. Good luck. – Mehper C. Palavuzlar Mar 1 '10 at 14:34
Since no other answers were posted I'll accept your answer, thanks! – Nicu Zecheru Mar 16 '10 at 10:15
You're welcome. – Mehper C. Palavuzlar Mar 16 '10 at 13:07
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.