ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   change direction active cell indicator moves when enter key is pre (https://www.excelbanter.com/excel-discussion-misc-queries/243198-change-direction-active-cell-indicator-moves-when-enter-key-pre.html)

ldavidm

change direction active cell indicator moves when enter key is pre
 
when i press enter key, the active cell indicator moves down. i need to have
it move left along the row. This function used to be changeable in the edit
section of older excel programs. You could change the direction to suit the
worksheet and type of data you were working with.

Otto Moehrbach[_2_]

change direction active cell indicator moves when enter key is pre
 
Go to Tools - Options - Edit tab. Find "Move selection after enter" and
choose the direction you want. HTH Otto
"ldavidm" wrote in message
...
when i press enter key, the active cell indicator moves down. i need to
have
it move left along the row. This function used to be changeable in the
edit
section of older excel programs. You could change the direction to suit
the
worksheet and type of data you were working with.




Jacob Skaria

change direction active cell indicator moves when enter key is pre
 
Check out the first option in Office buttonExcel OptionsAdvanced
--
If this post helps click Yes
---------------
Jacob Skaria


"ldavidm" wrote:

when i press enter key, the active cell indicator moves down. i need to have
it move left along the row. This function used to be changeable in the edit
section of older excel programs. You could change the direction to suit the
worksheet and type of data you were working with.



All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com