Description: During a search in a complex spreadsheet, it is difficult to visually detect the selected cell with the first result. Having the row and column highlighting automatically or 'intelligently' activated when searching and selecting a result speeds up the data review process. This would allow the selected cell with the search result to be highlighted without activating row and column highlighting. Steps to Reproduce: 1. Click on the View menú. 2. Click on Column/Row Highlighting. 3. Activate/Deactivate Row/Column Coloring. Actual Results: Activated: Column and row highlighting. Deactivated: Column and row not highlighting. Expected Results: 1. Click on the View menu. 2. Click on Column/Row Highlighting. 3. Activate the New Option Auto Highlighting (maybe in a submenu). 4. Find something. 5. The first cell with result is Highlighted. 6. Close the Find dialog. 7. The cell is not Highlighted. Reproducible: Always User Profile Reset: No Additional Info: In another menu within the submenu, the user will be able to select the color of the highlighting of their choice. They might be able to set colors that are easily visible or select the desired color from the preferred palette.
Created attachment 198910 [details] Tool in Excel 365 It can be seen that in the menu, you can activate and deactivate the highlighting, the color of the highlight, and there is an option 'Show Automatic Result' that allows highlighting the search results.
Created attachment 203848 [details] Screenshot with English labels I tend to agree with the idea, but dislike the potential checkbox "[x] Show Auto-Highlight", which controls this Focus Cell (in our terminology Col/Row Highlighting) during search.