Enter, tab, arrow keys aren't allowing me to move to other cells

G

Greg

I have a multi page worksheet with functions throughout.
It has one sheet of inputs, other sheets hidden, input & answer sheets are
protected.
The Input sheet, several cells are available to input.
Yesterday I could move around with the enter key, tab, and arrows.
Today for some reason, the enter, tab, and arrow keys will not move me around.
I made sure all input cells and function formatted linked cells are unlocked
and unprotected.
I have to click into another cell to move.
***I reboot, and the keys still don't work.***
I have been through all the options settings, can't find the answer.
Help!
 
P

Peo Sjoblom

What do you mean? If you press tab nothing happens or it does move but not as
expected, if so uncheck transition navigation keys under
tools>options>transition
Since you already checked options I assume you checked the enter key
movements under tools>options>edit? You could also have a macro that turns
off different keys but it sounds unlikkely

Regards,

Peo Sjoblom
 
G

greg

Hey, thanks for quick reply.
To answer your question, the keys do nothing when I hit them.

BUT, I can narrow in on my problem even further.
I noticed the keys do not work after I protect the sheet.
What does this tell you?
-GReg
 
N

nikila40

Hi Greg!

I am having the same problem, but only with my "enter" key. Before when I
would hit "enter", the cursor would move to the first cell in the next row.
Now - nothing - the cursor stays in the same cell. I have to use my arrow
keys to move around. If you find an answer, post!

Thanks....
 
N

nikila40

THAT WAS IT!! Your response fixed my problem with the "enter" key, Peo!
Thanks....
 
R

Ron Rosenfeld

I have a multi page worksheet with functions throughout.
It has one sheet of inputs, other sheets hidden, input & answer sheets are
protected.
The Input sheet, several cells are available to input.
Yesterday I could move around with the enter key, tab, and arrows.
Today for some reason, the enter, tab, and arrow keys will not move me around.
I made sure all input cells and function formatted linked cells are unlocked
and unprotected.
I have to click into another cell to move.
***I reboot, and the keys still don't work.***
I have been through all the options settings, can't find the answer.
Help!
Click to expand...

Interesting.

The other day I had a similar problem with my arrow keys. They would scroll
the worksheet, but would not move me from cell to cell.

My options had not been changed.

In my case, the problem turned out to be that I had inadvertently pressed the
"scroll lock" button. But this did not affect the enter or tab keys.


--ron
 
G

greg

Peo,
I noticed this only happens when I have the sheet protected.
When I unprotect the sheet, the keys work.
What can you gather from this?
-Greg
 
Top