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

F

Form maker

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.
 
G

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
 
Top