Tab between cells
Posted by cmb on January 26, 2001 6:52 AM
When I hit the tab to move between adjacent cells, it takes me from (for example) A1 to P1 or AE1. I want to tab from one column to the next without jumping around the worksheet. I have made no major changes in the options, why did it start doing this and how do I fix it? Thanks!
Posted by Mark W. on January 26, 2001 7:33 AM
Is your worksheet protected? If so, tabbing will take
you to the unlocked cells.
Posted by cmb on January 26, 2001 7:40 AM
Thanks for your speedy reply.
No, its not protected that I know of. I highlighted the whole sheet, clicked format, cells, protection and cleared the lock box. I then restarted the application.
Posted by Mark W. on January 26, 2001 7:43 AM
Have you selected a cell range prior to tabbing?
Posted by cmb on January 26, 2001 8:25 AM
No, I am trying to enter info into 4 adjacent columns. I type in one, tab to the next. But it send the cusor WAY over to column P or AE or some other bizarre spot. so I have to choose the adjacent column with the mouse which is very time consuming (and aggravating!)
Posted by Mark W. on January 26, 2001 8:42 AM
Does this worksheet have a macro?
Posted by cmb on January 26, 2001 9:47 AM
No macros, brand new worksheet. I did check to see though.
Posted by Walter on January 29, 2001 2:15 PM
You said you didn't make any "major" changes in the Options.
Check to make sure the Transition Navigation Keys are not activated.
Tools...Options...Transition...remove check on Transition Navigation Keys.
