Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Several questions about move cursor
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Several questions about move cursor
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 On Fri, 4 Aug 2006 12:18:02 -0700, Hank wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard arrows won't move cursor! | Excel Discussion (Misc queries) | |||
Hitting Enter to Move Cursor to the Next Entry Cell | Excel Worksheet Functions | |||
In a protected sheet how do I get the cursor to only move to unlo. | Excel Discussion (Misc queries) | |||
Cursor wil not move left in worksheet | Excel Worksheet Functions | |||
Move Cursor to A1 | Excel Discussion (Misc queries) |