View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default If cell has any character typed in it cell curser moves to next c

After typing the character or number just hit the Tab key or go to
ToolsOptionsEdit 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


On Sun, 17 Dec 2006 17:16:00 -0800, Form maker
wrote:

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.