These names can benamed ranges, named formulas, and named constants.

Using named ranges can make formulas easier to read, understand.

and maintain Names also provide simple navigation via theName Box.

Names in a formula example

To launch the Name Manager, navigate to Formulas > Name Manager.

Or, you’re able to use the keyboard shortcutControl + F3.

Names ranges

A named range is one or more cells that have been given a name.

Names in a formula example

Using named ranges can make formulas easier to read and understand.

They also provide simple navigation via theName Box.

For more information, see:Named Ranges in Excel

Names in a formula example

Names in a formula example

Names in a formula example