All day today, I’ve had an issue with Excel. I do a Find All. For example, I’ll look for LNY. Then I want to look for LNT and LNL. Before today, I do the first find and nothing is found. I would then hit the backspace to change the last character, and hit Enter. Again, as expected, there would be no LNTs found. Repeat for LNL.
Today, the cursor does not return to the Find box. When I hit backspace, I clear the cell. Did I inadvertently change something? Or has there been some sort of update to make it easier for people to inadvertently delete data?
In Excel there is a “typing replaces selected text” option. You may have somehow enabled it. I’d guide you to where that option is but you didn’t say what version of Excel you’re using. Either way, I’d check that first.
I don’t think Excel works the same way Word does in this case.
In Excel, the overtype/insert option is toggled by the Insert key on the keyboard, and used to be indicated by OVR in the status bar at the bottom of the screen. The version I’m using does not seem to have this indicator any more, and you just have to go by what happens when you type.
