I have an Excel sheet that I search repeatedly over the course of the day. Here is the use case:1. Open Excel and the document
2. Press ctrl-f and type search criteria
3. Press enter. Excel finds the cell with the text. (Find window stays open by default)
4. Press ctrl-f to search again. The Find and Replace window gets the focus.
5. Here is the issue: When I start typing, it appends the text to the existing text to search. (Instead of selecting the previous search so the first key press clears the last search)
Note: It does highlight it if you close the search box after every search, but not if you don't.
This is a new computer at a new company; at my old company, the search criteria was highlighted after doing a search in both Excel 2013 and Excel 2016. I am using Excel 2016.
Bookmarks