you might use this method to create unique names that are recognized by every sheet in a workbook.
key in thedesired name for that range in theName Box, such asJan_Sales.
Press theEnterkey on the keyboard.
The name is displayed in theName Box.
The name is also displayed in theName boxwhenever the same range of cells is highlighted in the worksheet.
It is also displayed in theName Manager.
This dialog box is opened using theDefine Nameoption located in the middle of theFormulastab of theribbon.
The New Name dialog box makes it easy to define names with a worksheet level scope.
To create a name using New Name dialog box:
Select theFormulastab of the ribbon.
Select theDefine Nameoption to open theNew Namedialog box.
Enter theName,Scope, andRangein the dialog box.
Once completed, selectOKto return to the worksheet.
The name displays in theName Boxwhenever the defined range is selected.
When defining a name in theName Managerit opens theNew Namedialog box outlined above.
In theName Manager, select theNewbutton to open theNew Namedialog box.
Enter aName,Scope, andRange.
SelectOKto return to the worksheet.
The name displays in theName Boxwhenever the defined range is selected.
To delete the name, select theDeletebutton above the list window.
To edit the name, select theEditbutton to open theEdit Namedialog box.
The scope of an existing name cannot be changed using the edit options.
To change the scope, delete the name and redefine it with the correct scope.
A name must be unique within its scope, but the same name can be used in different scopes.
The default scope for new names is the global workbook level.
Once defined, the scope of a name cannot easily be changed.
Such a situation, however, would create a conflict whenever the name was used.
In such a situation, a sheet-level name of2014_Revenuewould be used instead of a workbook level name of2014_Revenue.
Scopes linked tosheet 1of any workbook cannot be overridden by global level names.
