how to set tab spaces in excel?

[1mshady]

Some one has changed the tab spacing on my computer so now it jumps from A to
G, how do I get it back to moving one cell at a time?

 

[FSt1]

hi
on the menu bar....
Tools>options>transition tab>Uncheck transition navigation keys

Regards
FSt1

 

[Mike Rogers]

1mshady

Does it do this on all worksheets or only one? Check and see if the
worksheet is protected. (Tools>Protection, if "protect" is an option it is
NOT protected, if "unprotect" is an option it IS protected) The tab will go
from unlocked cell to unlocked cell in a protected worksheet.

Mike Rogers

 

[1mshady]

Hey Mike... Thanks for your help, the sheet is not protected and yes it does
it to all worksheets and is really frustrating me.

 

[Mike Rogers]

1mshady

Did you try the other solution that FSt1 suggested? I placed a check mark
in transitions Navigation keys and I jumped from column A all the way to
column X. Is it jumping to column G on all worksheets? Might be a sticky
"Tab" key on your keyboard. Hang in there and maybe some one else will come
up with a be3tter solution.

Mike Rogers

 

[1mshady]

Thanks heaps FSt1.... it's back to normal.
It drove me nuts, I hate people using my computer!