Cursor moves after enter, when it should not

J

jss87

Using Excel 2003/SP2, I have the check box in tools/options/edit cleared for
"move cursor after enter". Normally this is fine, but I made a sheet with a
few protected cells and now it moves to the next unprotected cell, in
whatever direction is greyed out. I don't often protect cells, so I don't
remember if older versions worked correctly.

I'm doing a sort of manual optimization and I want to see the effects of
change, maybe try a different value in the same cell, or go to a cell of my
choosing, not Excels.
 
G

Guest

You'll have to unprotect your sheet, and then reprotect it, checking the box
labelled "Select locked cells". Of course you can then select any cell in
your worksheet.

It's a funny bug, which I don't think existed in previous versions, because
they never used to have the select locked cells option in the protection menu.

All the best

Glenton
www.leviqqio.com
 

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

cursor movement within a sheet 9
Insert Row also adds formulas and moves cursor 2
Tabbing to a specific cell 3
Protection causes unwanted cursor movement 5
Lose Cursor After Protecting Sheet 2
Completing Form Fields - Cursor Direction 1
change direction active cell indicator moves when enter key is pre 2
Move cursor one cell to the right after entering data 1

Top