How can I move from one desired cell to another in Excel using ENT

[Guest]

hello, I am working on an extremely important excel 2002 worksheet and am
using only 3 cells. The remaining cells are locked so they cannot be modified
by any third party. Lets say I am inputing data only in cells D8, M7 and M9.
I always start inputing data at M7, then M9 and finishing with D8. As soon as
I finish with M7 and pressing the ENTER button I would like to be directly
transfered to cell M9 and next to D8. Is this possible?
All searches I have made have left me unsatisfied.

many thanks

 

[Gord Dibben]

When protecting the worksheet check the "select locked cells" and uncheck
"select locked cells"

M7 will be first, then M9 then D8 if Tools>Options>Edit "move selection after
enter" is set to "down"


Gord Dibben MS Excel MVP

 

[Guest]

what sorry, check and uncheck ''select locked cells''?
What would Checking and unchecking it again change?

many thanks for replying

 

[Gord Dibben]

Typo in this..........sorry for the confusion.

When protecting the worksheet check the "select locked cells" and uncheck
"select locked cells"

Should read.................

When protecting the worksheet check the "select unlocked cells" and uncheck
"select locked cells"


Gord

 

[Guest]

I managed to do it. I did not understand your full concept but I understood
that it had something to do with checking locked cells.

Now I can move from one cell to the next using the TAB button.


many thanks anyway

 

[Gord Dibben]

Thanks for the feedback and I'm sorry you spent some time trying to figure out
what I was talking about with the typo.


Gord

I managed to do it. I did not understand your full concept but I understood
that it had something to do with checking locked cells.

Now I can move from one cell to the next using the TAB button.


many thanks anyway

Gord Dibben MS Excel MVP