Forum Discussion

Copper Contributor

Jan 09, 2019

Office 365 - Excel 2016: Find feature no longer highlights text

I am currently searching a very large file for keywords and there is only a slight outline of the row number and cell meeting my search criteria. Previously, the cell or word would be highlighted to...

excel

office 365

SergeiBaklan

Diamond Contributor

Jan 09, 2019

To my knowledge there is no such setting. However, after Find All you may select all found cells in bottom frame (with Shift + arrow down or by mouse) - all of them will be highlighted. In addition, after the selection and without closing Find windows you may apply any format to all selected cells (style, or background colour, whatever).

The_liner

Copper Contributor

Dec 02, 2022

What are you even talking about? He is clearly asking something specific, and you are saying "shift + arrow down". What that has to do with the question?

If you don't have an answer, then don't waste the time of people searching for solutions.

HansVogelaar
MVP
Dec 02, 2022
The_liner

SergeiBaklan pointed out that the Find All button in the Find/Replace dialog can be used to highlight and - if desired - format all cells where the text is found.

By the way, this discussion is almost four years old. It's not clear to me why you felt it necessary to insult the very helpful top poster in this forum here...
- charles_ross_oh
  Copper Contributor
  Apr 17, 2025
  Sergei offered a workaround hack, which is handy, but the basic question was not addressed. If you don't want to edit the document, replace is not gonna be your solution. Online Excel still appears to have the same behavior in 2025.