That was your original setting.

Now when I hit Enter, the cursor goes to the cell beneath.

What has changed since then?

But glad to see you're happy<g


Gord

On Tue, 30 Oct 2007 08:03:03 -0700, BLUE TOPAZ
wrote:

I figured it out in an easier way....Tools..Options...Edit...I selected
'down'. Now I am back to normal. Thanks for input

"Gord Dibben" wrote:

Couple of ways to do this.

1. Unlock columns for data entry then protect the sheet. The Tab key will then
do as you wish or the Enter key will work if set to move right after entry.

2. With no protection, start in column A and Tab your way across to last data
column then hit Enter key to go back to A one row down.


Gord Dibben MS Excel MVP

On Tue, 30 Oct 2007 07:08:02 -0700, BLUE TOPAZ <BLUE
wrote:

Hello
When working in Excel, I have always hit Enter at the end of the line I am
entering data into, and was always returned to the cell at the left margin

Now when I hit Enter, the cursor goes to the cell beneath

I went into Tools...Options...Edit, but there is no selection to return to
Margin or new line, only left, down, right, up. If I select 'left' the
cursor just goes to the left cell

any ideas? thanks