When using Find (ctrl-F) and the found cell is selected, highlight the found text in the cell
When using Find (ctrl-F) and the found cell is selected, highlight the found text in the cell. If the cell contains a lot of text, highlighting the searched for text will make review much faster
Thank you for voting for “when using Find (ctrl-F) and the found cell is selected, highlight the found text in the cell”. While this is a nice suggestion, we are not able to work on this soon. We’ll keep tracking the votes, though.
@Benjamin: You are commenting on the wrong issue. This is about marking the found text within a cell with a lot of text.
I think there is another one for making the found cell more visible.
Benjamin Rosenthal commented
Highlight all found cells with thick border ( allow user to select cell border thickness with colour )
Copy all found cells or 1st 10 or last 10.
Also whenever cells are found then allow :
Scroll to cell & select row & column of first found cell, so that it is clearly visible.
Continue this for find next.
Also for mouse on hover found cell, automatically zoom text of found cell when mouse cursor is over found cell
To not address this issue constitutes ageism and failure to compensate for disabilities.
This (unfortunately and annoyingly closed) issue was about finding text within a cell, i.e. a cell with a log of text and although you see the found cell, you still don't see where the text is.
Making the found cell more visible is something else. If I remember correctly there is another issue for that. You should try to find it and vote for it or if you can't find it submit your own.
THIS IS A HUGE ACCESSIBILITY ISSUE! I am partially blind, and I find it almost impossible to see where that slight green outline is, that is SUPPOSEDLY helping me find a word or number in my spreadsheets. It's RIDICULOUSLY subtle!
Why would Microsoft not make this a priority to help improve things for the visually impaired?!
Reply to Anonymous on October 10, 2019 09:22: I think you are misunderstanding this issue. The idea is to highlight the search text, so the text (and not just the cell) can be located in a large cell with a lot of text.
not a real fix, but works..
before trying to find something I press ctrl+A (when you select all the worksheet it becomes gray) and the crtl+F.. it will remove the shadow from the cell you were looking for making it easier to visually find it on your screen
hope it works for you..
this question/suggestion has been asked many times over the years; will it every be answered/enhanced??!!
Currently, I have to past the text in MS Word to find the word to see if it is being used in the appropriate context. This is taking a long time.
This would be very helpful. Also can highlight could take place when using the ISNUMCER(SEARCH) function: =IF(ISNUMBER(SEARCH("depress",K21)),1, 0)
It's highlighted in my version of Excel, but the highlighting is so weak as to be almost unnoticeable. I think this is an accessibility issue. The search highlighting needs some options.
I am desperate for the found cell to either be highlighted (i.e. border in red) or for searched text/number to be highlighted in anything other than white. I look up reference numbers and have many cells surrounding the found cell so I am straining my eyes to see which cell has actually been picked by CTR+F. Highlighting it in any way would be