| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using the enter button
Is there a way to only go to specified cells with the enter key in Excell. I
know that you can lock cells and tab to the unlocked, but I need to enter my numbers going down and not to the right. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the enter button
'Tools'...'options'....edit tab....move selection after enter Direction: use
the drop down tab to change where you want the cursor to go after hitting enter. "Jeffg" wrote: Is there a way to only go to specified cells with the enter key in Excell. I know that you can lock cells and tab to the unlocked, but I need to enter my numbers going down and not to the right. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the enter button
There are cells I would like to skip though. I have a range of cells like
A5-A15 and then C5-C15. I would like the enter key to go to those cells to enter info only. When I reach A15 and hit enter, I would like it to take me to C5 and not A16. "tim m" wrote: 'Tools'...'options'....edit tab....move selection after enter Direction: use the drop down tab to change where you want the cursor to go after hitting enter. "Jeffg" wrote: Is there a way to only go to specified cells with the enter key in Excell. I know that you can lock cells and tab to the unlocked, but I need to enter my numbers going down and not to the right. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the enter button
Before you start entering, highlight A5-A15. Then while holding Ctrl key,
highlight C5-C15. The active cell will move down column A as you enter. As you reach A15, the next enter will take you to C5. -Simon "Jeffg" wrote: There are cells I would like to skip though. I have a range of cells like A5-A15 and then C5-C15. I would like the enter key to go to those cells to enter info only. When I reach A15 and hit enter, I would like it to take me to C5 and not A16. "tim m" wrote: 'Tools'...'options'....edit tab....move selection after enter Direction: use the drop down tab to change where you want the cursor to go after hitting enter. "Jeffg" wrote: Is there a way to only go to specified cells with the enter key in Excell. I know that you can lock cells and tab to the unlocked, but I need to enter my numbers going down and not to the right. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using the enter button
You can do this with a named range.
See Bob Phillips' site for instructions. http://www.xldynamic.com/source/xld.xlFAQ0008.html Gord Dibben MS Excel MVP On Fri, 4 Aug 2006 12:20:01 -0700, Jeffg wrote: Is there a way to only go to specified cells with the enter key in Excell. I know that you can lock cells and tab to the unlocked, but I need to enter my numbers going down and not to the right. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula for < or numbers. | Excel Worksheet Functions | |||
| ADD A RETURN BUTTON WHEN GOING TO FORMULA REFERENCE LINKS | New Users to Excel | |||
| shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
| Is there a (non-binary) "if x then enter y" forumula? | Excel Worksheet Functions | |||
| How do I setup a spin button in excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
