Yes I know you have been using formulas in Excel for decades. But just trust me… there is more. Some small but nice things you should know.
Keep looking at the status bar
It shows you the current mode. First time you add a formula, it is in ENTER mode… next time you try to change it, the mode changes to EDIT.
So what difference? In ENTER mode, moving the arrow keys selects cells outside the current cell. This way you can select the range for formula parameters.
In Edit mode, moving the arrow keys (right and left), moves the cursor WITHIN the formula cell – which helps you in editing the formula itself.
This is also very useful when you edit formulas in odd places – like Conditional Formatting formulas, Data validation formulas and so…
View original post 230 more words