Office hacks: Excel “name box” to choose a quick wind

Excel formulas located at the top of the box on the left side of the input box is the “name box”, we generally use it to specify a cell or cell area alias. Usually people rarely use the name box. In fact, the name box in determining the scope of the form content, but also has its own unique and extensive use, use it well, you can greatly improve the efficiency of the form content selection.

1. quickly reach the specified cell or area

To quickly transfer the cursor to a specific cell, simply type the address of the cell in the name box. For example, to reach cell D1899, type D1899 in the “Name” box, the cell will be active.

If you want to select a specific cell area, you can also use the name box. For example, to select the range from C8 to E13, you can type C8:E13 in the “Name” box and press Enter. Then, even if the cursor is far away, after the implementation of this operation, will immediately reach and select the Excel name box specified in the C8:E13 area range (Figure 1).

1921A-MCK-1

The above technique can avoid repeated scrolling operations when positioning at a distance.

2. Select continuous or non-contiguous cells or ranges

In the cell selection using Ctrl and Shift, you can achieve similar effects to the selection of contiguous or non-contiguous files or text.

For example, the currently active cell is B8, type C10 in the “Name” box, hold down the Shift key and press the Enter key, you can see the B8:C10 range is automatically selected. If you press Shift instead of Ctrl, we will see that only B8 and C10 two cells will be selected (Figure 2).

1921A-MCK-2

If you need to manually select multiple non-contiguous cells, you can separate the cells with commas. For example, in the “Name” box, type B4,E7,G8, and then press the Enter key, B4, E7, G8, the three cells will be selected. Please note that the use of commas can not have any spaces between them, and the comma is a half-angle symbol (Figure 3).

1921A-MCK-3

If you want to select a non-contiguous cell area, you can also use this technique. For example, in the “Name” box, type B4:C7,E4:G7, and then press the Enter key, you can see the selection of B4 to C7 and E4 to G7 two specific range (Figure 4).

1921A-MCK-4

If you want to quickly add another selection to a selected area, first select an area, such as A2:D4 in the worksheet, and then type E8:H12 in the “Name” box. to the selected area (Figure 5). Try to see what happens if the Shift key is pressed.

1921A-MCK-5

3. Whole row, whole column or row-crossing area selection

Use the Name box to quickly select an entire row or column. Type 3:3 in the Name box and you will see that row 3 is selected. If you type 3:6, rows 3 through 6 are selected. If you type B:B, then column B is selected; if you type B:F, then column B to F is selected. Remember that the letters refer to the columns and the numbers refer to the rows. Again, we can use the name box to select multiple specific rows. Type 2:6,10:14 and press Enter to see that rows 2 to 6 and 10 to 14 are selected. Similarly, you can select multiple columns.

If you want to select specific rows and columns at once, for example row 7 and column G, type G:G,7:7 in the “Name” box and press Enter to see the entire column G and the entire row 7 selected. Similarly, type C:E,6:8 and press Enter, you can see that columns C to E and 6 to 8 rows are selected together (Figure 6).

1921A-MCK-6

We can also identify areas based on the intersection of the rows and columns mentioned in the Name box. For example, type C:E 8:13 in the “Name” box and press Enter to see the intersection of C8 to E13 selected (Figure 7). This is useful for automatically finding the intersection of two data areas. The difference from the previous trick is that one uses a comma and the other uses a space.

1921A-MCK-7

Tip.

If you want to select the column where the current cursor is located, you can also type C in the “Name” box, and then press Enter; if you want to select the active cell is located in the entire row, type R in the “Name” box, and then press Enter to (Figure 8).

1921A-MCK-8

4. Cancel the selected area and return to the active cell

After selecting a region on the worksheet, if you type RC in the “Name” box and press the Enter key, you will see the cursor will return to the previously active cell, the selected selection is automatically canceled.

Tip.

Select a cell or region on the worksheet, type a name in the “Name” box, and then press Enter to assign an alias to the selected range. “Name” will make the formula to call the region easier, if you want to select a range in the formula, just select the name from the “Name” box can be.

QQ图片20210420165237

Leave a Comment