Using "Enter" key to tab over

M

Melissa

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
 
R

Ron Coderre

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
 
M

Melissa

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

Cary

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