Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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