If cell has any character typed in it cell curser moves to next c

[Guest]

When I type in any character, "number or letter" in a cell I need the box to
move to the next cell to be waiting to have another character typed in the
new cell. Then when that cell is filled with a character the box move to the
next cell to the right waiting for next character. I need this to happen to 6
cells in a row for a form.

 

[Gord Dibben]

After typing the character or number just hit the Tab key or go to
Tools>Options>Edit and set "move after enter" to right.

Excel doesn't know when you have finished typing in a cell until you hit enter,
tab or an arrow key.


Gord Dibben MS Excel MVP