Select specific cells or ranges
Whether or not you define named cells or ranges on your worksheet, you can use the Name box to quickly locate and select them by entering their names or their cell references . You can also select named or unnamed cells or ranges by using the Go To command.
Important To select named cells and ranges, you must first define them on your worksheet . For more information about defining names for cell references or ranges on your worksheet, see Define named cell references or ranges.What do you want to do?
Select cells or ranges by using the Name box
Select cells or ranges by using the Go To command
Select cells or ranges by using the Name box
- In the
Namebox, 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
Namebox, and then click the name that you want. - To select two or more named cell references or ranges, click the arrow next to the
Namebox, 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 theNamebox. - 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.
- To select a named cell or range, type its name and then press ENTER, or click the arrow next to the
Select cells or ranges by using the Go To command
- On the
Hometab, in theEditinggroup, clickFind & Select, and then clickGo To.
Keyboard shortcut You can also press CTRL+G.
- In the
Go tolist, click the name of the cell or range that you want to select, or type the cell reference in theReferencebox.For example, in the
Referencebox, 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, double-click the name of the cell reference in the Go to list.