Let Find and Replace always start in the first inputbox
When I first use Find and Replace (Ctrl+H) the upper inputbox Search for is selected. Fine. But when I use Find and Replace for the second time and further (during the same session), the lower inputbox Replace by is default. Please, always have the first inputbox selected.
Interesting. I usually use Alt-E-E and get what I talk about below. Oddly, I use Ctrl-F for Find, but never really shifted back over to Ctrl-H for Replace.
Bummed to find out they changed it... could mean the start of wholesale changes to shortcuts which, however much needed, would be aggravating... but seemed part of a plan (I'm cynical, yes) when the Ribbon menu system took over and they began hiding all the keyboard shortcut hints, so it wasn't unexpected.
But I tried it for old times' sake and it still works. Yay. But here's the whole reason to make this post: Using Ctrl-H, I get the proper insertion point indicator in the proper place, NOT the absence of it that I complained about below. Checking, Alt-E-E still gives me nothing there, Ctrl-H does. Did these people write two different routines for the two different shortcuts? They don't just point into the same code and run? Either that's crazy or at the least the set of old Ctrl-? shortcuts are burned deeply into Excel and we won't lose those, maybe, as easily to a wholesale reassignment project. So Yay, maybe.
Still need this though, gotta have it pop up ready to work, not ready for more key presses before one can start the work one brought it up for. I mean c'mon folks, I just REPLACED what on the "Find What" line... how likely is it my next plan is to do it again after I rid myself of all of them? I wonder though... no, whether I use Alt-E-E or Ctrl-H, it still comes up in the "Replace with" box each succeeding time until I quit Excel and start over.
Still need this.
Erik Berger commented
Ah whatever, I'm so used to it for so many years that I might get confused if this is fixed?
But worse is, as of this week, Ctrl-H does NOT open the Replace tab at all, but focus is on the Find tab, so no difference from Ctrl-B (F?) (Ctrl-B for me - probably Ctrl-F in english version - btw that has always sucked that shortcuts depend on language used).
Yeah, no doubt. Obnoxious, that. How likely is it I want to do the exact same F&R again?
I also find it obnoxious that for years now, at least since moving on from Excel 97, that first time I bring up the F&R box, the cursor really is in the Find entry box, but it does not show up, no slim little vertical "blinking cursor" line. Nothing. If I hit Tab|Shift-Tab to move it and return it there, the cursor shows up like a proud little boy. WHY can't it show there to begin with?