How do I keep the "tab" key from jumping over adjacent cell

S

Srobinson2

My "tab" key does not go to the adjacent cell. From column "A" it jumps to
column "C" then column "K" and so on.
 
R

Roger Govier

Hi

It sounds as though some cells are Locked and sheet protection has been
turned on.
Tools>Protect>Unprotect sheet.
 
G

Gord Dibben

The sheet could be protected with some columns unlocked.

The Tab key would jump to the unlocked columns.

Or you have Tools>Options>Transition>Transition Navigation Keys enabled.


Gord Dibben MS Excel MVP
 
2

2007 Try this:

Gord Dibben said:
The sheet could be protected with some columns unlocked.

The Tab key would jump to the unlocked columns.

Or you have Tools>Options>Transition>Transition Navigation Keys enabled.


Gord Dibben MS Excel MVP
Click to expand...
 
D

Diana Grijalva

Nope - my cells are not locked, and it happens on every excel document I have. I suspect it has something to do with compatability with my home version of Excel 2007, and my work version of Excel 2003. They don't let us download anything at work, so I can't fix it with a compatability software from Microsoft.

It would be lovely if it was something as simple as a locked cell!

:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Need Help with a VBA subroutine 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Table of content - format does not get saved 2
Dealing with the error: unable to filter on excel hc home school 0
Cumulative formula for word table 0
Tab Key reset 3
Excel does not accept text format! 0

Top