Advanced Find and Replace for Google Sheets

Search within notes, formulas, values, and links at the same time

This add-on provides all you need for advanced search. Google spreadsheet can have your value in formulas, notes, and links on different sheets, and this tool will show you the entire list of matches. A click on any result will bring you to the necessary cell in an instant. Besides being able to export the found records, you can replace all or only the selected values. Learn how to work with the add-on.

  • Find and replace in a single column or any selected sheets
  • See the full list of found entries right in the sidebar
  • Export rows with the values you're looking for
Search within notes, formulas, links, and values

Search everywhere

See all found values listed in the sidebar

Advanced options in this add-on provide a thorough scan across the entire spreadsheet. Enter the search query and pick other criteria, e.g. you can consider case, data type, and retrieve the cells that contain only the exact entry.

Search and replace within a column or the entire sheet: you can choose where to look for your record. The add-on will get the most precise results by picking all relevant items.

Advanced replacement

Replace any selected records

Forget about switching to each found value one after another. You will see all matching records listed with the cell address and data type. Simply click on the record in the list to select it in your sheet. It may also be helpful to bring the search results to a separate sheet, you can export them with any adjacent data.

Need to find and replace text within a formula? Select it and click the Replace button. You can select several entries by holding the Ctrl button on your keyboard, for example this way you can find and replace in one column. Replacing all search results is as easy as a click.

Advanced Find and Replace for Google Sheets: video how-to

Advanced Find and Replace screenshots

Search within notes, formulas, links, and values
See all found values listed in the sidebar
Replace any selected records
Export search results with adjacent information

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our forum
 

Please remember that we work from 8am to 4pm GMT, this is 4:00am to 12:00pm EST,
1:00am to 9:00am PST, and our public holidays may differ from yours.

50+ professional tools for Excel to do your daily work
 
 
50+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard