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.