When I directly start to type content into a cell, Excel is in Input Mode, which means I could easily reference cells in formulas. Unfortunately most of the time I do not enter formulas, but simple text - hitting a cursor key here means "leaving the cell", which is most annoying when I try to correct a spelling mistake.

I am aware that I can use F2 to enter Edit Mode, I just happen to realize that when it is too late.

Hence: How can I make Excel enter Edit Mode instead of Insert Mode by default?

More details on Can I reactivate the cursor keys for modifying a cell reference in a formula?

For the record: I am using Microsoft Excel 2010.


I have never come across a way to do this in any version of Excel - the "F2" shortcut key is the closest that you will get.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.