View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Cursor movement upon an event

Select columns A:G and then do you entry using the enter key or the tab key.
If the enter key does move right, then change it under tools-Options-Edit
tab under Move Selection after Enter

You can write a macro to do it, but seems like overkill to me if you can
exercise a little discipline.

--
regards,
Tom Ogilvy


"Mekinnik" wrote:

Lets say I have a worksheet with columns from A-G, when I enter a value into
column G I would like the cursor to move down 1 row and return to column B.
this would speed up my ability to enter my data in.