![]() Thus, if the Direction drop-down list is set to Down, and you press Shift+Enter, then Excel actually moves the selection upwards. There is one interesting thing about how Excel selects a new cell: If you press Shift+Enter (instead of Enter) when entering data, then Excel selects the cell in the opposite direction of what you have specified in step 4. Use the Direction drop-down list to specify the direction that Excel should move.Make sure the After Pressing Enter Move Selection check box is selected. ![]() The Advanced options in the Excel Options dialog box. In Customize Ribbon, checkmark the Developer (Custom) option to enable the tab in the menu bar and click on Ok, as shown below. At the left of the dialog box click Advanced. Go to the File menu to select Options, as shown in the below screenshot.In Excel 2010 and later versions, display the File tab of the ribbon and then click Options.) (In Excel 2007 click the Office button and then click Excel Options. You can configure Excel to move in a different direction after pressing Enter by following these steps: When you enter information in a cell, and then press the Enter key, Excel normally moves to the cell below the one in which you entered the information. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |