Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
ali ali is offline
external usenet poster
 
Posts: 7
Default When i press "ENTER", it move rightward, (i want it to go down!)

IN Excel, when i press "ENTER", it moves to the cell next to it. But i want
it to move "one cell under" (go downward) the active cell.

How do i change the settings?



Cuz before i wasn't like this!
--
---------
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default When i press "ENTER", it move rightward, (i want it to go down!)

Click on Tools and then OPTIONS and then click on the tab EDIT.

There you will see an option: Move selection after Enter

There will be a drop down box where you will be able to choose.

"ali" wrote:

IN Excel, when i press "ENTER", it moves to the cell next to it. But i want
it to move "one cell under" (go downward) the active cell.

How do i change the settings?



Cuz before i wasn't like this!
--
---------

  #3   Report Post  
Posted to microsoft.public.excel.misc
ali ali is offline
external usenet poster
 
Posts: 7
Default When i press "ENTER", it move rightward, (i want it to go down

hey Stephen!!

you rock !! , it works,

thanks a lot ! !
--
---------


"StephenAccountant" wrote:

Click on Tools and then OPTIONS and then click on the tab EDIT.

There you will see an option: Move selection after Enter

There will be a drop down box where you will be able to choose.

"ali" wrote:

IN Excel, when i press "ENTER", it moves to the cell next to it. But i want
it to move "one cell under" (go downward) the active cell.

How do i change the settings?



Cuz before i wasn't like this!
--
---------

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 to change "move selection after enter" in office 2007 Bert Excel Discussion (Misc queries) 2 June 7th 07 06:41 PM
Click "Enter" move to cell to the right, not down in Excel Art Bahrnone Excel Worksheet Functions 1 March 20th 07 03:38 AM
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! [email protected] Excel Discussion (Misc queries) 3 January 5th 07 02:18 PM
Make "Edit" mode default, rather than "Enter"? Greg Boettcher Excel Discussion (Misc queries) 1 July 27th 06 01:46 AM
must press enter 2x to move cell focus Lynn Excel Discussion (Misc queries) 0 March 18th 05 06:05 PM


All times are GMT +1. The time now is 01:41 PM.

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"