Excel Moves a cell pointer

Source: Internet
Author: User

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.

3.2.4 Use the keyboard to move

You can also use the keyboard to move the cell pointer, as shown in table 3-1.

The attentive reader may have found out from the table above that we used commas "," for some key combinations, and we used the plus sign "+", what's the difference here? We'll explain it below. Here, for "," we use the [end] key as an example to illustrate its particular usage. First type the data series as shown in Figure 3-11 on the worksheet. Click cell "A4". Press the [end] key and we'll see an indicator on the status bar.

by pressing the [→] key, we see that the cell pointer already points to the "C4" cell. Press [end] again and press [→] to see that the cell pointer is already pointing to the "F4" cell, as shown in Figure 3-12.

Press the [end] key again. by pressing the [→] key, we see that the cell pointer already points to the "IV4" cell and displays the current cell address in the Name box, as shown in Figure 3-13.

As you can see, when the [end] key and the arrow keys are used together, you can make the cursor move faster. When the cell to the right of the cell pointer is empty, press the [end] key, and then press the [→] key, until you get to the right of the cell or worksheet that contains the data.

For example, the first time you press [end] and [→] keys, the right side of the cell pointer is empty, so the pointer moves right until it encounters the cell "C4" where the data exists and stops on "C4". When the cell pointer and the cell to the right of the cell have data, if the [end] key and the [→] key are pressed, the pointer moves to the right until it touches the empty cell and stops on the cell that contains the data. The second time you press the [end] key and the [→] key, the cell pointer moves to the right and stops at the first blank cell "F4" on the right.

The last time you use the [end] key and the [→] key, there is no data on the right side of the cell. As a result, the cell pointer moves right until it touches the cell that contains the data and to the far right of the worksheet, where there is no data on the right side of "F4", so the pointer moves to the far right of the worksheet, which is column IV, There are 256 rows in the worksheet. By pressing the [end] key and the [→] key, you can see whether the cell to the right of the pointer has data. To use the [end] key and the [↓] key, you can see whether a cell under the cell pointer has data, and the move rule is the same.

From the above we can see that the use of commas is the first press the previous button, and then press the Back button. For the plus sign (+), here is the meaning to be pressed at the same time, for example: when we press [Ctrl]+[home] at the same time in Figure 3-13, we see the cell pointer again pointing to the "A1" cell.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.