ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Tab is skipping 10 cells, how do I stop this? (https://www.excelbanter.com/excel-discussion-misc-queries/196744-tab-skipping-10-cells-how-do-i-stop.html)

scott

Tab is skipping 10 cells, how do I stop this?
 
Yesterday for some reason, my tab key started skipping 10+ cells when I hit
it. It isn't that excel has learned that 10 is the number I need to skip to
get to the next entry, because it does it at any location on all worksheets.
There must be some option or something that I accidentally turned on, but I
cannot find anything. Does anyone know how to turn this off?

Peo Sjoblom[_2_]

Tab is skipping 10 cells, how do I stop this?
 
Toolsoptionstransition and clear "transition navigation keys"
You probably opened a spreadsheet originally created in Lotus
as the first workbook and the settings got applied to your
Excel

--


Regards,


Peo Sjoblom

"Scott" wrote in message
...
Yesterday for some reason, my tab key started skipping 10+ cells when I
hit
it. It isn't that excel has learned that 10 is the number I need to skip
to
get to the next entry, because it does it at any location on all
worksheets.
There must be some option or something that I accidentally turned on, but
I
cannot find anything. Does anyone know how to turn this off?




Wigi

Tab is skipping 10 cells, how do I stop this?
 
Did you perhaps apply Protection to the sheet?


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Scott" wrote:

Yesterday for some reason, my tab key started skipping 10+ cells when I hit
it. It isn't that excel has learned that 10 is the number I need to skip to
get to the next entry, because it does it at any location on all worksheets.
There must be some option or something that I accidentally turned on, but I
cannot find anything. Does anyone know how to turn this off?


FSt1

Tab is skipping 10 cells, how do I stop this?
 
hi
check this......
2003-toolsoptionstransition tabuncheck transition navigation keys

regards
FSt1

"Scott" wrote:

Yesterday for some reason, my tab key started skipping 10+ cells when I hit
it. It isn't that excel has learned that 10 is the number I need to skip to
get to the next entry, because it does it at any location on all worksheets.
There must be some option or something that I accidentally turned on, but I
cannot find anything. Does anyone know how to turn this off?



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

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