excel editing

%3CLINGO-SUB%20id%3D%22lingo-sub-2787852%22%20slang%3D%22en-US%22%3Eexcel%20editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2787852%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20constantly%20edit%20rows%20in%20excel%3C%2FP%3E%3CP%3Ehow%20do%20i%20change%20the%20direction%20the%20cursor%20moves%20from%20vertical%20to%20horizontal%20when%20i%20hit%20the%20return%20key%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2787852%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2787899%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20editing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2787899%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1167536%22%20target%3D%22_blank%22%3E%40tlabb%3C%2FA%3E%26nbsp%3BFile%2C%20Options%2C%20Advanced%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20very%20first%20option%20allows%20you%20to%20set%20the%20direction%20the%20cursor%20moves%20after%20%22Enter%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-09-27%20at%2012.56.21.png%22%20style%3D%22width%3A%20351px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F313074i0DC09CB93354B189%2Fimage-dimensions%2F351x209%3Fv%3Dv2%22%20width%3D%22351%22%20height%3D%22209%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-09-27%20at%2012.56.21.png%22%20alt%3D%22Screenshot%202021-09-27%20at%2012.56.21.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

i constantly edit rows in excel

how do i change the direction the cursor moves from vertical to horizontal when i hit the return key

3 Replies

@tlabb File, Options, Advanced

 

The very first option allows you to set the direction the cursor moves after "Enter"

Screenshot 2021-09-27 at 12.56.21.png

excellent thanks

@tlabb 

If anyone else needs to access your computer it could be kinder simply to commit the data/formula using the 'tab' key rather than 'enter'.