how to set tab spaces in excel?

1

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?
 
F

FSt1

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

Regards
FSt1
 
M

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
 
1

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.
 
M

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
 
1

1mshady

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