ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   When i press "ENTER", it move rightward, (i want it to go down!) (https://www.excelbanter.com/excel-discussion-misc-queries/157210-when-i-press-enter-move-rightward-i-want-go-down.html)

ali

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!
--
---------

StephenAccountant

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!
--
---------


ali

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!
--
---------



All times are GMT +1. The time now is 05:14 AM.

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