Re:Excel Never Dies
by airstrike on Monday March 08, 2021 @12:05PM
(#26388148)
Just hit F2 while editing a formula to toggle between Edit and Enter modes, one of which will behave as you expect. The other mode, which you hate, is very useful when you want to add references to other cells into your formula
[ Parent
| on HN ]
> is very useful when you want to add references to other cells into your formula
I really wish the default is the other way around. When I do want to add other cells, more than half the time there is a better way than using arrow keys.
Yes, the edit mode (using arrows to create formulas) is actually something I really find convenient.
To me it is a feature, not a bug. But yeah, F2 is fairly easy to use once you get used to it. Its like using VIM, the shortcuts seem annoying to the uninitiated, but once you get understand how everything works, the power can really speed things up and you appreciate it.