MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.