Google-sheets – way to highlight specific words in search results

google sheetshighlightsearch

Is there a way to highlight particular words in cells that I enter into the search window? Sometimes, working with a huge text we need to find only several words among long text and we have to read through all cell content to find it manually because the search option only highlights an entire cell where a searched word is located.

Is there a method to make Google Sheets highlight not an entire cell but specific words in search results or is it technically impossible?

Best Answer

Google Sheets do NOT highlight specific words in text.
Google sheets ONLY show the cells where your search terms are included

After finding the right sheet, use your browser's search feature.

Please pay attention on the counted results.
Google Sheets function ONLY shows found cells (including the search terms)

This is what you see in Google Chrome:

Chrome search

...and this when using Firefox:

enter image description here

Related Topic