normally, I can hit the 'esc' key when I'm editing a cell and it cancels what's been typed in. now, it is not working for some reason.
for example, if I'm trying to get the text "+" input into a cell but I forget to type ' first, Excel thinks I'm making a formula and activates the dashed outline to help me select a cell reference. Since this is not what I want, I hit escape, except now Excel does not respond to this key, remaining locked instead in formula search mode.
The only option I have changed is 'disallow editing directly in cells' but I changed this option back and the behavior was the same.