Microsoft Office Tutorials and References
In Depth Information
A Name’s Scope
This formula works fine, but its purpose is not at all clear. To help clarify the formula, you can
define a descriptive name for the daily sales range and another descriptive name for cell C1.
Assume, for this example, that the range B2:B200 is named DailySales and cell C1 is named
CommissionRate. You can then rewrite the formula to use the names instead of the actual range
As you can see, using names instead of cell references makes the formula self-documenting and
much easier to understand.
Using named cells and ranges offers a number of advantages:
h Names make your formulas more understandable and easier to use, especially for people
who didn’t create the worksheet. Obviously, a formula such as =Income–Taxes is more
intuitive than =D20–D40.
h When entering formulas, a descriptive range name (such as Total_Income ) is easier to
remember than a cell address (such as AC21). And typing a name is less likely to result in
an error than entering a cell or range address.
h You can quickly move to areas of your worksheet either by using the Name box, located
at the left side of the Formula bar (click the arrow for a drop-down list of defined names),
or by choosing Home
Find & Select
Go To (or F5) and specifying the range
h When you select a named cell or range, its name appears in the Name box. This is a good
way to verify that your names refer to the correct cells.
h You may find that creating formulas is easier if you use named cells. You can easily insert a
name into a formula by using the drop-down list that’s displayed when you enter a formula.
h Macros are easier to create and maintain when you use range names rather than cell
A Name’s Scope
Before I explain how to create and work with names, it’s important to understand that all names
have a scope. A name’s scope defines where you can use the name. Names are scoped at either
of two levels:
h Workbook-level names: Can be used in any worksheet. This is the default type of range
h Worksheet-level names: Can be used only in the worksheet in which they are defined,
unless they are preceded with the worksheet’s name. A workbook may contain multiple
worksheet-level names that are identical.