Press Enter To Move To The Next Column (Excel 2002/2003)

If you are an Excel user, you already know that when you press Enter, the cursor does not move to a cell to the right, it moves to the cell below. This can be an annoyance to some if you continually press Enter but then have to move the cursor into the correct cell.

You can easily change this behavior by completing the steps listed below:

  1. Open Excel. From the Tools menu, click Options.

  2. Click the Edit tab from the Options dialog box.
  3. Under the Move selection after Enter section, click the drop down arrow beside Direction and change the value to Right.
  4. Click OK to close the Options dialog box and save your changes.
Article Written by

  • BA

    Please help me with the following problem :
    When I come to a particular cell, say D2, and press ENTER then I want the selection to move to cell A3 (which is the next row first column). So how do i do this pls?

    Thanks !!

  • Hadli

    Thank you very much for your help!!!

  • Aaron

    Nice and fast tutorial as they all sould be! thanks!