This is a default setting because this is how most users input data.
You may even prefer that it not move at all.
It’s easy to change the cursor’s movement direction in Excel for Windows.
Select theFiletab of the ribbon to open theFilemenu.
SelectOptionsin the menu to openExcel Options.
SelectAdvancedin the left pane of the dialog box.
In theEditing Optionssection, go toAfter pressing Enter,move selectionin the right pane.
grab the down arrow next toDirectionand chooseup,left, orright.
SelectOKto store your changes.
The Excel cursor direction is now changed.
SelectPreferencesin the menu to openExcel Preferences.
In theEditing Optionssection, go toAfter pressing Enter,move selectionin the right pane.
grab the down arrow next toDirectionand chooseup,right, orleft.
SelectOKto stash your changes.
Your Excel cursor direction is now changed.
Instead, use theTabkey to move left to right across a worksheet when entering your data.
