when i press TAB key in an excel sheet nothing happens?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

max power - 20 Mar 2008 05:38 GMT

this was a sheet that was sent to me so i dont know what settings were played
with.

it is Quite annoying as the TAB doesnt move to the next cell like usual

i know how to change the way ENTER behaves but cannot find a setting for the
TAB button

Reply to this Message

yshridhar - 20 Mar 2008 06:04 GMT

May be scroll lock is on. Turn it off.
Best wishes
Sreedhar

> this was a sheet that was sent to me so i dont know what settings were played
> with.
[quoted text clipped - 3 lines]
> i know how to change the way ENTER behaves but cannot find a setting for the
> TAB button

Reply to this Message

Gord Dibben - 20 Mar 2008 16:44 GMT

Are you sure the Tab key does nothing?

Could be the sheet is protected.

Does the Tab key jump across many columns instead of one?

Do you have "Transition Navigation Keys" enabled at Tools>Options>Transition?

Disable if so.

Gord Dibben MS Excel MVP

>this was a sheet that was sent to me so i dont know what settings were played
>with.
[quoted text clipped - 3 lines]
>i know how to change the way ENTER behaves but cannot find a setting for the
>TAB button

Reply to this Message

max power - 24 Mar 2008 22:49 GMT

HI

yes the ta key does nothing i enabled the transition and then the sheet
jumps multiple columns and then i disabled the transition and it does nothing.

the sheet is protected with a password but i cannot understand why this
would disable the tab key

> Are you sure the Tab key does nothing?
>
[quoted text clipped - 15 lines]
> >i know how to change the way ENTER behaves but cannot find a setting for the
> >TAB button

Reply to this Message