My TAB BUTTON in Excel doesn't work as usual

Lưu Anh Tuấn 20 Reputation points
2024-05-27T03:06:12.67+00:00

Hi all,

As usual I press TAB button to move to the next cell on the right (in Microsoft Excel) but recently it moves to the edge of the screen.

For example From A1 to B1 is normal but it will move from A1 to U1, or B1, C1, .....T1 to U1 (Column U is in the edge of my screen on the right).

Please help me with this error or function, I'm using Microsoft 365, Win 11.

Thank you!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,887 questions
0 comments No comments
{count} votes

Accepted answer
  1. Jiajing Hua-MFST 9,905 Reputation points Microsoft Vendor
    2024-05-27T07:08:47.4666667+00:00

    Hi @Lưu Anh Tuấn

    I suggest you go to File > Options > Advanced >Lotus Compatibility, untick the box of "Transition navigation keys".

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.