entering data using tab

[Karen Boyd]

At one time when I pushed tab after typing data into a cell, my cursor would
move to the next column over in the same row, making that cell the active
cell. so entering in A1 --> tab moved me to B1. All is good and is what
expected.

For some reason if I enter in A1 --> tab my active cell is now H1. It is
driving me nuts. I cannot find any reference in help how to fix this, and I
don't know what I did to break it. Entering in B1 --> tab also takes me to
H1. Once I get to G1 when I tab I now end up in M1. There seems to be no
reason behind this. Any help would be appreciated. I use Excel 2003.

[Debra Dalgleish]

Choose Tools>Options
On the Transition tab, remove the check mark from Transition Navigation
keys.
Click OK

Karen Boyd wrote:
> At one time when I pushed tab after typing data into a cell, my cursor would
> move to the next column over in the same row, making that cell the active
> cell. so entering in A1 --> tab moved me to B1. All is good and is what
> expected.
>
> For some reason if I enter in A1 --> tab my active cell is now H1. It is
> driving me nuts. I cannot find any reference in help how to fix this, and I
> don't know what I did to break it. Entering in B1 --> tab also takes me to
> H1. Once I get to G1 when I tab I now end up in M1. There seems to be no
> reason behind this. Any help would be appreciated. I use Excel 2003.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html