Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default If cell has any character typed in it cell curser moves to next c

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct issues SteveDB1 Excel Worksheet Functions 25 June 3rd 09 04:58 PM
How to force a cell value to change if Linked cell moves? EagleOne Excel Discussion (Misc queries) 2 December 6th 06 03:32 PM
Cleaning up data -- any way to globally fix this?? The Moose Excel Discussion (Misc queries) 3 November 26th 06 02:50 PM
Count occurrence of character within a cell Kelli Excel Discussion (Misc queries) 2 January 18th 06 02:20 PM
Tab key moves curser to right one cell at a time. Arturo Excel Discussion (Misc queries) 1 May 4th 05 04:05 PM


All times are GMT +1. The time now is 09:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"