How can I set the column that excel returns to when I hit Enter?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I am done entering info on one line and hit Enter/Return sometimes it
goes to the next row in column A and sometimes it goes to another cell in
the next row. There doesn't seem to be any rhyme or reason to it. Is there a
way to set it return where you want?
 
Tools -> Options -> Edit tab

You can choose "Move Selection after enter is pressed" and choose which
direction.

If you want to move differently depending on what cell you are in,
you'll have to get in to VBA to capture the Enter keypress and move the
cursor appropriately.

John
 
Go to "Tools" - "Options" - Pick the "Edit" tab, Check the box by "Move
selection after Enter" and pick your direction.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return to next row in first column when entering data in Excel 3
How can I set up an auto return to the next column in excell? 3
how do I set tabs in Microsoft Office Excel 2007? 4
hit enter in any column and go to next row in first column 3
using the =page! feature to transpose a row to column 0
Vlookup and return sheet name also 2
how to insert individual lines into a cell 3
HOW DO I CREATE AN AUTO RETURN IN A COLUMN THAT IS OFF MY WORKSHEE 5

Back
Top