Scoping names

A named cell or range normally has a workbook-level scope. In other words, you can use the name in any worksheet in the workbook.

Another option is to create names that have a worksheet-level scope. To create a worksheet-level name, define the name by preceding it with the worksheet name followed by an exclamation point: for example, Sheet1!Sales. If the name is used on the sheet in which it is designed, you can omit the sheet qualifier when you reference the name. You can, however, reference a worksheet-level name on a different sheet if you precede the name with the sheet qualifier.

The Name Manager dialog box (Formulas Defined Names Name Manager) makes it easy to identify names by their scope (see Figure 3-3). Note that you can sort the names within this dialog box. For example, click the Scope column header, and the names are sorted by scope.

Hnmv M.HM-JIT

1 a»- 1

6<tr... | [ (¡M*

ftftje

RctarTo

înrr

CEjai

fw.'aff.w, ..

rtyMM

{.ïfttrwr

fw.-ar.w.t,.

-îhKH'ttKjit'i

Slwi

H—

iiH'.'JJr.-Ji'.'u,,

-Wri ff lï:f£ i !

9wtt

Cum

-TwIL iBI3:lEES

¡MOI

| ^-.hrtT

HTur.Tsir.TaL",...

•AM (SP!j£>K3

-iHili

rtikïMk

{WJTHVIW;-,,

-WtliflfiKli

NMMt

e ■■QÎ J

fniVz] l'île»': ..

risflbx*

■TW.-7JÏV»!'

«as sem:£f4

■fHIÎHIÉËll

Hatkatk

HJTJUH

rJw'.W.^MVZ--

HtriU

Figure 3-3: The Name Manager displays the scope for each defined name.

0 0

Post a comment