Search in values, formulas, notes, hyperlinks in all sheets at once. Get the list with the found entries and replace them in a click.
Use this simple add-on for advanced search in your Google spreadsheet. Find and replace text within a formula, check links hidden behind the displayed text, search within notes, and look for values at the same time. You can search and replace within a column by selecting the necessary range of data, or scanning any selected sheets. The add-on will display the list of all found records organized by sheet and take you to any found cell in a click.
It's easy to use and it offers all you need to discover the necessary data:
- Look at values, formulas, notes, errors and links simultaneously
- Find and replace in a single column or search everywhere in the spreadsheet
- Get all matches listed in the sidebar, navigate to any entry in a click
- Replace all or only the selected records
- Export the found values or the entire rows that contain them
30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.
If you have any questions about the add-on, please post them here:
https://www.ablebits.com/docs/google-sheets-find-replace-values/
We'll be happy to assist!
Advanced Find & Replace is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
––––––––––
WHAT'S NEW:
Version 1.7
★ New features:
- New type to look in - Errors. Now you can perform search in errors.
Improved:
- UI; we increased space for the "Search in" area which is useful for the documents with numerous sheets.
- Minor UX improvements.
Fixed:
- The add-on didn't find links in the range.
- If you were looking for hyperlinks only, the add-on showed cells with formulas too.
Version 1.6:
- Improved UI
- Fixed export issue
- Minor bugs fixed
- We introduced yearly subscriptions, you can still enjoy a fully-functional trial version of the add-on for 30 days.