Pressing ctrl+f should clear the last item searched
often times I'll press ctrl+f when the find window is open and paste a value or start typing only to find the last item i searched for was not cleared out, so i end up searching for a random jumble of text. it seems like a lot of wasted keystrokes (especially since you can't select all the text with ctrl+a). for example, if i last searched for "doctor", then press ctrl+f and paste something (like "nurse"), i end up searching for "doctornurse". i need to delete all the text and then repaste "nurse"!
Cedric Bergande commented
How is this still not fixed? So many corporations are using excel, the majority of users are using Ctrl+F and most of them are expecting Web-Browser or Word behaviour for Ctrl+F... This cannot be that difficult to change considering how many people clearly are waiting for this to be fixed FOR YEARS
So we're halfway 2020 and the first post is from Nov. 2015. SIgh, I'm convinced that MS developers do not use their own software or else this would have been fixed a long time ago.
It's such a standard workflow, select a text, press ctrl+f and hit enter to start a search for a duplicate of the selected text or if no text is selected start with an empty search box.
Why, does ctrl+a not work in the search box?..sigh and why does the search only search forward and not backwards or wrap-around?
Please fix this.
I´m using ctrl+F -> type search term -> enter -> esc (close search window) after next ctrl+f is search term still there but highlighted and i can write new term... But this is not suitable for everyone...
2020 still the same annoyance ...
this is really annoying . Please fix it.!
+2 for highlighting the last searched text so it can be overwritten by typing over or searched by hitting enter.
Vertigo Seventy commented
This is STILL a problem in 2019.... if you keep the find window open it DOES NOT HIGHLIGHT THE LAST SEARCH
This needs to change. The solution is simple and would save my so much effort. The solution works for people who always search for new things, and for people who always search the same things. Just highlight the text so that typing will delete the existing text, or hitting enter will search for the same text.
+1 for highlighting last searched for text, so that typing will overwrite it with a new search term
The solution would be to do what Word does - highlight the existing contents. That way it works both ways. If you don't type anything new, it will retain the previous search string, but if you do type, it replaces the search string. So simple (not to mention then being consistent with Word behavior)
I vote for clearing or selecting text in the Find box on pressing CTRL+F, whether the dialog box is open or not. I'm often searching for skill numbers in my large instructional objective worksheet and when I don't notice this dbox issue (I user two monitors, and sometimes the dbox is on the other monitor), I'm led to believe, incorrectly, that the skill is not included, but it is. This has occasionally caused me to create extra material unnecessarily. Maybe make this an option the user can select? I feel strongly this needs to be addressed because it can contribute to erroneous conclusions. Adobe Acrobat Pro has it right. (I've been using and writing about Excel for 25+, so this is not new-user error.) Thanks.
SOMETHING needs to change, this has been driving me crazy for years.
I would tend to agree with Erik Berger, Pressing control+f when the find window is open should have the same effect as pressing control+f when the find window is NOT open... IE, the find window should become active and the text inside the search term box should be selected so that the user can easily start typing to replace the text.
Erik Berger commented
NO, big NO!! The last-searched for text should be selected, which it is in my version. That way I can easily repeat the same Find&Replace command (e.g., for a different cell range selection) if I wish, and if I want to do a new search or enter a new replace string, I just overwrite the text.
If the text is not automatically selected, that is wrong, but clearing the last item is NOT the solution!
It could be an option then... what do you think?
I get caught up by this sometimes too, but more often I do search the same thing multiple times. I'd rather it not be changed.
Kenneth Barber commented
I kind of like having my last searched item appear. Sometimes I search for something, do something else, and come back to the same search.