How do I keep the selection box in the work area

[Guest]

After entering data into a cell I press the enter key and the selection box
moves one cell to the right. How do I make it drop down one line and to the
beginning cell after reaching the last column in the work area?

 

[Gord Dibben]

Ken

Set your ENTER key to move down.......Tools>Options>Edit "move after entry"

Then when entering data across a row, use the Tab key to move right.

When you reach the last data entry cell in that row, hit the ENTER key to move
back to start column and down one row.

i.e. Start in A1 and Tab across to H1. Hit ENTER and go back to A2


Gord Dibben MS Excel MVP


On Mon, 26 Jun 2006 20:34:01 -0700, Ken Dean <Ken

 

[Guest]

Thank You Gord! Works Great

Ken

Set your ENTER key to move down.......Tools>Options>Edit "move after entry"

Then when entering data across a row, use the Tab key to move right.

When you reach the last data entry cell in that row, hit the ENTER key to move
back to start column and down one row.

i.e. Start in A1 and Tab across to H1. Hit ENTER and go back to A2


Gord Dibben MS Excel MVP


On Mon, 26 Jun 2006 20:34:01 -0700, Ken Dean <Ken