Set "Enter" Key Direction

 You might have noticed that whenever you press "Enter" key, the cell below is always selected. This is because the default setting in Excel is to go "Down". However MS Excel provides an option to change this settings. Please follow the below steps if you wish to change this setting.

1. Choose "File" from Excel Ribbon

2. You will be shown a screen, like the one below. Click on "Options"

3. A pop-up will open on the screen as one below. Click on "Advanced" 

4.  Now choose the direction you wish to change it to and press "OK"

5. The set direction will be in place now.