Share via

my excel shift + control tab with arrow not working properly

Anonymous
2024-07-09T06:38:04+00:00

my excel shift + control tab with arrow not working properly

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rory Archibald 18,875 Reputation points Volunteer Moderator
    2024-07-09T08:07:05+00:00

    Hi,

    Check File - Options and in the Advanced section scroll down to the bottom and make sure that the Transition Navigation Keys option is not checked.

    0 comments
  2. Anonymous
    2024-07-09T09:16:10+00:00

    Thank you so much for this great help. Now it's working well. Thank you so much for your help. One more problem is coming i.e. This sum is not happening but when I do this sum through Formula tab's Auto Sum then sum happens. Please provide solution this issue also.

    906 302 178 979 85
    938 112 830 817 594
    543 132 195 574 479
    63 26 416 820 131
    689 431 353 590 888
    2 18 256 117 802
    874 44 671 114 909
    64 256 996 109 968
    =SUM(F3:F11) 0 0 0 0
    0 comments
  3. Rory Archibald 18,875 Reputation points Volunteer Moderator
    2024-07-09T09:17:52+00:00

    It's hard to tell from that but if that formula is in row 11 then you have created a circular reference by including row 11 in the SUM.

    0 comments
  4. Anonymous
    2024-07-09T09:29:08+00:00

    And also always double zeros come in the calculation. I ticked Circular Reference but still problem is there.

    0 comments
  5. Rory Archibald 18,875 Reputation points Volunteer Moderator
    2024-07-09T09:35:56+00:00

    If that formula is in row 11, then it should be =SUM(F3:F10)

    0 comments