EXCEL change which cell is selected next

[Guest]

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

 

[RagDyeR]

Didn't you use the <Tab> key to move right after each cell entry?

THEN ... a hit of <Enter> will return you to the next row down, *under* the
cell you first started with.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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

 

[Gord Dibben]

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

 

[Guest]

Didn't you use the <Tab> key to move right after each cell entry?

THEN ... a hit of <Enter> will return you to the next row down, *under* the
cell you first started with.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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

 

[Guest]

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]

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

 

[Guest]

I want to use the Tab key to move right, and I know what I need to do, but I
can't even find Tools so I can get to Option...Edit ...etc. I clicked on the
Home icon, then on Exel Options, but nowhere can I find the option to
deselect the Transition Navigator. Can anyone help?

 

[Peo Sjoblom]

Click the office button top left, then select excel options>advanced



--


Regards,


Peo Sjoblom

 

[Guest]

Did that - still can not find option to de-select Transition Navigator.

 

[Peo Sjoblom]

There is no Transition Navigator, there are 3 check boxes, one called
"transition navigation keys", one called "transition formula evaluation" and
"transition formula entry"
Once you have select excel options>advanced scroll to the bottom until you
find "lotus navigation keys"




--


Regards,


Peo Sjoblom

 

[Guest]

Got it - thanks!
--
Terri

There is no Transition Navigator, there are 3 check boxes, one called
"transition navigation keys", one called "transition formula evaluation" and
"transition formula entry"
Once you have select excel options>advanced scroll to the bottom until you
find "lotus navigation keys"




--


Regards,


Peo Sjoblom