E-Mail:

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.

2 Comments

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

Thank you very much for your help!!!

What Do You Think?

 

Want to Start a Blog Here for Free?

Are you an expert in one subject or another? If your goal is to help others and dispense hard-earned information back to the community, stake a claim on your very own Lockergnome blog today! You can write about anything - no matter the topic. Sign-up to start blogging!

Favorite - Oct 10, 2008

Scour

Download, Freeware - Oct 9, 2008

CurrPorts v1.51

Download, Freeware - Oct 6, 2008

AudioGrail v6.13.2.158

Download, Freeware - Oct 3, 2008

SniffPass v1.07

83 queries / 2.039 seconds.