Using "Enter" key to tab over

[Guest]

Hello,

Is there a way in Excel to use the enter key to offset to the next column
instead of the next row after data is entered (without using vba)?

Thanks!

Melissa

 

[Guest]

Try this:

From the Excel main menu:
<tools><options><edit tab>
Check: Move selection after Enter
Direction: right

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Ok now I feel really stupid for not looking! Thank you very much for your
help.
Melissa

 

[Cary]

Cool. And how about being able to toggle to another direction by using a
modifier key?