Excel moves a cell pointer

In the worksheet, each cell has a data, and when we use the worksheet we need to move to the destination in these cells, and there are several ways to move the cell pointer in Excel, which we'll introduce separately.

3.2.1 Moves within display range

If the destination cell is on the current display area, point to the destination cell, and then click on it. If the cell you want to specify is not in the current display area, for example, we want to move from the A3 cell to the F14 cell, just point to the F14 cell, and then click.

3.2.2 Use the Name box to move

We can also insert the destination cell's address in the Name box and press the ENTER key, as shown in Figure 3-9. For example, if you first enter the cell position "A29" or "A23:b27" in the Name box, and then press [Enter], we'll see that the specified cell appears in the current screen.

3.2.3 Use positioning command

In addition, we can also choose the "position" command from the Edit menu, move the pointer over the target cell; When you perform the position command, a dialog box like Figure 3-10 appears on the screen, entering the address of the target cell, and then pressing the OK button.