Locate and select named or unnamed cells or cell ranges

 Important   To select named cells and ranges, you must first define them on your worksheet (worksheet: The primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.). For more information about defining names for cell references or ranges on your worksheet, see Define named cell references or ranges.

After you define named cells or ranges on your worksheet, you can use the Name box (Name box: Box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. To name a cell or range, type the name in the Name box and press ENTER. To move to and select a named cell, click its name in the Name box.) to quickly locate and select named or unnamed cells or ranges (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) by entering their names or their cell references (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.). You can also select named or unnamed cells or ranges by using the Go To command (Edit menu).

What do you want to do?

Select cells or ranges by using the box

Select cells or ranges by using the command

Select cells or ranges by using the Name box

  • In the Name box, located at the left end 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 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 other cells or ranges in the Name box.
    • To select an unnamed cell reference or range, type the cell reference of the cell or range of cells that you want to select, and then press ENTER.

For example, type B3 to select that cell, or type B1:B3 to select a range of three cells.

Top of Page Top of Page

Select cells or ranges by using the Go To command

  1. On the Edit menu, click Go To, or press CTRL+G.

Tip    If you do not see Go To on the Edit menu, click Expand Button image at the bottom of the menu.

  1. In the Go to list, click the name of the cell or range that you want to select, or type the cell reference in the Reference box.

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

 Note   In the Go to list, you can view all the named or unnamed cells or ranges that you previously selected by using the Go To command. To return to a previous selection, click Go To on the Edit menu, and then double-click the name of the cell reference in the Go to list.

Top of Page Top of Page

 
 
Applies to:
Excel 2003