Cursor Movement In Teams Excel Sheet

New Contributor

Does anyone know how to change the direction the cursor moves in a Excel spreadsheet in Teams? I cannot find the option to change it from moving down to the next cell, to moving to the right to the next cell. I know how to change this in Excel itself, but haven't been able to locate this option within Teams. This is very annoying when trying to populate a sheet where you input information across a row.

3 Replies
Select the File tab of the ribbon to open the File menu. Select Options in the menu to open Excel Options. Select Advanced in the left-hand pane of the dialog box. In the Editing Options section, go to After pressing Enter, move selection in the right-hand pane.



That is the thing, I don't get "options"...If I click on File, this is what I see:



I cannot find how to do this either. Like David has said, there is no "Options" tab under the File tab in Teams. Please advise @Lewis-H