How do I keep the selection box in the work area

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Thank You Gord! Works Great

Gord Dibben said:
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
Click to expand...
 
Back
Top