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

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Tab Key reset 3
Conditional formatting based on adjacent cell? 1
Event recognition. 6
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Mark certain cells 6
COUNTIFS ? 1
How to populate a cell with numeric value based on textselected from pull down in adjacent cell? 1

Top