Can I reactivate the cursor keys for modifying a cell reference in a formula?
- by Jonas Heidelberg
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:
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?