[85Dave]

I'm new to excel and learning it at my local college but am stuck with a small problem.

say I enter info in A2, then B2... and so on until I get to say... E2.
If I hit enter after inputting info into E2 my next active cell is random.

its going between all the letters in the next row down, (in my case.. the 3 row).

Is there a default to change to get it to go back to the far left column when hitting enter to go to the next line?

Thanks,
Dave

[JBeaucaire]

I've run into this problem and solved it with WORD.

I created a 5-cell chart in Word and started entering data. As I press TAB I move from cell to cell and when I enter the data in the 5th cell and press TAB, it adds a new row to the table and jumps me back to the first cell in the new row.

When I was done, I copied the table, and pasted it into Excel.

[85Dave]

Sounds like a fair enough temp. fix but the class must use Excel for the tests and the teacher doesn't know how to fix it in the settings...

[JBeaucaire]

OK, here's another way.

• Go to TOOLS > OPTIONS > EDIT > Move Selection After Enter <RIGHT>
• Now in your spreadsheet, use your mouse to select the block of cells you will be working in, perhaps A1:E20
• The selected area turns grey
• With the cursor in the first cell, start entering data
• As you press Enter, the cursor moves to the right as instructed above
• When you get to cell E1 and enter the data, the next cell will be B1

How's that?

[ScottGem]

Another alternative is to create a macro attached to a keystroke. You could record a macro that does a <Down> then <End><Left>. Attach it Ctrl+N so instead of pressing Enter you press Ctrl+N.