1

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?

Improve this question
1

2 Answers 2

Reset to default
1

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

Improve this answer
4
  • Google Sheets has it's own find tool.
    – Rubén - Volunteer Moderator - ♦
    Commented May 20, 2019 at 11:40
  • @Rubén Thank you for the comment. Still -as pointed out- "...the search option highlights an entire cell where a searched word is located". can it pinpoint and highlight the exact word within the contents of a cell? Am I missing something?
    – marikamitsos
    Commented May 20, 2019 at 11:57
  • I'm sorry for my unclear comment. Google Sheets has it's own find tool, that could overtaken the Ctrl+F keyboard shortcut depending on where is the focus set, by the other hand the not all web browsers will highlight all the searched word instances. Do you tried to use the web browser search feature? What browser do you used?
    – Rubén - Volunteer Moderator - ♦
    Commented May 20, 2019 at 15:04
  • 1
    @Rubén Thank you for commenting. You are correct about "...depending on where is the focus set". That is why I mentioned "...use your browser's search feature". Please use my updated answer.
    – marikamitsos
    Commented May 20, 2019 at 17:34
0
  • press CTRL + F
  • type your word to find the cell
  • select the cell
  • click into address bar
  • press CTRL + F
  • type the word to find the possition

0

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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