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
addresses:
=SUM(DailySales)*CommissionRate
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
Editing
Find & Select
Go To (or F5) and specifying the range
name.
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
addresses.
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
name.
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.
 
Search JabSto ::




Custom Search