View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Taffy

With ToolsOptionsEditMove after enter set to "down".

Start in A1, work your way across to J1 using the TAB key to leave each
cell after typing in your data.

Leave J1 by hitting the ENTER key to go to A2.

Another way.........

Unlock columns A through J and protect the worksheet.

TAB your way across to J1 then next TAB will take you to A2.


Gord Dibben Excel MVP

On Tue, 1 Mar 2005 08:03:04 -0800, "Taffy"
wrote:

How can i select the first cell in the next row down after pressing enter or
tab?