Set cell Focus

[cdllt]

Hello,
I set the cell focus after hit "enter" will move to the right direction but I would like it move down to next row after certain cell in the row, for example

Cell B5 => C5 => D5 => E5 then B6 => C6 => D6 => E6

Is there anyway we can do this? can anyone help please.


Thanks

[JBeaucaire]

To do this without employing VBA, you must first highlight the range of cells to "cycle through". Highight B5:E10 then try editing.

[cdllt]

hi,
thank you for reply, how do I set "cycle through" ? or do you have the macro code?

Thanks

[JBeaucaire]

Highight B5:E10, then try editing. That's it. http://screencast.com/t/Yt2A8M2hx

[cdllt]

ouch, that's so simple trick which I never know. thank you so much!