5 ms·
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 movi
by sokoloff 6y ago
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.
- airstrike 6y agoJust 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
- jacurtis 6y agoYes, 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.
- ska 6y ago> 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.
- temp667 6y agoIf 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.