Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change direction when pressing enter
Is there a keyboard shortcut that changes the direction of the move when
pressing enter? I know how to do it in excel options, but I was wondering if there was a shortcut. -- Rick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change direction when pressing enter
Shift+Enter will change active cell to one above (assuming default is one
below) If only 1 cell is selected, Ctrl+Enter will not move active cell (if multiple cells are selected and you press Ctrl+Enter, the value inputed into active cell will be applied to all cells within selection). And of course, Tab & Shift+Tab move cell to right/left. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: Is there a keyboard shortcut that changes the direction of the move when pressing enter? I know how to do it in excel options, but I was wondering if there was a shortcut. -- Rick |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change direction when pressing enter
After I have selected "after pressing enter - move selection", and I select
"Down". Are there any Keyboard shortcuts that will toggle the selection to either right, up, or left while I am working in the spreadsheet? I know how to do this in excel options, but was looking for a quicker way to do it. Thanks for your help! -- Rick "Luke M" wrote: Shift+Enter will change active cell to one above (assuming default is one below) If only 1 cell is selected, Ctrl+Enter will not move active cell (if multiple cells are selected and you press Ctrl+Enter, the value inputed into active cell will be applied to all cells within selection). And of course, Tab & Shift+Tab move cell to right/left. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: Is there a keyboard shortcut that changes the direction of the move when pressing enter? I know how to do it in excel options, but I was wondering if there was a shortcut. -- Rick |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
change direction when pressing enter
To change the setting permanently, I don't believe there is a "toggle"
shortcut. You could write a short macro using the MoveAfterReturnDirection property: Application.MoveAfterReturnDirection = xlToRight And through the use of input boxes, or different macros w/ assigned shortcut keys, create your own "toggle". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: After I have selected "after pressing enter - move selection", and I select "Down". Are there any Keyboard shortcuts that will toggle the selection to either right, up, or left while I am working in the spreadsheet? I know how to do this in excel options, but was looking for a quicker way to do it. Thanks for your help! -- Rick "Luke M" wrote: Shift+Enter will change active cell to one above (assuming default is one below) If only 1 cell is selected, Ctrl+Enter will not move active cell (if multiple cells are selected and you press Ctrl+Enter, the value inputed into active cell will be applied to all cells within selection). And of course, Tab & Shift+Tab move cell to right/left. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: Is there a keyboard shortcut that changes the direction of the move when pressing enter? I know how to do it in excel options, but I was wondering if there was a shortcut. -- Rick |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
change direction when pressing enter
I was hoping it would be easier than that. Thanks for your help
-- Rick "Luke M" wrote: To change the setting permanently, I don't believe there is a "toggle" shortcut. You could write a short macro using the MoveAfterReturnDirection property: Application.MoveAfterReturnDirection = xlToRight And through the use of input boxes, or different macros w/ assigned shortcut keys, create your own "toggle". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: After I have selected "after pressing enter - move selection", and I select "Down". Are there any Keyboard shortcuts that will toggle the selection to either right, up, or left while I am working in the spreadsheet? I know how to do this in excel options, but was looking for a quicker way to do it. Thanks for your help! -- Rick "Luke M" wrote: Shift+Enter will change active cell to one above (assuming default is one below) If only 1 cell is selected, Ctrl+Enter will not move active cell (if multiple cells are selected and you press Ctrl+Enter, the value inputed into active cell will be applied to all cells within selection). And of course, Tab & Shift+Tab move cell to right/left. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: Is there a keyboard shortcut that changes the direction of the move when pressing enter? I know how to do it in excel options, but I was wondering if there was a shortcut. -- Rick |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
change direction when pressing enter
If the only thing you're doing is entering data, simply use the arrow keys
instead of <Enter. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RickMoore" wrote in message ... I was hoping it would be easier than that. Thanks for your help -- Rick "Luke M" wrote: To change the setting permanently, I don't believe there is a "toggle" shortcut. You could write a short macro using the MoveAfterReturnDirection property: Application.MoveAfterReturnDirection = xlToRight And through the use of input boxes, or different macros w/ assigned shortcut keys, create your own "toggle". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: After I have selected "after pressing enter - move selection", and I select "Down". Are there any Keyboard shortcuts that will toggle the selection to either right, up, or left while I am working in the spreadsheet? I know how to do this in excel options, but was looking for a quicker way to do it. Thanks for your help! -- Rick "Luke M" wrote: Shift+Enter will change active cell to one above (assuming default is one below) If only 1 cell is selected, Ctrl+Enter will not move active cell (if multiple cells are selected and you press Ctrl+Enter, the value inputed into active cell will be applied to all cells within selection). And of course, Tab & Shift+Tab move cell to right/left. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: Is there a keyboard shortcut that changes the direction of the move when pressing enter? I know how to do it in excel options, but I was wondering if there was a shortcut. -- Rick |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
change direction when pressing enter
most of the time I use the 10 key pad, so using the enter key is easier. I
set up a couple of macros to toggle and it works fine. Thanks for the suggestion. Rick "RagDyer" wrote: If the only thing you're doing is entering data, simply use the arrow keys instead of <Enter. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RickMoore" wrote in message ... I was hoping it would be easier than that. Thanks for your help -- Rick "Luke M" wrote: To change the setting permanently, I don't believe there is a "toggle" shortcut. You could write a short macro using the MoveAfterReturnDirection property: Application.MoveAfterReturnDirection = xlToRight And through the use of input boxes, or different macros w/ assigned shortcut keys, create your own "toggle". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: After I have selected "after pressing enter - move selection", and I select "Down". Are there any Keyboard shortcuts that will toggle the selection to either right, up, or left while I am working in the spreadsheet? I know how to do this in excel options, but was looking for a quicker way to do it. Thanks for your help! -- Rick "Luke M" wrote: Shift+Enter will change active cell to one above (assuming default is one below) If only 1 cell is selected, Ctrl+Enter will not move active cell (if multiple cells are selected and you press Ctrl+Enter, the value inputed into active cell will be applied to all cells within selection). And of course, Tab & Shift+Tab move cell to right/left. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: Is there a keyboard shortcut that changes the direction of the move when pressing enter? I know how to do it in excel options, but I was wondering if there was a shortcut. -- Rick |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
change direction when pressing enter
I have never tried to use a macro before today. It was very easy to set up
and it gives the "toggle" I was looking for. Not only did I solve a little problem, I learned a valuable tool to use in the future. Thanks for your help! -- Rick "RickMoore" wrote: I was hoping it would be easier than that. Thanks for your help -- Rick "Luke M" wrote: To change the setting permanently, I don't believe there is a "toggle" shortcut. You could write a short macro using the MoveAfterReturnDirection property: Application.MoveAfterReturnDirection = xlToRight And through the use of input boxes, or different macros w/ assigned shortcut keys, create your own "toggle". -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: After I have selected "after pressing enter - move selection", and I select "Down". Are there any Keyboard shortcuts that will toggle the selection to either right, up, or left while I am working in the spreadsheet? I know how to do this in excel options, but was looking for a quicker way to do it. Thanks for your help! -- Rick "Luke M" wrote: Shift+Enter will change active cell to one above (assuming default is one below) If only 1 cell is selected, Ctrl+Enter will not move active cell (if multiple cells are selected and you press Ctrl+Enter, the value inputed into active cell will be applied to all cells within selection). And of course, Tab & Shift+Tab move cell to right/left. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "RickMoore" wrote: Is there a keyboard shortcut that changes the direction of the move when pressing enter? I know how to do it in excel options, but I was wondering if there was a shortcut. -- Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the direction when pressing ENTER? (dn, rt, etc.) | Excel Worksheet Functions | |||
How do I change the direction of my cursor when I press enter? | Excel Discussion (Misc queries) | |||
change direction when hitting enter key | Excel Discussion (Misc queries) | |||
Pressing enter to change cell | Excel Discussion (Misc queries) | |||
How do I change direction of Enter Key in EXCEL 2007 | Excel Worksheet Functions |