Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Downloads > Flexfind

Flexfind: Search and replace made easy

For Microsoft® Excel®

Is free of charge and works in Excel 2003, 2007, 2010, 2013 and 2016.

if you really like it:

Excel 2007-2016

Flexfind2007  v5.3, build 595 (1 Oct 2018, Downloaded: 33,257 times)

This is the 2007, 2010, 2013 and 2016 version, cannot be used with older versions. See below for more information on the tool.

Excel 2003

Flexfind  v5.3, build 588 (27 Oct 2015, Downloaded: 48,350 times) See Screenshot

Flexfind eases searching throughout an entire workbook. Enter a string to search for and get a list of all found locations. Click on an entry to go there. Select workbook, sheet or range searching. Replace with another string in the found items you select. At your wish, get a confirmation for each occurrence found (also within one cell). MAC enabled (thanks to Matthew Henson). Ever needed to replace a company name in the title of 25 charts? Or replace just the third occurrence of a cell address in some cells' formulas? Or change a part of the printheader of 6 sheets? Now there is Flexfind, which enables Search and Replace in all these items and more!!!

Recent Changes

5.3 Build 595:

Fixed 2016 and 2013 Workbook Window selection problems.

Mac version

Alas, this version will not work on a mac. For Mac users, Flexfind 5.1 (Downloaded: 7,102 times) is still available.

Instructions: Download the zip file by clicking the link above that says "". Unpack the files in the zip file to a folder of your liking and open the file called "Setup Flexfind.xls". Press the button in that file to install.

Click here to request support or issue comments or suggestions on this product.


Showing last 8 comments of 260 in total (Show All Comments):


Comment by: Wouter Mense (8/22/2017 4:13:57 PM)

Well, yes, it can be done with Name Manager, which is what I'm doing now, but only by manually editing the names one by one. Unless I'm overlooking something obvious? There is the Find&Replace in RefersTo button (requires FastExcel, unlike FlexFind?), but nothing similar for the names themselves.


Comment by: Jan Karel Pieterse (8/22/2017 4:35:50 PM)

Hi Wouter,

There is some sample code in the manual to do a mass-rename of names using Name Manager...


Comment by: Wouter Mense (8/23/2017 10:22:46 AM)

Hi Jan,

Thank you! This will save me some time going forward. Of course I could have read the manual first but after using the addin for so long I guess I got cocky :) In the meanwhile I've done all the renaming manually but since it's a recurring workflow I'll just plug that code somewhere in my personal worksheet for later use. Thanks again for your help :D


Comment by: april lafferty (2/10/2018 4:26:58 PM)


I tried to install but got an error so I followed your directions to manually install. When I used the tools/addins, I got the following error.

Run time error '-2147467259 (80004005)

Method 'Position' of object 'CommandBar' failed.

I downloaded the flex find 5.1 for Mac. I am running MacOS High Sierra 10.13.1. Excel 365.

Thanks for your help.



Comment by: Jan Karel Pieterse (2/12/2018 10:17:46 AM)

Hi April,

I apologize for the inconvenience. I don't own a MAC so I am not in the position to troubleshoot the problem!


Comment by: Daniel (2/23/2018 2:28:24 AM)

I came here trying to find a tool that could find&replace within the header&footer, but it seems I can't get it to work.

Am I doing something wrong or is it a limitation of the add-in itself?

Thank you in advance


Comment by: Jan Karel Pieterse (2/23/2018 11:28:26 AM)

Hi Daniel,

Flexfind should work. But you must check the "Objects" checkbox on its dialog before starting the search.


Comment by: H Pomroy (10/3/2018 9:09:05 PM)

Just wanted to say thank you! This is SO useful, it will save me hours of work.


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here:

Please enter your name (required):

Your e-mail address (optional, will only be used to inform you when your comment is published or to respond to your question directly):

Your request or comment (max 2000 characters):

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

I give permission to process this data and display my name and my comment on this website accoring to our Privacy Policy.

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.