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

Posted by Jonas Heidelberg on Super User See other posts from Super User or by Jonas Heidelberg
Published on 2012-10-09T09:30:09Z Indexed on 2012/10/09 9:41 UTC
Read the original article Hit count: 250

When I enter an Excel formula by hand avoiding the mouse, I can conveniently reference cells by using the arrow keys (->,<- etc.). For example, I can enter the formula =A2&B2 in cell C2 by entering

=<-&<-<-

The result looks like this:

enter image description here

If I want to change from B2 to B3, I can just press the downward arrow on the keyboard at this time.

How do I do the same thing later, after having left this cell (e.g. by pressing Enter)?

In other words, how do I get the flashing dashed line back when re-entering a cell with F2?

enter image description here

© Super User or respective owner

Related posts about microsoft-excel

Related posts about keyboard-shortcuts