And you will see that the cursor has moved to the last line of the worksheet. Press the END key on the keyboard, and then the "down arrow" (or use the combination of CTRL+"down arrow"). Open a new worksheet and place the cursor in any column. On a practical example, we quickly check the number of rows in a sheet. Move the cursor to the end of the worksheet But in the further lessons, we will use only the shortest. Most functions in Excel can be implemented in several ways. If the cell needs to be searched but its address is known in advance, it is better to use the "NameBox" field or the "Go To" tool.
If the remote cell to which the cursor should be moved to make it active is situated in the same screen (view without scrolling), then it is better to use the mouse. The cursor will instantly move to the specified address. Enter in this field D3 (or d3) and press "Enter". To quickly move the cursor to any address of a worksheet cell, it is also convenient to use the "NameBox" field which is in the upper left corner under the tool bar at the same level as the formula line. In the opened window enter D3 (you can enter it with small letters d3, and the program itself replaces small letters in large letters and in formulas it works in the same way), then click OK. Or you can press the combination of the hotkeys CTRL+G or F5. To use it, you need to open the drop-down list of the "Find" tool on the "Home" tab and select the "Go To" option. To solve this task, you can also use the "Go To" tool.
After all, for the keyboard, it is 3 keystrokes. Try in the same way to move the cursor (black rectangle) to cell D3.Īs you can see, in the given task the shortest way is to make 1 click with the mouse. We moved along neighboring cells (C A1 to A2) in the above-described example. And tables in sheets for data filling can be both vertical and horizontal. 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.
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
0 kommentar(er)
