Several questions about move cursor

[Guest]

Hi, I have a few questions about how to move cursor to specific cell

1, how can I move cursor to specific column and return to start column in
next row? For example my cursor start at column A and I move cursor left to
column G and then it force back to column B again in next row rather than
left move to column H

2, When I move my cursor to left or right, how can I jump over some cell
that I don't want people to touch, such as I move cursor from cell A1 to A10,
but I want cursor skip cell A3 to A5 and go to directly to A6 from A2?

3, How can I move cursor to left rather than move down?

Thanks a lot

 

[Gord Dibben]

Hank

Your directions seem a bit odd.

Have you got your sheet set up from right to left rather than left to right?

Whatever the case..............use the Tab key to move across to G.

When leaving G hit the ENTER key to return to column A and one row down.

As far as your second requirement goes..................you can do this by
locking A3:A5 then protecting the sheet with locked cells unselectable.


Gord Dibben MS Excel MVP