The Name Manager dialog can be used to create a custom name. This dialog is located under the Formulas tab.

The New Name dialog is displayed after clicking New. Type a name for the custom name and select the scope. Type a formula or cell range in the Refers to box. Click OK to add the custom name to the list of available custom names.

Absolute references are recommended. Relative references are adjusted based on the active cell location when the custom name is created.