Thanks. I suggest you look into Excel's behavior while in formula mode and the difference between the Enter and Edit modes which you can toggle with F2 after already being in formula mode

So F2 once to switch to editing a cell, then F2 again to switch between edit and enter, then start typing a formula and click around