set TAB to move one cell to the right

[joe-carter]

A co-worker's excel 2007 used to move one cell to the right when she hit the "Tab" key.

Now it moves a page to the right?

I can't seem to find out how to change or reset this. The help "Excel shortcut and function keys" even says Tab is supposed to move one cell to the right.

Any help would be greatly appreciated.

Joe

 

[Jonmo1]

In the Excel Options (click the orb at top left)
Under Advanced
Scroll all the way down under Lotus Compatibility
UNcheck "Transition Navigation Keys"

 

[joe-carter]

Thanks! I would've never found that.

Joe

 

[Jonmo1]

Yep, that's a good thing to store in the back of your mind...
Those lotus options at the bottom there, they cause LOTS of strange problems..