Selected methods for specific cells or ranges in Excel

Whether or not you define a named cell or range (range: two or more cells on a worksheet) in an Excel worksheet. Cells in a range can be contiguous or nonadjacent. , you can use the Name box (Name box: The box at the left end of the formula bar to indicate the selected cell, chart item, or drawing object.) To name a cell or range, type a name in the Name box and press Enter. To move to a named cell and select the cell, click its name in the Name box. By entering their name or cell reference cell reference: the set of coordinates that represents where a cell is located on a worksheet. For example, the cell that appears at the intersection of Column B and line 3rd is referred to as "B3". ) quickly locate and select them. You can also select a named or unnamed cell or range by using the Locate command.

　　important To select a named cell and range, you must first be in the worksheet worksheet: The primary document for storing and processing data in Excel. Also known as spreadsheets. Worksheets are made up of cells that arrange rows or columns. The worksheet is always stored in the workbook. ) are defined. For more information about defining names for cell references or ranges on a worksheet, see define named cell references or ranges.

Select a cell or range by using the name box

In the Name box, located at the leftmost of the formula bar, do one of the following:

• To select a named cell or range, type its name, and then press Enter, or click the arrow next to the Name box, and then click the name that you want.

• To select two or more named cell references or ranges, click the arrow next to the Name box, and then click the name of the first cell reference or range that you want to select. Then hold down CTRL while you click the names of the other cells or ranges in the Name box.

• To select an unnamed cell reference or range, type the cell reference for the cell or range of cells you want to select, and then press Enter.

For example, type B3 to select the cell, or type B1:B3 to select a range that contains 3 cells.

Use the Locate command to select a cell or range

1, on the Start tab, in the Edit group, click Find and select, and then click Locate.

Keyboard shortcuts can also be pressed ctrl+g.

2. In the position list, click the name of the cell or range you want to select, or type the cell reference in the Reference Location box.

For example, in the Reference Location box, type B3 to select the cell, or type B1:B3 to select a range that contains 3 cells.

　　Note in the Locate list, you can view all named or unnamed cells or ranges that you previously selected with the position command. To return to a previous selection, double-click the name of the cell reference in the Go to list.