Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,071
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the direction when pressing ENTER? (dn, rt, etc.) CGN Bear Excel Worksheet Functions 3 July 15th 09 06:29 PM
how do I change which cell becomes active when enter is pressed? scotpiper Excel Discussion (Misc queries) 1 April 7th 09 12:18 AM
change direction when hitting enter key Using Excel in Conifer Excel Discussion (Misc queries) 1 March 5th 09 09:13 PM
How do I change the direction of the cell when I press enter jonathan New Users to Excel 1 January 8th 09 03:25 PM
How to change the active cell outline indicator color in Excel? YoYo74 Excel Discussion (Misc queries) 2 January 11th 06 02:37 PM


All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"