How to set Enter key direction in MS Excel? Change cursor position after pressing Enter key on Keyboard in Microsoft Excel. Change Enter key direction Up, Down, Left, Right in Excel spreadsheet or workbook manually.
Every time when we press Enter key on the computer keyboard in Microsoft Excel, the cursor move downwards in the cells. So, Can we change the Enter key behavior / behaviour in Excell? Suppose every time when you press Enter in MS Excel, you want to move your cursor left, right or up instead of down which is by default in Excel. Is this possible in Excel? The answer is absolutely yes.
 |
| Office button |
So, changing or setting Enter key direction / behaviour in MS Excel is not a very hard / tough exercise. you can easily change this by follow some of the given steps:-
1) Open your Ms Excel and click on the File Menu in MS Excel 2010, in MS Excel 2007 click on the office button which is in upper left corner of the Excel Spreadsheet or Workbook.
2) Click on the Options menu, a window named as Excel Options will open.
3) Click on the Advanced menu / option.
4) In Editing options, there will be an option- "After pressing Enter, move selection
Direction:"
5) Change or set the direction as per your requirement or you want from the drop down list. Enjoy.
0 comments:
Post a Comment