Set the move after selection to "Down".

Tab, Tab,Tab then Enter should take you to start column one row down.


Gord Dibben MS Excel MVP

On Mon, 26 Jan 2009 10:18:34 -0800, Connie Martin
wrote:

An annoying thing is happening in my spreadsheets. When I tab across,
filling in data as I go, and hit Enter when I get to the end, sometimes it
does exactly what I want it to do---it drops down to the next row and moves
to the far left where I started (only one row down, of course). But in
another spreadsheet, it just moves down to the cell below when I hit enter.
Now a new thing has cropped up that when I press Enter nothing happens. It
just sits there in the same cell. I've gone into Tools/Options/Edit tab and
changed it to "Left" after the "move selection after Enter", so it just moves
one cell left on the same row. I want it to return to the cell below the one
I started in before tabbing across the sheet. I am not using the arrow keys.
I use Tab. Why the variation of response, and how do I fix it. It's so
annoying. I'm using Excell 2003, SP3. Thank you.