How do names work

[Giordano Bruno]

I have a workbook with several worksheets. When I view the names in the workbook in "Sheet1" (Insert Names Define), I see all of the names. Those which relate to "Sheet1" have "Sheet1" on the right hand side. Those which refer to other sheets have white space on the right hand side.

But some of the names refer to other sheets yet have "Sheet1" on the right hand side. Does anyone know A. How this happened and B. What is going on.

 

[Andrew Poulsom]

You can create a sheet level name by preceding it with a reference to the sheet when you create it, eg:

Sheet1!MyName

Sheet level names appear in the list of Names in workbook only when the relevant sheet is active.

Excel uses sheet level names for Print_Area and Print_Titles.

 

[Gates Is Antichrist]

This usually arises when you copy a worksheet where a "workbook level" name exists; you then have a worksheet-specific level version of the name on the copy. I normally try to get rid of them to avoid confusion - except for the names Criteria and DataBase, which I create for filters, whose scope is never beyond individual worksheets, so I'll let them "live." However, there are other circumstances where the "local" (sheet-specific) cases can be useful.

 

[Giordano Bruno]

Thank you Andrew and Gates. Two helpful explanations to something that has bothered me for some time.

 

[lenze]

As a side note, you can view and paste and print a list of all the names in the workbook using F3 or ALT+I+N+P

lenze