How to edit a formula in Excel


Efficiency 365

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.

SNAGHTML17534ab2

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.

In some cases, you may want to change the mode. To do that press SNAGHTML175594c1

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