Excel caret/typing location issue

[MiniFav]

I have noticed when using the conditional format screen, if I have scrolled left or right in the worksheet prior to opening the conditional format screen, my cursor click within a formula will not place the caret/ typing location where my cursor clicked. I seem to have to close the workbook and reopen being mindful not to scroll if I want to amend a formula properly.

For example, here I was trying to click between the AA and 2 to amend the column reference and the caret is being placed withing the word "MATCH", but I am unable to reach AA2 without deleting part of the formula and retyping it.

Has anyone experienced this and know of a fix?

 

[Jeffrey Mahoney]

Did you know that you can press F2 after clicking in the formula bar and it will allow you to cursor freely?

 

[MiniFav]

Did you know that you can press F2 after clicking in the formula bar and it will allow you to cursor freely?

I did not know that! Thank you! i can no use the arrow keys instead to navigate the formula.