Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .