This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
In my Excel, when I search for a word, say, the cell that pops up with the search result simply highlights the cell. My friend also has I get it, but when he's still searching, the result appears in front of a column and row highlighted in color. I wish it would be the same for me, but I don't know how to do it. I'd appreciate help. I've attached pictures.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This is new feature called focus cell which can be found View>Show>Focus cell.
Could you share the Excel version of him and yours?
File>Account
Here is my Excel version which has "Show Auto-Highlight"
Thank you very much.
I noticed that my friend only creates the highlighting when he searches. I searched in the settings and noticed that I was missing a setting that he had. Show Auto-Higjlights.
Is there a way for it to appear for me too...?
I would like the highlighting to appear only when searching in Excel.
Thanks in advance for the answers that help me.
Thank you very much, but my problem is different.
The search result that comes out for me appears with the cell itself highlighted.
For my friend, the search result for him is displayed with the rest of the column and row highlighted in color.
How do I make it so that it will be the same for me...?
Could you share a screenshot of his?
When the search pane cover the cell range you want to search and then click the that cell. The search pane will auto move to front of that cell.
If the search pane doesn't cover the cell range, it will keep the location.