Select named cells or ranges using the Name box in Excel 2007

You have to name the cells or ranges in order to select named cells or ranges using the Name box. Assuming that you had already named the cells or ranges, do as per in the following line:

In the Name box, click the arrow and then click the name.

Tip:

#1. To select two or more names, click the arrow in the Name box and click the name. Press and hold the CTRL key. Click the arrow in the Name box and click the other name.

#2. You can click on only one name at a time. You have to click the arrow in the Name box and click the other name and repeat doing this for the number of names that you want to select.

#3. You cannot delete a name from the Name box.

To know how to name a cell or range, click here.