How to change the direction after pressing Enter key in Excel?
Have you noticed that Excel moves the cursor down to the next row automatically when you press Enter key after typing data into a cell? But if you want the cursor to go in a different direction, such as to right, left or up, how could you do?
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To change the default direction of selected cell after pressing Enter key, you can solve it with the following steps:
1. Open your workbook, and go to File button, then click Options in the pane.
2. In the popped out Excel Options dialog, click Advanced from the left pane, and in the right section, check After pressing Enter, move selection option under the Editing options section, then click the Direction drop down list and choose the direction you need (Right, Up, Left). See screenshot:
3. Then click OK to close this dialog, and when you press Enter key after typing the data nest time, the direction of the cursor will be changed to your need.
Tip: In Excel 2007, click Office button > Excel Options to go to the Excel Options dialog.
Recommended Productivity Tools
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 6 months agonice. But how do you set the movement to be workbook specific? Most wookbooks i need the selected cell to move down on <enter> but on a few, i need it to move right.
To post as a guest, your comment is unpublished.· 3 years agokey microsoft office