ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to set tab spaces in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/174506-how-set-tab-spaces-excel.html)

1mshady

how to set tab spaces in excel?
 
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

how to set tab spaces in excel?
 
hi
on the menu bar....
Toolsoptionstransition tabUncheck transition navigation keys

Regards
FSt1

"1mshady" wrote:

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?


Mike Rogers[_2_]

how to set tab spaces in excel?
 
1mshady

Does it do this on all worksheets or only one? Check and see if the
worksheet is protected. (ToolsProtection, 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" wrote:

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?


1mshady

how to set tab spaces in excel?
 
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" wrote:

1mshady

Does it do this on all worksheets or only one? Check and see if the
worksheet is protected. (ToolsProtection, 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" wrote:

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?


Mike Rogers[_2_]

how to set tab spaces in excel?
 
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" wrote:

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" wrote:

1mshady

Does it do this on all worksheets or only one? Check and see if the
worksheet is protected. (ToolsProtection, 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" wrote:

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?


1mshady

how to set tab spaces in excel?
 
Thanks heaps FSt1.... it's back to normal.
It drove me nuts, I hate people using my computer!


"FSt1" wrote:

hi
on the menu bar....
Toolsoptionstransition tabUncheck transition navigation keys

Regards
FSt1

"1mshady" wrote:

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?



All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com