Re:Excel Never Dies
by sokoloff on Monday March 08, 2021 @12:02PM
(#26388114)
The one that drives me insane is that while editing a cell formula, that using the arrow keys move cells (and update [read: wreck]) the formula rather than moving the cursor within the formula you're editing.
[ Parent
| on HN ]
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
> 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.
If something is driving you nuts, ask on a forum, because excel is EXTREMELY flexible and used in some pretty high volume environments and the original developers really paid attention to user input (for a long while that stopped).
In many cases you are just not fully up to speed with the features in windows / excel.