Keyboard shortcuts are great and I'm used to many of them in my workflow - one of these is using the
Ctrl + A combination to select the entire content of the text box that's currently focused. However, for some reason I found that this doesn't work when trying to search via Find and Replace (
Ctrl + F) in Microsoft Excel.
This is not initially an issue when first opening the Find and Replace dialog since the content is automatically selected - however, if you look for something but then need to find something else, the
Ctrl + A shortcut just doesn't work - and I keep forgetting that and usually find out just when I've typed a bunch of gibberish and pressed
Enter to get a warning message that no results had been found.
It looks like
Ctrl + Home does the job - however, this isn't convenient since I'd need to drop the mouse, find the
Home button which, unfortunately, I do not have muscle memory of, so I have to look down to the keyboard, grab the mouse again and then carry on as usual.
Is there a shortcut that replaces
Ctrl + A or is there a way to enable
Ctrl + A in the Find and Replace dialog of Excel? If not, is there a specific reason for this?
EDIT: I tested on another machine and
Ctrl + A works fine in the Find and Replace dialog so it looks like a local issue. I'll update this question if I find the culprit.