Forum Discussion
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...
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).
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.
If you don't have an answer, then don't waste the time of people searching for solutions.
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...
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.
