Microsoft Office Tutorials and References
In Depth Information
Creating Worksheet-Level Names
Creating Worksheet-Level Names
Normally, when you name a cell or range, you can use that name in all worksheets in the
workbook. For example, if you create a name, RegionTotal, that refers to cell M32 on Sheet1, you can
use this name in any formula in any worksheet. This name is a workbook-level name (or a global
name). By default, all cell and range names are workbook-level names.
Suppose that you have several worksheets in a workbook and you want to use the same name
(such as RegionTotal) on each sheet. In this case, you should create worksheet-level names
(sometimes referred to as local names).
To define the worksheet-level name RegionTotal, activate the worksheet in which you want to
define the name and choose Formulas
Define Name. The New Name dialog
box then appears. Enter the name in the Name field, and use the Scope drop-down list to select
the sheet in which the name is valid. Figure 92-1 shows a worksheet-level name being created.
Defined Names
Figure 92-1: Creating a worksheet-level name.
You can also create a worksheet-level name by using the Name box (located to the left of the
Formula bar). Select the cell or range you want named, click in the Name box, and type the name,
preceded by the sheet name and an exclamation point. Press Enter to create the name. Here’s an
example of a worksheet-level name:
If the worksheet name contains at least one space, enclose the worksheet name in apostrophes,
like this:
‘Western Region’!RegionTotal
When you write a formula that uses a worksheet-level name on the sheet in which you defined it,
you don’t need to include the worksheet name in the range name. (The Name box doesn’t display
the worksheet name, either.) If you use the name in a formula on a different worksheet, however,
you must use the entire name (sheet name, exclamation point, and name).
Search JabSto ::

Custom Search