How do I get tab to move the cursor one cell over rather than 8?

[Mysti4God]

When I used tab to advance to the next cell in a worksheet, my cursor was
going from cell A1 to cell N1. When I looked in help, it told me to use
"shift+tab". I did that. Now when I hit tab it goes from cell A1 to cell I1.
To test my settings, I opened a brand new worksheet/workbook fresh. I put
my curser in cell A1. Hit tab and it advances to L1. I'm confused. Help?

[folderol]

The behavior you describe is the combination Alt-PageUp and Alt-PageDn keystrokes. The different columns are because the movement is to the right edge of the visible worksheet, not to a particular column. The TAB key is mimicing this because your tools, options, transition, has 'transition navigation keys' checked, which I _think_ is a lotus 123 legacy support.
Uncheck this option and the tab will return to normal.

Tom

[Mysti4God]

Thank you so much! I did as you said and now tab works as normal. Bless you
and thank you for taking the time to answer my inquiry. Your help was much
appreciated.

"folderol" wrote:

>
> The behavior you describe is the combination Alt-PageUp and Alt-PageDn
> keystrokes. The different columns are because the movement is to the
> right edge of the visible worksheet, not to a particular column. The
> TAB key is mimicing this because your tools, options, transition, has
> 'transition navigation keys' checked, which I _think_ is a lotus 123
> legacy support.
> Uncheck this option and the tab will return to normal.
>
> Tom
>
>
> --
> folderol
> ------------------------------------------------------------------------
> folderol's Profile: http://www.excelforum.com/member.php...o&userid=37288
> View this thread: http://www.excelforum.com/showthread...hreadid=570006
>
>