6

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.

Community
  • 1
mthomas
  • 163

2 Answers2

0

I found a video that explains 3 ways to get into editing mode (Double click, clicking the formula bar, and F2). It also explains how to use VBA to make it so clicking any cell once enters editing mode, but it didn't seem to work for me. Perhaps you can adapt it. Also, it would only work in whatever individual workbook you save it too, unless you can get it to work from the Personal Macro Workbook (An easy way to make the Personal Macro Workbook is to record a marco and choose that option in the "Store Macro In:" dropbox.

YouTube Video: How to Activate Cell Editing Mode in Excel With a Single Mouse Click

lordelliott
  • 1
0

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.

bmshort
  • 201