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

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

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

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

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

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

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

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