Question:
When I hit enter after typing an item, Excel automatically takes me to the cell below the current cell. Is there anyway to change this so that it
moves to the cell on the right?
Answer:
Changing this feature can be valuable, particularly when you have to do a lot of data entry.
Here's how you make the change.
Click on the Tools menu, and select Options.
Click the Edit tab.
Make sure Move selection after Enter is
checked.
Next to Direction,
choose Right.
Click OK.
This works with Excel 2003 only. For the Excel 2007 instructions, click here.
No comments:
Post a Comment