Move to right cell on Enter

[kashifjillani]

Hello Friends,

I don't know if someone has the same problem!

I input large data entries normally in row rather than column, and every time I press enter and cursor goes down whereas I want it to move to right cell.

Is there any possibility in Excel 2007?

Kashif

 

[Yahya]

try this steps :

• from office button choose Excel Option
• the from Advanced
• at first line you will see "After pressing Enter ,move selection"

you can change it as you want

 

[kashifjillani]

Thanks Yahya, it works.

great.

 

[Yahya]

Thanks Yahya, it works.

great.

you are welcome