how do i change the number of cells advanced when pressing tab

J

jesse

hello. i used to be able to advance to the right by one cell when pressing
tab.

now, if i am in column A, for instance, and i hit tab, it jumps
automatically to column K. this has happened on a couple of different
machines in my office.

does anyone know how to change this?

thanks,
jesse
 
D

David Biddulph

jesse said:
hello. i used to be able to advance to the right by one cell when
pressing
tab.

now, if i am in column A, for instance, and i hit tab, it jumps
automatically to column K. this has happened on a couple of different
machines in my office.

does anyone know how to change this?

Tools/ Options/ Transition:
Unset: Transition navigation keys.
 
G

Gord Dibben

jesse

Tools>Options>Transition.

Uncheck "Transition navigation keys"

Might as well uncheck the two below that also.


Gord Dibben MS Excel MVP
 
Top