kasceguitar.blogg.se

It is very convenient when the cursor itself moves in the desired direction after entering data into the cell. In certain situations of filling / changing data, you will often have to use this feature. Remember that the changes in this setting will make your work in Excel more comfortable. Below in the option specify the direction you want as shown in the picture: We are interested here with this option: "After pressing Enter, move selection Direction:". In the opened window select the "Advanced" option. Open the "Excel Options" window through the "FILE" - "Options" menu. If necessary, this can be changed in the program settings. Also, an additional example can serve this task and show how you can find solutions in several ways in Excel.īy default, the parameter for moving the cursor in Excel after pressing the "Enter" key is directed to the bottom, to the bottom cell (and if you press SHIFT+ENTER, the cursor will go to the top cell). Sometimes it is better to click, and sometimes it's better to move the cursor with the "Enter" key. Over time, in the process of working with Excel, you will notice that each option has its own advantages in certain situations. Using the "Name" field (located to the left of the formula line).Point your mouse at the cell with address A2 and click the left mouse button.(All the arrows on the keyboard affect the movement of the cursor respectively with its direction). Moving between the cells by using arrows keys.When the program is loaded by default, the cursor is located on the cell with the address A1. Move the cursor to the bottom (next) cell. Moving the cursor to the next cell in the bottom