I want to share with you a favourite Excel tip of mine. I think you will like this tip if you avoid using your mouse for formula work as much as possible in Excel.
The Excel formula bar, located just above the work area, shows either a cells value or a formula, whichever is typed into the selected cell in your Excel worksheet. Ordinarily, to edit a formula, you would click directly into the formula bar. I do find this kind of annoying, but no more do you need to use a mouse to click into the cell, then edit your formulas. All you need to do it hit F2!
- Editing options
- Tick Allow editing directly in cells