Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 577
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 964
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 396
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
reference row on another sheet skipping zeros but not skipping li. Brennan Downes Excel Discussion (Misc queries) 2 April 2nd 23 01:28 PM
Skipping Cells CellSkipper Excel Worksheet Functions 5 January 25th 08 09:42 PM
Fill down while skipping cells tpl Excel Worksheet Functions 4 December 11th 07 10:01 PM
Skipping cells problem Paul Excel Worksheet Functions 3 July 5th 06 03:09 PM
skipping cells just1creation Excel Discussion (Misc queries) 2 June 27th 06 05:32 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"