You can immediately locate any of the cells contained in one of your named
ranges by simply selecting the name from the Name Box. Excel
highlights all the cells contained in the named range you select.
To use named ranges in formulas and functions:
1. Select the cell that will contain the formula or function.
2. Type the formula or function using named ranges in place of cell
references, as shown in the graphic below. In this example, we are
creating a total for all four quarters of a fiscal year for the Northern
region. A different named range was created for the data in each quarter,
as above.
3. Press
Enter to make the calculation based on your named
ranges. The figure below shows the result of the formula.
Deleting a Named Range
Use caution if you need to delete a named range. Make sure the name is not
being used in any formulas or functions.
1. From the
Insert menu, choose Name and Define.
2. In the
Define Name dialog box, select the named range you would
like to delete.
3. Press
Delete.
4. Choose
OK.
It's 4:45pm. You smile and take the new Excel file in to Mr.
Itnow.
You show him how he can click on a total and see named ranges in the formula
bar, and then explain that all he has to do is select the name of one of the
ranges from the Name Box to see which cells those numbers came
from. He is very impressed and tells you to take the rest of the day
off. Wow - a whole 15 minutes all to yourself!
