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