| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
get the curser to automatically return
How do I get the curser to automatically return to my starting column
(example Im in A1 and move to C1 enter and the curser will not go back to A2 only up, down, left, right ). Is there a way to set this up so it will return to your starting point? Charles -- Charles |
|
#2
|
|||
|
|||
|
Charles
Start in A1 then TAB across to C1. When leaving C1 hit ENTER key to drop down to A2. Using this method you will always return to original column and down one row. Another method is to unprotect columns A to C then protect the worksheet. TAB will move you across to C then back to A down one row. Gord Dibben Excel MVP On Tue, 20 Sep 2005 13:40:03 -0700, "Charles" wrote: How do I get the curser to automatically return to my starting column (example I’m in A1 and move to C1 enter and the curser will not go back to A2 only up, down, left, right ). Is there a way to set this up so it will return to your starting point? Charles |
|
#3
|
|||
|
|||
|
My tab key takes me to P1
-- Charles "Charles" wrote: How do I get the curser to automatically return to my starting column (example Im in A1 and move to C1 enter and the curser will not go back to A2 only up, down, left, right ). Is there a way to set this up so it will return to your starting point? Charles -- Charles |
|
#4
|
|||
|
|||
|
In that case, go to ToolsOptionsTransition and uncheck "Transition
Navigation Keys". Gord On Tue, 20 Sep 2005 15:02:02 -0700, "Charles" wrote: My tab key takes me to P1 |
|
#5
|
|||
|
|||
|
If you select columns A:C, then hit the tab key (or enter key), what's the
pattern that it follows? Charles wrote: My tab key takes me to P1 -- Charles "Charles" wrote: How do I get the curser to automatically return to my starting column (example Im in A1 and move to C1 enter and the curser will not go back to A2 only up, down, left, right ). Is there a way to set this up so it will return to your starting point? Charles -- Charles -- Dave Peterson |
|
#6
|
|||
|
|||
|
Thanks guys it works.
-- Charles "Dave Peterson" wrote: If you select columns A:C, then hit the tab key (or enter key), what's the pattern that it follows? Charles wrote: My tab key takes me to P1 -- Charles "Charles" wrote: How do I get the curser to automatically return to my starting column (example I€„¢m in A1 and move to C1 enter and the curser will not go back to A2 only up, down, left, right ). Is there a way to set this up so it will return to your starting point? Charles -- Charles -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| In excel, can I format a cell to automatically take the curser to. | Excel Worksheet Functions | |||
Linear Mode
