Share via

Arrow Keys cannot select a cell reference when editing a formula within a cell

Anonymous
2020-03-10T15:53:39+00:00

Hi,

I've been editing a document and working on some formula and suddenly I cannot select cell references using arrow keys. E.g. (bar represents cursor) I type in cell A1 =SUM(|    *then use right arrow key* normally this would select cell B1 making it =SUM(B1 but what happens is this > |=SUM(

I could not fix it, it is not a scroll lock issue.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2020-03-10T16:32:46+00:00

Hi mtakamoto,

Please type =SUM( then press F2 to switch to edit mode, after that try using arrow keys.

If you need more help, Please capture a screenshot of your File > Account page. (Please mask personal information on the screenshot to protect your privacy).

Regards,

Eric

Was this answer helpful?

3 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-03-11T17:35:31+00:00

    Hi,

    If you need more help, you can post your latest condition.

    Regards,

    Eric

    Was this answer helpful?

    0 comments